Tag: Aaron Buma

By Posted on Posted in 70-461 Training No Comments Tagged with , , ,

Here is the outline: Using Cursors Using String Functions Here is the link to the Google On Air Broadcast where you can watch for free. https://plus.google.com/events/ci8jms67qttuteegimrf4sj70sk After the presentation, I will update this page with a link to the YouTube video. This session will be about 90 minutes, Aaron Buma will present about half and I will present the other …

Today’s Live Training: Using Cursors and TSQL String Functions Read more »

By Posted on Posted in Query Certification 2 Comments Tagged with ,

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 »

By Posted on Posted in 70-461 Training, Classes, CTE, SQL Server 2 Comments Tagged with , , ,

The SQL Training was a lot of fun this week we covered Top, Ranking, NTILE, and Analytic functions in preparation for the Microsoft 70-461 exam. Next week Aaron Buma and I will be presenting Set Operators, Derived Tables and CTEs. The live session will be with Google On Air Broadcasts Thursday Feb 12th at 9:00am (pacific). This is a FREE SQL Training …

SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs Read more »

By Posted on Posted in Analytic TSQL, Classes, Query Certification No Comments Tagged with , , , ,

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 »

By Posted on Posted in Classes, Query Certification No Comments Tagged with , , , , ,

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 my YouTube Channel. Aaron Buma will be presenting the first half of the session and I will be presenting the second half. We will start off …

This Weeks SQL Server Queries Training Read more »

By Posted on Posted in 70-461 Training, SQL 2012, SQL 2014, SQL Server No Comments Tagged with , , ,

This weeks training as part of the Free SQL Training for the 70-461 certification course is now available on YouTube. This week we covered Aggregating Data and Aggregation strategies.  For more information on sessions, take a look at the Free SQL Training course that we have outlined. TSQL Aggregation video The first half is presented by Aaron Buma and the second …

TSQL Aggregation Strategies and Aggregating Data Read more »