Want a promotion? Find yourself a junior DBA

Filed under: Professional Development — Brent Ozar at 7:07 am on Friday, October 31, 2008

If you want to get ahead in your career, and if you want to move up in the same company you’re at, somebody is going to have to do your job.  You can’t get promoted if you’re irreplaceable.  (And frankly, if you think you’re irreplaceable, your boss is probably already planning to replace you.)

Look around your office and find somebody who would love to have your job. If you’re a DBA, maybe it’s a developer who’s tired of learning new languages every 3-4 years and would like to stick with one (T-SQL) for a while.  Maybe it’s a network admin who’s tired of fixing desktops and servers and wants to make more money.  But either way, make sure it’s someone that you enjoy working with, because you’ll be training them for a while.

Approach them and start by saying, “Have you thought about becoming a DBA?  I’ve seen you in action, and I think you’d make a good DBA.  One of the toughest things about becoming a database administrator is getting your first job as a DBA, though, and I’d like to help you by getting you started with training.  One or two days a week, I’ll show you what I’m doing, and you can take over some of the basic tasks over time if you want.”

If they clap their hands and offer to wash your car, they’re your new junior DBA.  Even if YOU are a junior DBA, there’s somebody who wants this training, and they’ll be thankful for the opportunity.

If you’re paranoid and you’re worried that they’re going to steal your job, relax: we’re not going to give them the fun parts.  Give them the basic, day-to-day keep-the-lights-on tasks that you don’t particularly enjoy - things that won’t get you promoted.  Knowing how to check all of the backups isn’t going to make you famous, and every hour that you free up out of your schedule means an hour you can spend learning the latest & greatest tools and tricks.

Training this person will mean extra time initially on your part, so focus on training them on things that will pay off for you.  You don’t want to train them on something that you only do once a month, because it won’t free up your schedule and it won’t be useful to them either.  Train them on things you do all the time, like:

  • Interpreting sp_who and sp_who2 to find out who’s blocking queries
  • Reading query plans to improve a query
  • Indexing tables or removing unnecessary indexes
  • Backing up and restoring databases
  • Installing the client tools

Or whatever else you find yourself doing more than once a week.

If this concept sounds crazy to you, ask yourself: how many times has your boss come up to you lately and said, “You’re doing a great job.  How would you like to take on this cool new tool we got in?”  Or is he handing you the crappy stuff that nobody wants?  If you’re getting the short end of the stick, or if you’re never getting to play with cool toys, it’s probably because your manager sees you as too overwhelmed with your current responsibilities - and only you can fix that.

Windows 2008 R2 will be 64-bit only

Filed under: Virtualization — Brent Ozar at 3:28 pm on Tuesday, October 28, 2008

From the horse’s mouth at at the Windows Server Division WebLog:

“First and foremost, 32-bit is done. History. Archives. Windows Server 2008 R2 is the first Windows OS platform to go 64-bit only, and frankly it was high time. Customers have been unable to purchase a 32-bit server CPU for over two years now, and the advancements in CPU architectures really dictated that we squeeze as much performance out of customers’ hardware purchases as possible. The move to 64-bit is a first step.”

SQL Server database administrators everywhere are probably clapping with delight, but that clapping may slow down a little if you use virtual machines on your desktop computer for testing or development.  If you’d like to run Windows 2008 R2 as a virtual server guest, that means you need to be running a 64-bit host - which means your laptop or desktop will need to be running a 64-bit version of Windows.

Update: fellow Questie David Gugick points out that you can still run 64-bit guests on 32-bit host OS’s as long as your underlying hardware is 64-bit compliant.

Using Microsoft Operations Manager with SQL Server

Filed under: Administration — Brent Ozar at 1:36 pm on Tuesday, October 28, 2008

Microsoft Operations Manager (formerly MOM, now SCOM) has gained some traction in Windows shops for monitoring servers. I like it a lot for Windows, especially IIS and Sharepoint, but out of the box, it’s not that useful for DBAs. The default set of SQL Server alerts throw a lot of false alarms on things I can’t change, and it ignores the things I really want to know.

