3 Steps to Work More Efficiently in SSMS.
Throughout my career I have worked with different programming and database tools. Thinking back the tools that I enjoyed using were the tools that were… Read More »3 Steps to Work More Efficiently in SSMS.
Over 300 Dowloads of the Database Health Reports
Today, the Database Health Reports had its 300th dowload. I would like to say thank you to everyone who is using the product, and an… Read More »Over 300 Dowloads of the Database Health Reports
SQL Saturday Presentation
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… Read More »SQL Saturday Presentation
VARCHAR diff function
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… Read More »VARCHAR diff function
Beta 4 of the Database Health Reports
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… Read More »Beta 4 of the Database Health Reports
Using a CTE to Split a String Into Rows with Line Numbers
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… Read More »Using a CTE to Split a String Into Rows with Line Numbers
SQL Saturday Update.
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… Read More »SQL Saturday Update.
Database Health Reports- Beta 4 now available.
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… Read More »Database Health Reports- Beta 4 now available.
Cannot resolve the collation conflict
One possible cause of the “Cannot resolve the collation conflict” error message is that your database collation doesn’t match the TempDB Collation. Recommendation It is… Read More »Cannot resolve the collation conflict
Sessions submitted to SQL Saturday Vancouver BC
I had so much fun at SQL Saturday in Vancouver BC last year, I have decided to go again. The sessions submitted are: The “Run… Read More »Sessions submitted to SQL Saturday Vancouver BC