Category: Professional

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

SQLPass Summit 2012

What an amazing experience.  First of all this was my first conference of any type, so I have no base line with which to compare.  That being said, if I did have a baseline, I’m pretty sure this would have far exceeded most other conference experiences.  This post will be a pretty quick and generic Read More

Arsenal v Man U (3.11.12)

So many Arsenal matches lately it seems this is all I have time to write about! Today brought our Gunners to Manchester in a match against United and against our former ace Robin van Persie. I set out to watch this match expecting a loss, but trying to be a positive supporter. When the cameras 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

Arsenal v QPR (27.10.12)

1 Nil to the Arsenal!  Another hugely lackluster performance wherein AFC controls the ball for 80% of the match without producing much in the way of shots on goal and, of course, goals.  This time I watched the match from the local pub, and there are often fellow Gooners on hand to share in the pain.  I’m not Read More

Arsenal v Schalke 04 (24.10.12)

Another match day! With great excitement I leaped out of bed this afternoon (remember I work nights) after just 5 hours of sleep, donned my AFC Jersey + Scarf over my PJs and prepared to go GOONER as AFC hosted Schakle 04. Just as MSG stopped annoying me with Erik Wynalda the screen changed and we Read More

First! The First Blog on the New Site – @DBAGooner

The first entry into the journaling under the DBAGooner title lands itself firmly in the Gooner category.  After what seemed like months off for the international break everyone was ready for league action to start again.  AFC was looking poised to come off a successful spell prior to the break with an easy 3 points Read More

1 2 3