Monthly Archives: November 2015

The Dunning – Kruger effect

By | November 23, 2015

If you don’t know what this means pay attention!! I recently posted a blog about the characteristics of a senior DBA. One of the points mentioned there was how Senior DBA are often left with a feeling that they have only scratched the surface. At the time I didn’t know this was a scientifically proven… Read More »

Proof that tempdb mdf and ldf files are **NOT** dropped at the OS level when SQL Server is restarted

By | November 20, 2015

A quick video showing that the mdf and ldf files are actually ** NOT ** dropped during server restart. Thanks to Mike for bringing up this topic. We also cover some quirky behavior by tempdb where it still detects the changes in model database and persists them to tempdb after the restart. More on… Read More »

A ton of MS E-books to download

By | November 11, 2015

I am not sure how many other users have visited this blog but it’s been one of my go to places when I wanted to read up on a particular topic. Tons of e-books available to avid reader of IT literature. Updated link below NEW DOWNLOAD LINK Old link

Renaming all columns in a table quickly

By | November 8, 2015

Recently imported a table where the column names where quoted using double quotes which then became the table names , So a column name would be “Airline” instead of Airline. Here is a simple script to rename all the columns in all tables within a database.