Category: Professional

Certification Path – (MCSA)

Last year I attended 3 training courses to begin learning how to DBA. My goal was to take the 3 exams necessary to obtain my MCSA Certification. At the end of the courses I had little real world application experience of the materials covered in the courses, and I didn’t feel ready to take those exams. After a year of… Read more →

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 through the #SQLHelp Twitter hashtag.… 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 requested updates to current production… Read more →