Notes from SQL Server Classes
Just sharing a rave from a SQL Saturday attendee this month. I had a lot of fun with this presentation. He was referring to the SQL JOIN Types presentation. It is just nice to get feedback like that once in a while. Thanks Scott for your kind words!
Yesterday was SQL Saturday Redmond. It was a great day, I learned lots, met some great new people, and had a chance to catch up with some old friends. When most people hear about SQL Saturday for the first time, they probably think to themselves “spend all day on a Saturday in technical presentations”, however SQL Saturday is much more …
Today I am presenting at SQL Saturday in Redmond Wa. My presentation is on SQL JOIN types. If you have seen my JOIN Types Poster, you should check it out. Download the slides and sample TSQL code: JOINs.zip Topics Covered Basic SELECT INNER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN LEFT OUTER JOIN with exclusion RIGHT OUTER JOIN with exclusion …
I am attending and speaking at SQL Saturday Redmond today. My presentation is at 2:45pm and on SQL JOIN Types, and the following topics will be covered: Basic SELECT INNER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN LEFT OUTER JOIN with exclusion RIGHT OUTER JOIN with exclusion SEMI JOIN ANTI SEMI JOIN CROSS JOIN FULL OUTER JOIN FULL OUTER JOIN …
There is a lot happening right now, so I thought I would put together a brief overview of upcoming speaking engagements. May 13th – When Corruption Strikes (PASS DBA Virtual Chapter Meeting) May 16th – Exploring SQL Server Join Types – INNER, OUTER, and much more… (SQL Saturday Redmond) June 9th – When Corruption Strikes 2 (HADR Virtual Pass Chapter) June …
Yesterday I blogged about submitting to SQL Saturday Denver, which is about 5 months away, after writing that post, I realized that I haven’t even blogged about SQL Saturday Redmond which is occurring in just over 2 weeks. SQL Saturday #393 Redmond marks just 3 years since my first time speaking at a SQL Saturday #108 in Redmond. So lets …
This year the Denver SQL Saturday is being held on September 19th. I believe it has been 2 years since I attended SQL Saturday in Denver. Since the last time I was at SQL Saturday Denver, my employment has changed. Previously I was employed as a full time employee at a local company. Now I am a freelance database consultant at …
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 …
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 …