WOW, what a great day at SQL Saturday 108 in Redmond. I started out with a keynote presentation from Buck Woody. Then I delivered my presentation on Common Table Expressions. Which I think went well. There were some great questions and I look forward to refining my presentation to include some of the questions that I was asked at the end of the session.
After my presentation I was able to enjoy several other sessions.
Mark Simms (@mabsimms) – The Elephant in the Room (Hadoop for DBAs)
Donabel Santos (@SQLbelle) – SQL Server Reporting Services – Beyond the Basics
Aaron Nelson (@SQLvariant)- PowerShell for Data Professionals
Kevin Kline (@KeKline) – Top 10 Admin Mistakes on SQL Server
Here is one of my mementos for the day.
Thanks everyone for all the great feedback.
All of the content was great today. Thanks to Microsoft for hosting this event on their campus.
Now to start preparing for SQL Saturday in Vancouver in March.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Steve I wanted to let you know I enjoyed your presentation today as I had not heard about CTE’s before as we should be able to use a recursive CTE in place of where we have been using a cursor allowing for a substantial performance improvement for us.
Brian, Thanks for the feedback.
I have had some bad experiences with cursors written by people who didn’t understand cursors, I have pretty much outlawed the use of cursors, unless there is a really good reason for it.
I am currently making a couple changes to my presentation for the next SQL Saturday, and I will include a comparison of cursors for a recursive hierarchical query.
Thanks for the input. Have a great time with CTE’s.