Do I need to Patch SQL Server for Meltdown and Spectre?
The news has been full of information around critical patching for Meltdown and Spectre over the last couple of weeks. Most of the information out there is rela...
The news has been full of information around critical patching for Meltdown and Spectre over the last couple of weeks. Most of the information out there is rela...
As I take a short vacation at the end of the 2016, I have been thinking about the different company cultures that I have been part of over the last few years. I...
In the last couple of jobs that I applied for I was subjected to technical SQL interview, by people that were not technical SQL people. This is not ideal, and I...
You know the drill, everything is running along smoothly and then suddenly it’s panic stations! Oh no the database server has run out of space and everyon...
The easiest way I have found to filter down the results of a profiler trace is to dump it into a table and query the results from there. This gives you a simple...
Lately in my new role I have been hitting the traffic alot and spending considerable time driving both to and from work. To make the most of this downtime I hav...
If you are ever shrinking a large data file (bad practice but necessary sometimes) and need to get some idea of the progress you can run the below SQL to get so...
If you are ever trying to join tables from different databases that are using different collations you may experience the dreaded… Msg 468, Level 16, State 9, L...
When you are a DBA it can be almost dull at times, you keep on top of your checks, try to correct any problems that may pop up and generally keep things ticking...
You can run the below to create a dynamic script that outputs the t-sql that you run to delete a bunch of SQL agent jobs. Another time saver in large environmen...