5 days until Beta 3 of the Database Health Reports. Coming soon, and this one is going to be cool. Although Beta1 and Beta2 had a number of great monitoring features Beta 3 takes a whole new approach. All of …
5 Days Until Beta 3 of the Database Health Reports Read more »
Thanks to everyone who attended my CTE presentation at SQL Saturday in Olympia Washington today. Have a great rest of the day. As promised I have posted the slides and sample TSQL queries here. If you have any questions, please get …
Unleashing CTEs in SQL Server – Slides and Sample Code – Olympia SQL Saturday Read more »
I just finished the Exploring the TSQL Enhancements in SQL Server 2012 presentation at SQL Saturday 166 in Olympia Washington. Thanks everyone who attended, I hope that you learned something useful. Here is the slides and sample code to download: Whats …
Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code Read more »
The sample code below is a quick run down of the new sequence object introduced in SQL Server 2012. Just part of my Whats New in TSQL 2012 presentation at SQL Saturday 166.
As shown in my previous posting on SEQUENCES, they are a user-defined object that generates a sequence of numeric values in Transact SQL 2012. But what if you want to generate letters instead of numbers. Here is a code example of …
TSQL 2012 – Generating letters with a SEQUENCE object Read more »
SQL Server 2012 introduces the SEQUENCE object. Looking at the syntax it is very similar to how Oracle has implemented SEQUENCEs for many years. I believe that the SEQUENCE was introduced to aid in the transition of Oracle developers to …
Today Microsoft Release Service Pack of of SQL Server 2012. My preference is to never run a new version of SQL Server in a production environment until it gets to SP1, so now its time to start looking at …
SQL Server 2012 SP1 Now Available From Microsoft Read more »
Thanks to everyone who attended my CTE presentation at SQL Saturday in Portland Oregon today. Have a great rest of the day. As promised I have posted the slides and sample TSQL queries here. If you have any questions, …
Unleashing Common Table Expressions in SQL Server – Slides and Sample Code Read more »
Its going to be a great day! Ready for SQL Saturday 172 in Portland today, looking forward learning lots, and sharing my CTE Presentation with those who want to learn about Common Table Expressions. Please come to my CTE …
Here is my new logo for my SQL Saturday sponsorship.