On Thursday March 12th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare developers for the Microsoft 70-461 SQL Queries exam. This week we will be a two part session Using Cursors, followed by Using String Functions. This is provided free of charge to give back to the SQL community. Here is …

Using Cursors, followed by Using String Functions Read more »

Next week as part of the free SQL Query training that Aaron Buma and I provide, the topic I will be presenting is cursors. How to use them, what they are, everything you ever wanted to know. My concern in this presentation is that cursors have caused me many headaches in regard to performance over time. The main problem that …

SQL Server Cursors Good or Bad Read more »

As part of our weekly free SQL Query Training, we have split the 70-461 curriculum into 4 sections to prepare everyone to take the certification test later in the year. Today’s session is to review the first 25% of the sessions, or the section 1 review as we are calling it. The review topics we will be covering today are …

Today’s Training: SQL Queries Section 1 Review Read more »

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 training we have decided to do a review session on everything that we have covered so far. Null Expressions Identity …

Next Weekly Free SQL Training: A Review Read more »

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 will present on Recursive Queries. There MERGE statement is one of those that I was not familiar enough with when …

Weekly SQL Training – MERGE Statement and Recursive Queries Read more »

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 Developers for the 70-461 certification exam. Here is the basic abstract for the presentation: This will be a free training …

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

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 got further into it. Last week we covered some of the basics of Derived Tables or Subqueries, today we will …

Weekly SQL Training – OUTPUT Clause and Derived Tables Read more »

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 INSERT statement. What the output clause does is return a result set on queries that don’t usually return a result …

TSQL OUTPUT Clause on Insert Statements Read more »

On Thursday Feb 19th at 9:00am pacific time, Aaron Buma and I will be doing another FREE SQL query training session. This is a free training provided by Steve Stedman and Aaron Buma to prepare for the Microsoft 70-461 SQL Queries exam. This week we will cover OUTPUT Clause and Derived Tables.  This is provided free of charge to give back …

Next Free SQL Query Training – OUTPUT Clause and Derived Tables Read more »

As posted earlier. This weeks SQL Queries training for the 70-461 certification will be on Thursday at 9:00am (US pacific time). Please join the live broadcast on Google On Air Hangouts, or catch the recorded version on myYouTube Channel. Aaron Buma will be presenting the first half of the session and I will be presenting the second half. We will …

Downloads for this weeks SQL Training Read more »