Monthly Archives: November 2015

Starting a company – learning by trial and error

By | November 29, 2015

A friend recently asked me how I decided to start my own company, was it something I always wanted or did it happen by chance, how did I make it happen? While I don’t claim to know anything about how to start a company or even be good at it I figured I should still… Read More »

Attaching a database mdf file when the ldf file is missing – with a catch!!

By | November 26, 2015

A few days back I got a call close to midnight where a client’s client was facing an issue. They had recently suffered a power failure and the Sysadmin while bringing the database server online deleted the ldf file for the database by mistake. I can only assume he thought log file meant error logs… Read More »

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. [codesyntax lang=”tsql”] select ‘[‘+TABLE_SCHEMA+’]’+’.[‘+TABLE_NAME+’].[‘+COLUMN_NAME+’]’ as oldcolname, replace(COLUMN_NAME, ‘”‘,” )… Read More »