Category: Database Administrator

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

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

Our SQL Community

A community is a group of any size that shares common values.   When I was in the Army my main job, and that of just about all Soldiers, is to make sure that the Soldier above and below him in rank knows his job and can perform it if something should take the Soldier Read More

Snapshot of a DBAGooner (2014)

It’s been more than a year since I last wrote a “snapshot” in May of last year. So here is me after my first full year in the position! Last year my goals for the following year were: Learn how to completely manage my databases. (Backups, restores, etc) Take Exams towards MCSA. Well I’ve accomplished Read More

What does it take to run a SQL Saturday?

To be honest, I have no idea what the organization entails, nor do I know what the SQL Saturday organizers have to go through. The one thing I do know is that it takes volunteers. Just think about everything that happens on the day before, and the day of the event. 1) Coordinating the facility 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

How I became a Database Administrator

It seems that I am always hearing about the “Accidental DBA,” the person that was given the job because they knew the most about it.  My trip was a bit different, but not out of the ordinary I guess. When I was younger my dad had a Tandy 1000 computer, and I loved it.  I Read More

What a Week!!!

Normally I’m not a “TGIF” kind of guy.  I enjoy work, I love digging in to the databases to make things better.  This week we rolled out some new technology to virtualize some of our systems.  This is the second round of these upgrades, the first having gone off without a hitch. This week, after Read More

Snapshot of a DBAGooner

I read a post from Brent Ozar today titled “Write a Note and Shoot Yourself Today” in which he describes looking back at an old photo of himself and remembering everything about his 9-year-younger self.  A great idea as I am in my first 3 months as a “Junior DBA” and this is a great time Read More

1 2