How to Find the Best Company to Work For (Culture vs Career)
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...
Category: General
SQL Interview Questions For SQL DBA
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...
4 Shortcuts to clearing up disk space in record time on your SQL Server
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...
How to filter a SQL Profiler Trace
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...
SQL Server Audio
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...
Show progress of shrink file command
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...
Collation Errors Running a SQL Query
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...
How to restore Master DB – SQL Server 2008 R2
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...
How to quickly delete sql agent jobs – via T-SQL
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...
How to quickly change recovery model via T-SQL
run the below, which will output the t-sql statements. Can save a lot of time and clicks, especially if you have alot of DB’s on a server. I normally do t...