Tag Archive: red gate

I Think You’re Exceptional. No, Really.

A funny thing happened on my way to becoming a judge in the 2011 Exceptional DBA Awards.  But to get there, I gotta tell you a story about my dark past.

I used to be a developer.  No, wait, it gets worse: I coded web pages in Classic ASP, aka VBscript.  My idea of reusable code was stuff that I could copy/paste into multiple web pages.  I didn’t have a QA team – our idea of testing was to run it a few times on our own machines, and then keep an eye on it after we deployed it to production.  To me, the word exception will always remind me of exception handling, one of the many things I didn’t do well as a developer.

The bad news was that my code sucked, but the good news was that I knew it.  I wasn’t destined to be a developer, and I started transitioning into database administration instead.  I loved SQL Server, hardware, and performance tuning, so I began interviewing for jobs that would let me focus on that.

Along the way, I had a job interview that didn’t go well.  It was a company with offices in multiple states, and part of the interview involved a phone discussion with the head DBA in another state.  The DBA asked me, “If you wanted to monitor for exceptions and problems on your SQL Servers, how would you do it?”

I answered immediately without so much as a thought: “I’d buy an alerting package from a vendor.”

The DBA drilled down deeper, asking me how I’d build an alerting system with things like DMVs and SSIS, but I refused to budge.  I explained that my code simply sucked, and that it would take me way longer to build a collection utility – and even when it was done, it’d be garbage.  The DBA asked if I would use any of the freely available scripts at places like SQLServerCentral.com, and I could hear the DBA’s anger and dissatisfaction through the phone at my replies.  I just didn’t want to hassle with rolling my own software.

Needless to say, I didn’t get the job.  However, that experience pushed me harder to hone my skills. In my epic post Rock Stars, Normal People, and You, I documented my grueling struggle to take control of my databases, my career, and my life.  It was a long, hard road, and it all started with one simple thing:

Guess which one of us is not in IT.

Working in IT for a wine company is hard. Really.

I spent time in the SQL Server community.

I started reading blogs, watching webcasts, and attending presentations.  As I got my confidence up, I realized I could give back too, so I started presenting my own stuff.  The more I gave back, the more addictive it became.

I know you’re exceptional too – because you’re here.

When I go out and talk to people at conferences, SQLSaturdays, and user groups, I talk to people about what blogs they read.  Most of ‘em don’t have time to read blogs.  You’re already in the minority just by being here – you’re taking time out of your day to advance your knowledge.  You’re not getting paid to read my blog.  You’re doing this because you love what you do, and you love to learn.  That’s exceptional.  It’s outside the norm.  Sure, I know, you think you’re just one of thousands here in the online community, but it’s easy to forget that simply by being here, you’re already ahead of the curve.  You’re ahead of the tens of thousands of database professionals who never take the time to read blogs, watch webcasts, and attend presentations.

Red Gate just launched their annual Exceptional DBA Awards contest to honor people like you.  Yes, you.  And I want you to go enter.  Stop comparing yourself to the people up on the podium, and start comparing yourself to the people who never even bother to show up to free conferences in their own town.  You’re exceptional.  Stop thinking of it as blowing your own horn, and start thinking of it as being proud of what you do.  I know you love what you do, because you’re here reading this blog.

Trust me – I’m judging the contest.

I’m honored to say that Red Gate invited me to join Brad McGehee, Rodney Landrum, and Steve Jones in judging the 2011 Exceptional DBA Awards. We’re looking for people who don’t just do their jobs, but they go above and beyond – spending time reading blog posts, answering questions online, and giving back to others.

I’m really honored to be a judge because it’s a champagne moment for me.  See, several years ago, when I was struggling through that job interview with The DBA?  That guy was Rodney Landrum.

He was right to turn me down, because at the time, I wasn’t exceptional.  I didn’t read blogs.  I didn’t know DMVs well.  I didn’t give back to the community.  But you, dear reader, are already far ahead of where I was.  You’re exceptional, and it’s time you threw your hat in the ring.

