What twitter hash tags do you follow for SQL Server?
# The key to twitter is to follow the right hash tags. What hash tags do you follow related to Microsoft SQL Server? Here are… Read More »What twitter hash tags do you follow for SQL Server?
SQL Server
Happy Birthday SQL Server 2012
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.… Read More »Happy Birthday SQL Server 2012
SQL Server 2012 IIF Statement
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… Read More »SQL Server 2012 IIF Statement
SQL Server Memory Hog Query
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… Read More »SQL Server Memory Hog Query
Shrinking a Log File on a Test or Development Server
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… Read More »Shrinking a Log File on a Test or Development Server
Database Health Reports – Beta 5 Released Today.
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… Read More »Database Health Reports – Beta 5 Released Today.
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.
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
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