Category: TSQL

Upgrading Production to SQL Server 2012 – My Step-By-Step Procedure (Pt 1 of 2)

I’d like to think I’ve done the proper research to ensure that I’m going about this the correct way, but to be completely honest I was told to do it this way, and found enough other guides to convince myself this was the right method.  The fine folks on twitter have helped to convince me Read More

Killed a Process today.

So on a server I didn’t even know about they had an instance of SQL Server 2012 loaded which was used by a software package.  They had a problem with the original database, built a new one and came to me to delete the old one.  Due to a lack of information what I wanted Read More

It’s begun – First day as the DBA

So for the past year and a half I’ve been primarily working as the night shift “system support analyst” or help desk tech.  I’ve also been phasing in as a part time DBA for 6 of those months.  This was challenging because the current DBA is the boss and only there during the day, my Read More