Go visit ExceptionalDBA.com today and learn more about this year’s contest.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Who Won an iPad and @RedGate SQL Monitor?

And now, the moment we’ve all been waiting for.  The select statement, please:

I See Angry Birds In Your Future

I See Angry Birds In Your Future

Congratulations to the lucky winners, who will each get an Apple iPad 16GB with 3G and Red Gate SQL Monitor!

I’d like to thank Red Gate Software for making this contest possible and making our holiday spirits bright.  Reading everybody’s thoughts about where they’d go if they didn’t have to worry about their SQL Servers gave me a lot of laughs.  The holidays help us refocus on what really matters: our friends and family.  We work hard so that we can enjoy our time with them, and anything that can help me relax and let go of my 9-5 work, I’m all over it.

Grant Fritchey picked 10 winners who identified their most common causes of server outages, and Steve Jones picked 10 winners who talked about things they could do better with a tablet.  Happy Holidays everybody, and enjoy your new iPads and SQL Monitor.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Giving Away 10 Apple iPads and Red Gate SQL Monitor!

You need to relax and get out more.

We SQL Server DBAs are constantly checking that cell phone, worried about that email from a user saying, “The server is borked.”  When it comes in, we drop everything, run to the nearest laptop, and try to figure out just how bad things are and if they’ve gone back to normal.

You’ll be more relaxed on the weekends if you can do these two things:

  • Find out before the users find out
  • Be able to check health from anywhere

There’s a web app for that – Red Gate SQL Monitor.  It sends you emails when things start to go pear-shaped, and then you can whip out your trusty iPad to check your server’s health and stats from anywhere.  You can see it live now by going to http://monitor.red-gate.com, which shows SQLServerCentral’s database servers.  (You don’t have to log in, but of course you’d use the built-in username/password security for your own SQL Monitor web site.)  A few screenshots:

Red Gate SQL Monitor Dashboard

Red Gate SQL Monitor Dashboard

Host Machine Stats

Host Machine Stats

SQL Server Instance Statistics

SQL Server Instance Statistics

SQL Server Error Log

SQL Server Error Log

All from your iPad, anytime you’re within range of WiFi or a 3G cellular signal.  You can stop worrying about what your server’s doing, and start being present with your family, your friends, and your hobbies.

What’s that?  You don’t have an iPad?

Red Gate wants to fix that.  They’re giving away 30 prize packages, each with a 16GB 3G iPad and a license to Red Gate SQL Monitor!  I got 10 to give away, Steve Jones is giving away 10, and Grant Fritchey is giving away 10, but you can only enter in one of our contests.  To enter for mine, all you have to do is post a blog comment below and tell me where you’d go if you didn’t have to worry about what your servers are doing.  The deadline for entry is Friday, December 17th, 2010, and then we’ll pick 10 random lucky winners to be announced on Monday, December 20th, 2010.  (And if you win, you owe me a picture of yourself monitoring your SQL Servers with your new iPad!)

Here’s the fine print:

  1. The contest is open to professionals with SQL Server monitoring responsibility. Entrants must be 18 years old or over.
  2. Entries must be received by Friday, December 17, 2010. The contest organizers accept no responsibility for corrupted or delayed entries.
  3. Employees of Red Gate, the contest organizers and their family members are not eligible to participate in the contest.
  4. Entries are limited to one per person across the three simultaneous contests hosted on www.SQLServerCentral.com, www.BrentOzar.com, and www.ScaryDBA.com.
  5. The organizers reserve the right, within their sole discretion, to disqualify nominations.
  6. The organizers’ decisions are final.
  7. Red Gate Software and those involved in the organization, promotion, and operation of the contest and in the awarding of prizes explicitly make no representations or warranties whatsoever as to the quality, suitability, merchantability, or fitness for a particular purpose of the prizes awarded and they hereby disclaim all liability for any loss or damage of any kind, including personal injury, suffered while participating in the contest or utilizing any prizes awarded.

So whatcha waiting for?  Leave a comment for your chance to win or check out the contests on Steve Jones’ blog and Grant Fritchey’s blog!

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube