Category: Database Administrator

The Annual Review

BACKSTORY: I was hired as a Systems Support tech by my current company almost 2 years ago.  I’ve since been “promoted” from support to the Database Administrator.  The current DBA is the Vice President of Information Tech and his plate is too full to maintain the DBs, thus my luck.  He’s training me on our Read More

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

The Accidental DBA?

I suppose so. After 14 years in the Army, National Guard, and Reserves as a Military Policeman I decided I wanted to get out, go to school and to be a Database Administrator. I had no real clue what they did, but I’d worked with Access and was in awe at the potential. I looked Read More

1 2