Month: March 2013

Importing a Production Database to SQL Server Data Tools (SSDT)

First of all as a Gooner (Arsenal FC Fan) BIG CONGRATS to The Arsenal for going 2-0 over Bayern Munich!  And best of luck against Swansea this weekend!  COME ON YOU GUNNERS! On to work stuff…  Well it’s been about 2 weeks in my first DBA position and so far I’ve had to make many Read More

Romancing the SQL Server!

So there I was, alone in the wilderness with nothing but my PC and Google for survival. This time, Google was proving to be helpful. The wilderness was winning. This was a classic case of Man vs Machine! I was setting out to conquer SQL Server 2008. Our database changes were untracked and growing rapidly. Read More

SQL Server, Visual Studio, and TFS walk in to a bar…

Task: Create a TFS Database Project Conditions: Project will allow Deployment of Changes from the Developer’s DB to the TestDB and ultimately to ProductionDB. Attempts: So I’m importing two production databases to VS2012 and then hopefully checking them in to our TFS. My questions are: 1) Is it possible to maintain 1 database across 3 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