I am at SQL Saturday in Vancouver BC today. Here is the download of my presentation. Download zip file. Here is the presentation outline. OVER Clause Enhancements ROWS PRECEDING, FOLLOWING, UNBOUNDED RANGE PRECEDING, FOLLOWING, UNBOUNDED IIF – Immediate IF or …
Last month I posted another CTE blog entry Using a CTE to Split a String Into Rows with Line Numbers. Since then I have used it but, but realized that what I really needed was a diff tool to compare two …
Just a reminder, we are a couple weeks into beta 4 of the database health reports. If you haven’t tried it out, take a look at http://databasehealth.stevestedman.com. You can use the Database Health Reports to increase the overall health …
Last year while working on my CTE presentation for a SQL Saturday I added a blog post called “Using a CTE to Split a String Into Rows“, and since that posting I have used it many times. But as things …
Using a CTE to Split a String Into Rows with Line Numbers Read more »
There are 2 upcoming SQL Saturday events that I have pitched presentations at. These are Vancouver SQL Saturday 198, and Redmond SQL Saturday 2012. If they are anything like last year these should be a blast. One of the new …
Today I released Beta 4 of the Database Health Reports. It has been 2 months since Beta 3, and several bug fixes and new features have been added. The main focus on this beta was fixing bugs, increasing stability and …