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. https://www.youtube.com/watch?v=N4eB-uY5MYI 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 http://blogs.msdn.com/b/mssmallbiz/archive/2015/07/07/i-m-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-windows-8-1-windows-8-windows-7-office-2013-office-365-sharepoint-2013-dynamics-crm-powershell-exchange-server-lync-2013-system-center-azure-clo.aspx

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.