Category: SQL Server

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 requested updates to current production… 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 servers using VS2012 / TFS?… 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 turned on the announcer was… 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 going to go into another… Read more →