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 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 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 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 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