I haven’t seen a good howto article that helps with SQL Server monitoring with MOM - until now. Tom LaRock, who moonlights as SQLServerPedia’s Monitoring Editor when he’s not fighting crime, wrote an in-depth article for Simple Talk:

Operations Manager: A Big Tinker Set

Technorati Tags: , , ,

Happy Birthday, Kevin Kline!

Filed under: Other — Brent Ozar at 1:00 am on Tuesday, October 28, 2008

If you see Kevin Kline traveling through Europe today, wish him a happy birthday!

Storage Area Networks (SANs) 101

Filed under: Podcasts — Brent Ozar at 5:01 pm on Sunday, October 26, 2008

When I was a database administrator, I saw the SAN as a fancy, expensive black box.  Well, it is, but in this podcast I give you some insights into that black box, tell you what kinds of things to ask about when moving your databases into that box, and how to refocus your SAN concerns from raid levels towards more basic things like response times.

 

Links from the presentation include:

You can subscribe to our podcast feeds here:

Technorati Tags: ,

Meet Performance Tuning Editor Denny Cherry

Filed under: Podcasts — Brent Ozar at 3:00 am on Sunday, October 26, 2008

Christian Hasker of Quest interviewed Denny Cherry, known around the web as MrDenny.  Denny Cherry specializes as a professional Microsoft SQL Server Database Administrator, and he recently became a SQL Server MVP, and now he’s the Performance Tuning Editor for SQLServerPedia.

In this podcast, Denny talks about some of his experiences at MySpace and Awareness Technologies and about how junior DBAs can work their way up the ladder.

 

You can subscribe to our podcast feeds here:

Kevin Kline on SQL Server Memory Troubleshooting

Filed under: Podcasts, SQL Server 2005, Tuning and Optimization — Brent Ozar at 6:05 am on Friday, October 24, 2008

Need to troubleshoot SQL Server 2005 memory settings?  Not sure where to look to measure SQL 2000 memory pressure?  Kevin lays out your options in today’s podcast.

 

You can subscribe to our podcast feeds here:

Kevin Kline on Influence and Authority

Filed under: Podcasts, Professional Development — Brent Ozar at 2:09 pm on Thursday, October 23, 2008

In today’s podcast, Kevin Kline talks about the difference between influence and authority, and why IT professionals need to work on their influence to succeed.

 

You can subscribe to our podcast feeds here:

We’re just enabling these feeds for the first time today, so let us know if you run into any subscription problems.

SQL Server 2008 Feature Matrix

Filed under: Administration, I'm a Newbie, Installation — Jason at 10:07 am on Wednesday, October 22, 2008

I’ve been asked quite a bit lately about which of the new features of SQL Server 2008 are available in the standard edition.  Rather than going feature by feature it is easiest to link to the MSDN article that includes a detailed feature breakdown.  As you’ll notice, most of the new and exciting features are enterprise edition only (isn’t that always the case) but those standard users also have some features to be excited about.

Here is the link:
http://msdn.microsoft.com/en-us/library/cc645993.aspx

Technorati Tags:

Optimizing your page file drive

Filed under: Tuning and Optimization — Brent Ozar at 6:45 am on Wednesday, October 22, 2008

We got a great question asking what cluster size to use for the page file drive: NTFS defaults to 4kb, but the customer was concerned that it may not be the proper size when dealing with a very large page file.  The system in question housed a multi-terabyte database with a lot of memory, so the customer was considering using a 64kb cluster size for more efficient reads and writes.  The question: what’s the best cluster size for a page file drive?

Not so fast - it’s a trick.

A properly tuned SQL Server should not be using the page file for memory.  If the server swaps to disk, that’s a huge performance hit.  If the server doesn’t have enough memory, then the DBA needs to turn down the maximum memory size until SQL Server doesn’t swap out to disk.  Sometimes the best answer to memory problems is to actually decrease the max memory size parameter.

When doing performance tuning, if the page file drive is seeing any read or write activity at all, that’s an indication to stop right there and focus on memory use.  Tuning the page file cluster size is like rearranging deck chairs on the Titanic.

Next Page »