SQL Server 2005 End of Life – End of Support Today
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… Read More »SQL Server 2005 End of Life – End of Support Today
Common Table Expressions
CTE to Split a String in a function SplitString
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… Read More »CTE to Split a String in a function SplitString
Epic Life Goal Completed: Speaking at PASS Summit – Advanced CTEs
Last week I had the great opportunity to speak at PASS Summit 2015. My presentation was on Common Table Expressions. Here is the sample… Read More »Epic Life Goal Completed: Speaking at PASS Summit – Advanced CTEs
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… Read More »Upcoming Speaking Engagements
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 #393 Redmond marks just 3 years since my first time speaking at a SQL Saturday #108 in Redmond. So lets take a look back, at Feb 5th, 2012, it was my first time presenting at a SQL Saturday ever, I had discovered this cool new query tool called the Common Table Expression, and I prepared my presentation. I practiced my presentation once before Saturday, and I was ready. Did I mention, that this was also my first time every attending a PASS event, or a SQL Saturday, and I was presenting. I was in the morning time slot after the keynote, and boy was I nervous. Over the next year I presented at I few other SQL Saturdays, and finally a book publisher, Joes 2 Pros noticed my presentation and asked me if I wanted to turn it into a book. In 2012 and 2013, I turned it into a book, which was released the same day as SQL Saturday #212 Redmond, where I again was selected to present on Common Table Expressions, this time I had books to give away as a prize.
Today’s Training: SQL Queries Section 1 Review
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… Read More »Today’s Training: SQL Queries Section 1 Review
Next Weekly Free SQL Training: A Review
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… Read More »Next Weekly Free SQL Training: A Review
Using a Common Table Expression Instead of a Derived Table
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… Read More »Using a Common Table Expression Instead of a Derived Table
Set Operators, Derived Tables and CTEs – Presentation downloads
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… Read More »Set Operators, Derived Tables and CTEs – Presentation downloads
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:… Read More »Introduction to CTEs Slides and Sample Queries