Category: SQL Server 2012

Tweak your SQL Server Management Studio! Tip #3

Previously on Tweak your SQL Server Management Studio… In Tip #1 I covered how to open a gloriously empty SSMS environment with no pop ups! Tip #2 was all about Registered Servers Today in Tip #3 I want to quickly cover something I use all the time, not just in SSMS.  Keyboard Shortcuts!   It drives me crazy to watch… Read more →

Tweak your SQL Server Management Studio! Tip #2

Previously on Tweak your SQL Server Management Studio… Stop the Popups! I covered how to prevent the connection popup from appearing when you opened SSMS.  In this post I want to show you why I decided to stop those popups in the first place. Registered Servers! What are registered servers?  From BOL Registering a server in SQL Server Management Studio… Read more →

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 →

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 →