It has been a year since SQL Server 2012 released. There were some fun posts on Twitter about the SQL Server 2012 birthday or anniversary. For instance: and another anniversary query (which doesn’t actually run): 1 year out since SQL …
SQL Server 2012 introduces a new T-SQL object used to generate numbers, a SEQUENCE, similar to an identity column. You can think of a sequence as a take a number object, you just ask it to give you a number, and you get …
SQL Server 2012 introduces the IIF statement. It is very similar to the IIF statement in MS Access. I have extracted the IIF part of my presentation on Whats new in SQL Server 2012, and turned it into a video …
The Waits Types page has been updated on the T-SQL Wiki. The wait type documentation works will with the Database Health Reports historic wait time monitoring (Free download). Below is a screenshot of the Historic Waits Query Advisor in the …
The article could be named, “How to use up all of your SQL Server available memory with a single CTE query.” Another name for the article could just be “SQL Server Bug Report” depending on how you look at it. …
On my computer I run SQL Server 2012, and I use a number of test or development databases. I don’t run backups on these because I don’t care if they get destroyed since they are easy to replace. Recently I …
Shrinking a Log File on a Test or Development Server Read more »
Today, the Database Health Reports had its 400th download. I would like to say thank you to everyone who is using the product, and an extra thank you to those who have provided me with feedback. Here is a history of the …
Over 400 downloads of the database health reports. Read more »
The Database Health Reports application provided free of charge to the SQL Server community. Enjoy! Today I released Beta 5 of the Database Health Reports. Beta 5 is mostly bug fixes and performance improvements. There was one new feature added, the Big …
Database Health Reports – Beta 5 Released Today. Read more »
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 easy to get the job done, and the tools that I hated using were the …
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 extra thank you to those who have provided me with feedback. Since I started planning …
Over 300 Dowloads of the Database Health Reports Read more »