Category: Classes

Notes from SQL Server Classes

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 No Comments Tagged with , , ,

  Continuing our weekly SQL Query Training for the 70-461 exam preparation, at Steve Stedman, sharing this weeks class with the world. Free SQL Query training.     Here is the video of the training on TOP, Ranking, NTILE, and Aggregate Functions today. The first half was presented by Aaron Buma, and the second half I presented. The following topics …

TOP, Ranking, NTILE, and Aggregate Functions 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 DevTeach No Comments Tagged with , , , , ,

For the .NET programmer, Visual Basic programmer or PHP programmer, if you are accessing a SQL Server database there are some things you should know to performance tune your queries. Learn how to improve query performance with Indexes, how to properly use parameterized queries, using the query analyzer, and avoiding common SQL Server performance pitfalls. This presentation is a lot …

SQL Server Performance for Developers Read more »

By Posted on Posted in DevTeach No Comments Tagged with , , , , , ,

Monday: Using FILESTREAM and FILETABLES in SQL Server Configuring and Using FILESTREAM and FILETABLES in SQL Server.  Developers love to use SQL Server to store files, but this causes headaches for the DBA, finally a reasonable solution for file storage in SQL Server FILETABLES and FILESTREAM. SQL Server 2008 and 2012 add the new features of FILESTREAM and FILETABLES. Learn how …

SQL Server FILESTREAM and FileTables Read more »

By Posted on Posted in DevTeach, Performance No Comments Tagged with , , , , , , ,

This week I will be attending and speaking at Vancouver DevTeach. This event taking place on December 2nd to 4th 2013 at the Vancouver Sheraton Wall Center Hotel. Monday and Tuesday I have morning presentations which leaves the rest of the day to attend a few other sessions. Here are the sessions that I will be presenting. Monday: Using FILESTREAM and …

Speaking at Vancouver DevTeach this week. Read more »

By Posted on Posted in CTE, CTE Book, SQL Saturday No Comments Tagged with , ,

My second presentation at SQL Saturday in Portland Oregon is Advanced Common Table Expressions. Here is the outline for the session. 1. Hierarchical Recursive CTEs 2. Manipulating Data 3. Common Use Cases 4. CTE Performance Considerations Download the presentation and samples here:  Advanced CTEs.zip See Also: Introduction to CTEs presentation

By Posted on Posted in CTE, CTE Book, SQL Saturday No Comments Tagged with , , , , , , ,

Today I am at SQL Saturday Portland Oregon, and at 9:00am I am presenting the Introduction To Common Table Expressions session: Here is the abstract: Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE’s for recursive queries, as …

Introduction to CTEs Slides and Sample Queries Read more »

By Posted on Posted in Classes No Comments Tagged with ,

Over a year ago I was at a SQL Saturday listening to Rick Morelan from Joes2Pros talking about his goal, which if I remember correctly was to get 3 certifications a year, and that he has obtained over 30 technical certifications. Earlier this year I decided that I would follow with a similar goal of 3 certifications per year. Yesterday …

3 Technical Certifications This Year Read more »