Month: February 2015

Next Weekly Free SQL Training: A Review

We are currently about 25% of the way through the SQL Server 70-461 exam preparation class, which has been available through Google On Air Broadcasts every Thursday at 9:00am Pacific time. To celebrate the 25% mark, and to strengthen the

Posted in Classes, Query Certification Tagged with: , , , ,

Brown Bag Lunch: LinkedIn Pro Tips & How to Build Your Personal Brand

This week I had a chance to sit in on a great presentation provided by Sydney Ratzlaff. I learned a few things, and was able to build out my LinkedIn profile based on her help. Here are the slides from the

Posted in Uncategorized Tagged with:

Weekly SQL Training – MERGE Statement and Recursive Queries

The free SQL Server Queries weekly training is being presented by Steve Stedman. The training is being presented by Aaron Buma and myself. This week we are covering two topics, first the MERGE statement will be covered by Aaron, then I

Posted in Classes, CTE, Query Certification Tagged with: ,

Training Employees

A great conversation, not original, but something found on LinkedIn For employee training, see our Free SQL Query Training program.  

Posted in Uncategorized

Using a Common Table Expression Instead of a Derived Table

Here is a short video that shows how to convert those ugly derived table (SubQuery) queries into a common table expression to help clean up your TSQL code. This applies to Common Table Expressions on Microsoft SQL Server, and the

Posted in Classes, CTE Tagged with: , , , , , , ,

Next Week’s Free SQL Training: MERGE Statement and Recursive Queries

Next week, on Thursday Feb 26th Aaron Buma and I, as part of the Free SQL Training, will be presenting on the use of the MERGE Statement and how to do Recursive Queries. This is intended to help prepare TSQL

Posted in Classes, Query Certification Tagged with: , , , ,

What is a Common Table Expression

I just a added a video to YouTube titled “What is a Common Table Expression”.  This video covers the extreme basics of what a CTE is on Microsoft SQL Server, and how to write that CTE in TSQL. Here is

Posted in CTE Tagged with: , , , , , , ,

Weekly SQL Training – OUTPUT Clause and Derived Tables

The free SQL Server Queries weekly training is being presented by Steve Stedman and Aaron Buma. The name of the presentation started out as “OUTPUT Clause and Derived Tables“, however it evolved into “OUTPUT Clause Correlated Subqueries and Subquery Extensions” as we

Posted in Classes, Query Certification Tagged with:

TSQL OUTPUT Clause With UPDATE Statements

Earlier in the week I added a blog entry on using the OUTPUT Clause on INSERT Statements, today I will expand it by exploring the use of the OUTPUT clause with UPDATE statements. Generally when you do an UPDATE statement you only

Posted in 70-461 Training, TSQL Tagged with: , , , , ,

TSQL OUTPUT Clause on Insert Statements

One of the often overlooked features of SQL Server is the OUTPUT clause, which applies to INSERT, UPDATE, DELETE, and MERGE statements. In this post we are going to go over the basics of using the OUTPUT clause on an

Posted in Query Certification Tagged with: , , , ,
Top