Category: SQL Server

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 →

Tweak your SQL Server Management Studio! Tip #1

Popups…  I hate them!  I hate them in my web browser, and I hate them in apps. I’ll confess, sometimes not knowing what you can customize and just working with the default settings can be a great thing.  If you never customize then your experience is always the same out of the box. I used to play video games and… Read more →

I asked! You answered.

Last week I asked you to help me choose the topic for my first presentation!  First thank you to those of you that clicked in and voted! The winning topic is “Setting up an Environment to Test your Restore Strategy.”   I’m excited about this topic as I’ve recently created a local database instance on which my nightly backups are… Read more →

Mentor Me!

It was a hot sunny day, I was standing on a roof of a prison in Iraq in full battle gear.  The thermometer registered just under 120 degrees.  I was pouring sweat and reflecting on every decision I’d made up to this point which lead to this roof top…  Outside of the prison I saw a large truck which I… Read more →

User’s Choice Poll!

So I’ve decided to take the plunge and will give my first presentation this summer. I’m giving myself a lot of time to choose the topic, prepare, refine, and rehearse the material.  I’ve also decided to present after I’ve finished coaching my first varsity soccer season to minimize the potential failure due to time constraints.  I’m nervous as hell on… 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 →