Today marks the end of life of SQL Server 2005, originally release in November of 2005, this product has finally come to its end of life point. One of my favorite features that was introduced in SQL Server 2005 was …
SQL Server 2005 End of Life – End of Support Today Read more »
Back in 2012 when I was writing my Common Table Expressions book, I came up with the following CTE in a function to split a string into rows. Original Post: http://stevestedman.com/2012/04/using-a-cte-to-split-a-string-into-rows/ At the time, I thought it was pretty handy …
Last week I had the great opportunity to speak at PASS Summit 2015. My presentation was on Common Table Expressions. Here is the sample code from the presentation. AdvancedCTEs.zip Related Links: Common Table Expression (CTE) Month at SteveStedman.com (introduction) …
Epic Life Goal Completed: Speaking at PASS Summit – Advanced CTEs Read more »
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 – …
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 …
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 …
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 …
Here is a short video that shows how to convert those ugly derived table (SubQuery) queries into a common table expression to help clean up your TSQL code. This applies to Common Table Expressions on Microsoft SQL Server, and the …
Using a Common Table Expression Instead of a Derived Table Read more »
Here is the agenda for this weeks free SQL training covering Set Operators, Derived Tables and CTEs – Presentation to prepare for the 70-461 exam: Set Operators Derived Tables Common Table Expressions This session is presented by Aaron Buma and myself. …
Set Operators, Derived Tables and CTEs – Presentation downloads Read more »
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 …