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… Read More »Next Weekly Free SQL Training: A Review
February 2015
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… Read More »Brown Bag Lunch: LinkedIn Pro Tips & How to Build Your Personal Brand
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… Read More »Weekly SQL Training – MERGE Statement and Recursive Queries
Training Employees
A great conversation, not original, but something found on LinkedIn For employee training, see our Stedman’s SQL School.
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… Read More »Using a Common Table Expression Instead of a Derived Table
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… Read More »Next Week’s Free SQL Training: MERGE Statement and Recursive Queries
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… Read More »What is a Common Table Expression
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… Read More »Weekly SQL Training – OUTPUT Clause and Derived Tables
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… Read More »TSQL OUTPUT Clause With UPDATE Statements
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… Read More »TSQL OUTPUT Clause on Insert Statements