Blog Archives

TSQL JOIN Types – SQL Saturday

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

Posted in SQL Saturday Tagged with: ,

Upcoming Speaking Engagements

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 –

Posted in Classes, Corruption, CTE, SQL Saturday Tagged with: , , , , ,

SQL Saturday Redmond

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

Posted in SQL Saturday Tagged with: , , , ,

SQL Saturday Denver

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

Posted in SQL Saturday Tagged with: , ,

Advanced CTEs Slides and Sample Queries

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

Posted in CTE, CTE Book, SQL Saturday Tagged with: , ,

Introduction to CTEs Slides and Sample Queries

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

Posted in CTE, CTE Book, SQL Saturday Tagged with: , , , , , , ,

SQL Saturday #265 in Portland Oregon

I will be attending SQL Saturday #265 in Portland Oregon on November 16th 2013. This will be my second time attending SQL Saturday in Portland, and it is looking to be a great event. There are some great speakers on

Posted in CTE Book, SQL Saturday Tagged with: , , , , , , ,

Advanced CTEs Slides and Samples

Today I presented on Advanced CTEs at SQL Saturday Denver. Here are my slides and sample code for download: Advanced CTEs Denver Thanks to everyone who attended, I hope you enjoyed the presentation. Don’t forget to try out the Database

Posted in CTE, CTE Book, SQL Saturday Tagged with:

In Denver for SQL Saturday

I will be speaking at SQL Saturday Denver, presenting on Advanced Common Table Expressions.  This presentation should be a lot of fun.  I will be covering all the advanced and fun CTE features that I haven’t had time to fit

Posted in CTE, CTE Book, SQL Saturday Tagged with: , , ,

I’m Speaking at SQL Saturday #190 in Denver

  One of my sessions was accepted for SQL Saturday #190 in Denver this year. Please come see my CTE presentation. Common Table Expressions – Introduction Have you ever wanted to create a recursive query, but didn’t see how to

Posted in SQL Saturday Tagged with: , ,

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Common Table Expressions Book

Paperback:

Kindle: