Monthly Archives: September 2009

New SSP Blogger: John Sansom

Squeaking in just before Thursday’s contest deadline comes our newest blogger, John Sansom (BlogTwitterStackOverflow).  I’ve read John’s blog for several months now, and I’ve been giving him a secret invisible thumbs-up every time he tweaks his blogging strategy to align with my recommendations.  (And no, I haven’t told him this, hahaha.)

John is a DBA in the UK who “gets” the whole blogging and social media thing.  He’s even started a SQL Server Guru Challenge, an ongoing test of DBA skills that I’ve found uniquely enjoyable.  The first round was a SQL Server crossword puzzle that went out just before I had to board a plane, and I couldn’t get one last damn clue.  I’m excited to see what the next round brings.

Some of John’s recent posts include:

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

Meet PASS Board Candidate Jeremiah Peschka

The PASS Board of Directors election starts on October 12th, and we’ve got four really well-qualified candidates to choose from:

You can read their bios at the PASS Candidate List, and they’re good, but I wanted more.  I emailed each of them with a set of interview questions to satisfy my bizarre curiosity.  The first one to respond back was Jeremiah Peschka, and here’s our interview:

Brent: First, thanks for volunteering to dedicate your time to the community. What made you decide to run for the Board of Directors this year?

Jeremiah: You did. In all seriousness, though, I’ve tremendously enjoyed volunteering within PASS (both locally in Columbus, OH as well as with the Application Development Virtual Chapter) and I want to keep giving back to PASS as a whole. I also have some great ideas about how we can keep growing PASS and give more to the members throughout the year instead of over 3 days at the Summit.

Walk us through one of your typical workdays. What do you do?

On a typical work day I check up on any outstanding tasks that I had from the previous day, check on the nightly jobs, and make sure that none of the database servers have suffered a sudden, catastrophic failure. Generally I look for ways to automate checks for anything that could go wrong and then I concentrate on writing new stored procedures, performing index tuning, or doing performance analysis on the entire system.

What parts of your day-to-day experience will make you a better Board of Directors candidate than the other candidates?

Better than the other candidates? Barring my good looks and charm, I would have to say that I can’t give you an honest answer to that question since I don’t know two of the candidates beyond their online reputation. However, I do think that my community involvement and ability to work within constraints give me some solid skills that will be an asset to my tenure on the Board of Directors.

I’ve heard that the PASS Board of Directors is a time-consuming hobby to say the least, and at this point in our careers, none of us have tons of extra time. What other projects or things do you expect to have to cut back in order to make time for the Board? (I’d just like to give the readers an idea of how tough it is to prioritize things.)

This is a question that I had to answer for myself before I decided to run for the board. In the end, I hired a team of highly trained office ninjas to take care of my day job while I pursued all of my hobbies. Truthfully, this was a really difficult decision to make because I enjoy all of the things that I do. Luckily, I have some incredibly helpful volunteers both locally and with the App Dev virtual chapter who have been willing to step up and take a more active role in the day to day affairs of the user groups. There are a few other goals (pursuing the MCM certification) that I decided to put on hold for the next two years, should I be lucky enough to be elected, because I wanted to help PASS by joining the Board of Directors.

I believe social networking and Web 2.0 tools like Twitter, Facebook, and StackOverflow are changing the way DBAs interact with each other, get training, and solve problems. Do you agree or disagree, and why?

I agree with you 100% about this. These ‘instant on’ tools make it incredibly easy to find the answers to questions. Instead of googling/binging ‘SQL Server clear database proc cache’ I can send out a tweet and find out, in a matter of seconds, that the answer is DBCC FLUSHPROCINDB. Do you know how long that takes to find otherwise?

These tools have also helped me form friendships with a lot of great people, many of whom happen to be DBAs. The ability to instantly connect with people across the globe give us the ability to share information, expertise, and our free time in a way that we’ve never had before.

Do you blog and use social networking tools? Where can DBAs find you online?

I do blog and network socially on the intertubez. Here are all of the various ways people can find me:

You can also find all of my contact info on my blog: http://facility9.com/about/getting-in-touch/

Do you have any conflicts of interest that may pose a challenge?

Apart from being fairly opinionated, I do not believe that I have any conflicts of interest. Does owning an Oracle book count? I use it to prop my laptop up to eye level to reduce the risk of RSI.

If PASS put you in charge of increasing new memberships, what specific steps would you take?

I’d make it free to join PASS. (Hand over mic – They already did that? Why didn’t anyone tell me?!)

I would immediately reach out to the community to find out what more PASS could be doing to help out. But I wouldn’t just reach out to full time DBAs – I’d also reach out to developers, IT Pros, network admins. All of these people could benefit from PASS and, likewise, we could benefit from their knowledge and viewpoints as well. It sounds corny, I know, but I spent a lot of my early career as a developer, so I know all to well how things can look from the other side.

What do you think PASS is doing right to improve the day-to-day lives of database administrators?

I think PASS does a great job of aggregating some of the best SQL Server training on earth into a single conference.

What do you think PASS could do better, and how?

Well, I think this goes hand-in-hand with what I said earlier: PASS is more than just a 3 day training junket. It’s a massively distributed community with a wealth of knowledge and expertise spread across tens of thousands of members. There’s so much that we can do to grow our current members as technical professionals, speakers, and writers. And these are things that don’t need to happen at the conference, they can happen every day of the year by pairing people with mentors to develop their SQL, professional, speaking, or writing skills.

Sum up your goals for PASS in 140 characters or less:

I want to make PASS the best community experience possible.

Thanks for your time!  Readers – you can learn more about Jeremiah and why he’s running at his web site.

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

Upcoming SQL Server Presentations

Training, training, fresh hot training, come get your free SQL Server training….  (It works for the peanuts and popcorn guys, and I figured it might work on the web.  No?  Okay, I’ll stick with my day job next time.)  Here’s the presentations I’ve got coming up in the next month, and I’ve recorded video previews of some of ‘em.

September 30th – Hit the Ground Running with SQL 2008

I’m presenting this remotely for the Edmonton PASS Chapter, and you can watch it from the comfort of your own home.  I’ll be covering how to set up a Central Management Server, Policy-Based Management, Group Query Execution and the Resource Governor.  It’s about 50-75% demos.

The meeting starts at 5pm MDT (Edmonton time), 7pm EST, 11pm GMT.  I’ll send a tweet with the meeting coordinates shortly before it starts.

September 30th – Diving Into Server Virtualization

Denny Cherry is actually presenting this one, not me, but it’s for the PASS Virtualization Virtual Chapter.  Here’s the abstract:

We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment.  We’ll be talking about when it’s a good idea, when it’s a bad idea, and why there’s no hard-set answers.  We’ll focus on how to make this decision and how to gather the metrics you need to make a good decision.

The meeting starts at noon EST, 4pm GMT.  To join the LiveMeeting, click here. Audio will come through your computer speakers.

October 1 – The Hidden Treasures of SQL Server

Want to make SQL Server run faster? Interested in stored procedures that’ll make your life easier? Join SQL Server experts Brent Ozar and Tim Ford as they reveal undocumented procedures as well as tricks and tips to make SQL Server do things it was never intended to do—for your benefit.

We’ll also be drawing the winner of the SQLServerPedia contest for an all-expenses-paid trip to the PASS Summit.  Register for the webcast.

October 9 – Quest Day with the Experts in Aliso Viejo, CA

This time, I let you guys pick the sessions, and here were the top vote-getters:

SQL Server on Storage Area Networks (SANs)

SANs are expensive pieces of hardware that offer a lot of performance and failure protection. Brent knows firsthand: he managed data warehouses and SAN storage, and was able to wring much more performance out of his SANs when he learned tricks like multipathing. He’ll explain:

  • SAN advantages & disadvantages for DBAs
  • Shared versus dedicated disks
  • The basics of multipathing
  • The myth of active/active multipathing

Advanced Index Tuning: Free Performance Gains for Pros

Don’t just take the word of the Index Tuning Wizard or Database Tuning Advisor: if you rely on these tools, you can actually hurt your server’s performance! In this session, Brent will arm you with the tips and tricks he’s learned over the years managing multi-terabyte data warehouses and high-performing web sites. Attendees will learn:

  • How to use DMV’s to demystify what indexes you should drop or add
  • How to keep your indexes healthy with proper maintenance
  • How to build on the wizard’s recommendations and take even smarter actions

You can register to hang out in person in Aliso Viejo, or register to watch the webcasts online.

October 19 – StackOverflow DevDays – San Francisco, CA

The team behind the popular programming question & answer site Stack Overflow is putting together a series of $99 one-day conferences around the world. Developers get together, talk shop, make connections and attend seminars by coding deities. I’m not a coder, obviously, but I’m going because I bet it’s going to be an awesome environment. If you wanna learn, you gotta get outside of your comfort zone.

October 21-22 – Quest Connect Virtual Conference

Quest is putting on a completely free virtual conference with sessions on SQL Server, Exchange, SharePoint, virtualization, and much more. Sessions will include:

  • A Sysadmin’s Guide to SQL Server with Brent Ozar, Tim Ford and Tom LaRock – Scared to touch that SQL Server database? You can do it, and we can help. In this webcast, our SQL Server experts will show Windows administrators how to manage SQL Server with confidence. The experts will cover the basics of backup and restore, security and permissions, and performance tuning. Plus, they will show how a favorite Windows performance tool can help manage SQL Server.
  • Understanding Execution Plans with Grant Fritchey and Brent Ozar – Mystified by why your queries are running slow? Don’t be stumped – learn what the fancy diagrams mean and how to make your schema work for you. Grant Fritchey, author of SQL Server Query Performance Tuning Distilled, will boil down the basics in this one-hour session.
  • Top 10 SQL Server Administration Mistakes with Kevin Kline, Colin Stasiuk, Jason Strate, Mike Walsh – The defaults aren’t necessarily the best answer. Find out about things like autogrowth before they penalize your performance and risk your recoverability.
  • Practical Approaches to Designing and Managing your Virtual Infrastructure with George Pradel
  • Preparing for Your Upgrade to SharePoint 2010 Today with Joel Oleson
  • And many more live webcasts and on-demand webcasts!

You can register for the free Quest Connect conference here.

October 21-23 – SSWUG Virtual Conference

Performance Tuning for Race Car Drivers

Times are tough even for the best drivers: Helio Castroneves is dancing for money and Danica Patrick is doing ads for what appears to be an adult services company. Maybe it’s time to switch careers, and Brent has just the thing. Use your hard-earned knowledge of high speeds, million-dollar hardware and surviving disastrous crashes to become a SQL Server performance tuner!

In this session, Brent will show you:

  • Why Colin Chapman would check for indexes before adding new ones
  • The importance of well-tested safety gear to performance tuning
  • Why not monitoring your servers is like overdriving your headlights
  • Just like races are lost in the pits, uptime records are lost during maintenance windows

The Top 10 Developer Mistakes That Won’t Scale

You’ve heard it before: “It worked fine on my machine, but the users say it’s too slow.” Don’t blame the developers: they’re using SQL Server features that look great on paper, but in reality, they won’t scale up to production loads.

Learn to recognize these common mistakes before they go into production, and be armed with easy fixes for:

  • User-defined functions that go through too much data
  • Triggers that perform business logic
  • Cursors that process data row by row

Be Prepared for the New Virtual Reality

SQL Server does indeed work in virtual environments: the catch is that it doesn’t always work *well*. After years of working with SQL Servers running inside VMware and Hyper-V, Brent has gained valuable experience and learned some ugly lessons that he’ll pass on to you during his session.

In this session, Brent will show you:

  • Why your sysadmins want to virtualize your servers
  • The pros and cons of moving your SQL Servers into virtualization
  • How to monitor your server performance after you make the switch

For one low price, you get access to all of my sessions, plus tons of other great sessions. Register today! If you use VIP code SPBOUVC09 during checkout, you get an additional $10 discount.

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

What’s On My Bookshelf?

After I unpacked my new home office in Chicago, I was struck by the oddball contents of my bookshelf.  You might get a kick out of the list of books I’ve kept around over the years despite moving from state to state.  I’m merciless about discarding books as soon as I’m done reading them, so anything that’s survived has to be pretty good:

My Bookshelves

My Bookshelves

Top shelf, from left to right:

Bottom shelf, from left to right:

  • 101 Salary Secrets – because of my frequent blog posts about the HR side of database administration, I get a lot of questions on the salary topic.  This book crams a lot of info into a tiny package.
  • The Stand – epic work by Stephen King that really captured my apocalyptic imagination.  I’ve read almost everything King wrote, but I keep going back to reread The Stand.
  • A Heartbreaking Work of Staggering Genius – my sister gave me this a few years ago and said it reminded her of me.  I still haven’t finished it, but I love it.
  • So You Wanna Be a Rock & Roll Star – by the drummer of Semisonic, a flash-in-the-pan band I really liked.  Great book, too – reminds you that fame is fleeting.
  • The Art of War – by Sun Tzu, translated by Samuel Griffith.  I use lessons from this book at least once a week, and this would be the other of the two Brent-making-books.
  • Elements of Style – trying to improve my word skillz.
  • Getting Things Done – awesome productivity book.
  • Pygmy – by the author of Fight Club.  Couldn’t resist the cover and the author’s resume, and stashed this away for my next cruise.
  • The Whuffie Factor – everything you need to know about the way the world will work five years from now.  The job market is already changing, and this book isn’t just for businesses.  It’s for IT people too.
  • Unorthodox Strategies from the Art of War – the problem with picking up The Art of War is that it can be cryptic and tough to imagine as relevant to our daily corporate lives.  Sawyer helped me get into The Art of War for the first time.
  • Financial Peace – I declared bankruptcy back in 1996, and I had one hell of a tough time figuring out how to manage my finances.  Dave Ramsey’s book gave me the answers, and I’ve been really happy ever since.  The advice ain’t easy to implement, but the really good things in life take hard work.
  • I Am America (And So Can You) – I really believed my first book would be something like Stephen Colbert’s, a big package of hilariously strung-together falsehoods.  Maybe it’ll be my second.  Books like this call to me because there’s none of that fact-checking crap.
  • Talent Is Never Enough – it’s pop psychology motivational crap, but it’s right.  (Note: it has come to my attention that this book is not in the bookshelf photo.  That’s because it’s currently in my bathroom – I rotate books through there regularly.  Probably too much information, but somebody’s going to notice.  Just so you’ve got proof that I own it, I’ve taken a picture of myself with the book before.)
  • Wikinomics: How Mass Collaboration Changes Everything – you can’t believe everything you read, especially in this book.  It’s filled with dot-com companies that were destined to be The Next Big Thing, and now half of them have gone belly-up.  Good read though.
  • The Non-Runner’s Marathon Trainer – you can judge this book by the cover.  I’d never done any running before picking up this book, and it got me to my first 18-mile run.  It teaches you everything you need to know to train for a marathon – and I mean everything.
  • The Ultimate Hitchhiker’s Guide – most geeks probably read this in high school, then discarded it.  I reread parts of it periodically to remind myself of the kind of writing I strive for.
  • Tax Savvy for Small Business – I started an LLC last year and I keep kicking myself for not doing it sooner.  Unbelievable tax paybacks.

Now, having seen my oddball bookshelf, are there any books you’d recommend to me or the readers?

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

#SSPDreamTrip Contest Drawing Soon

This Thursday, I’ll be drawing the winner of the SQLServerPedia All-Expenses Paid Trip to the PASS Summit Contest.  I’ve noticed blogging activity and wiki activity really pick up this month as people try to increase their chances of winning, and there’s still some time left!  The winner will be drawn at random, but the more you blog & write, the better your odds.

My Pick - The Asus T91

My Pick - The Asus T91

Here’s the current standings:

  • Jen McCown – 15 entries
  • Mike Hillwig – 6 entries
  • Colin Stasiuk – 5 entries
  • Sankar Reddy – 4 entries
  • Jason Crider, Jorge Segarra – 2 entries
  • Brad Shulz, Jason Strate, John Pertell, Michael Swart, Ron Dameron – 1 entry

If you’re in the running, take a minute to double-check the entries list and make sure you’re getting credit for your work.  I’m tracking the entries manually, and I’m error-prone!

Oh, and what netbook do you think we should get the winner?  We haven’t picked one yet, but I’m leaning toward the Asus EEE PC T91.  It’s a tablet, so it’s easier to use on airplanes, and it’s still only around $500.

You can register to watch me draw the winner live on our Pain of the Week webcast this Thursday.  Tim Ford and I will be covering “The Hidden Treasures of SQL Server” – undocumented and rarely-used features that you can use to get more performance out of your SQL Servers.

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

Blog syndication – does it really work for bloggers?

Ask Colin Stasiuk, aka @BenchmarkIT on Twitter:

Part 1

Part 1

Part 2

Part 2

That’s great news!  It’s not all due to SQLServerPedia, though – Colin’s been writing great blog posts at his blog, BenchmarkITConsulting.com.

You can read more about syndicating your blog at SQLServerPedia.

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

Bookmarks for September 25th

These are my recent favorite links:

Unfortunately, there’s more, but the WordPress plugin I’m using will only import 15 bookmarks per hour. Grumble. To see the full list of what I’ve been reading lately, either check out my Delicious bookmarks or subscribe to my Google Reader feed.

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

Overdriving Your Headlights

The strength of your car’s headlights, the speed of your reactions, and the power of your brakes determine how fast you can drive safely at night.

Deer in the Headlights

Deer in the Headlights

Your headlights give you enough warning time to hit the brakes and stop your car before you hit an object. The better your headlights, the more distance you can see ahead, and the faster you can drive with confidence.

Let’s say your car’s headlights illuminate 350 feet in front of your car. Sure, you can see reflective signs from much farther away, but if a pile of lumber fell off a truck on the highway, it’s not going to be covered with reflective paint. To find out whether that 350 foot distance is far enough, we need to know three things:

  • How fast is your reaction time? – What’s the length of time you see the pile of lumber until the time your foot starts to move on the brake pedal? This length of time is affected by your alertness, your training, your muscle speed, and the iPhone you’re playing with while you’re driving.
  • How fast is your car going? – At 60 miles per hour, your car traveled 132 feet in the 1.5 seconds it took before your foot began to push the brake pedal. The faster you’re going, the more distance your car will travel.
  • How good are your brakes? – A Porsche 911 can stop from 60mph in 100 feet. If you’re going faster, or if your brakes aren’t as good as a 911′s, then you’re going to eat up more distance.

These factors combine to determine your safe stopping distance. Michael Schumacher might be able to drive at 100mph in a Ferrari using candles for headlights. You, however, are pushing the limits of your talents at 30mph even with those expensive fake xenons you installed on your Civic Si. Err on the wrong side of this formula, and you’re doing what’s called overdriving your headlights. People often learn this when the state trooper fills out the forms explaining why they hit the deer.

Monitoring and Forecasting: SQL Server’s Headlights

Most of us don’t bother with predictive analysis – we gather statistics with Perfmon, the DMVs, wait stats, and so on, but we’re looking in the rear view mirror – not ahead of us. Heck, some of us don’t even go that far; we wait until our phone rings and the users scream about dead bodies – uh, I mean, dead queries – lying around. We don’t have the time to project future growth and capacity needs because it’s a painful, time-intensive process with the native tools.

Serious performance tuning, though, requires looking ahead. Imagine being the head DBA for the New York Stock Exchange or NASDAQ systems: you simply can’t afford to wait until your end users call about lag times. You have to predict performance needs as far ahead as possible in order to design and implement an infrastructure to support those needs.

Unfortunately, there’s no quick and easy way to forecast how much our SQL Server CPU, memory and storage needs are going to grow in the next twelve months. DBAs can build their own data warehouses with performance data sourced from the DMVs, wait stats, SQL 2008′s Performance Data Warehouse, or Perfmon counters. To anticipate future needs and look down the road, the DBA would build time-based reports that use historical information to predict the future. This is left as an exercise for the reader.

Quest Capacity Manager

Quest Capacity Manager

Quest Capacity Manager makes this whole process point-and-click simple by combining storage, CPU, and memory requirements from various sources including Quest Spotlight‘s repository.

Another approach is to use your company’s financial metrics to predict system loads. DBAs in the financial industry often relate their system loads to stock trading volumes. They know that at a certain level of stock trading, their systems will have a certain level of loads. Instead of guessing SQL Server load directly, they can look at their financial analysts’ predictions of future stock volumes and use those to predict SQL Server activity. Your business may have similar transaction volumes – sales quantities, employee head counts, or widget production rates – that can help you guesstimate future database loads.

The farther down the road you can see, the more time you buy for reaction and braking.

Reaction Times in the DBA World

Reaction times measure the lag between your monitoring software’s alerts and your first action. Take one step backward if you’ve got an Outlook rule set up to automatically move all performance alerts out of your inbox and into another folder for later perusal. Uh-huh, I thought so. If you want to get a job driving the Ferraris of SQL Servers, you’re going to need to break the rules – specifically, your Outlook rules. Michael Schumacher didn’t win titles driving cars with automatic transmissions, and you can’t do serious SQL Server performance tuning by ignoring alerts.

The first challenge is to reduce false alarms coming from your monitoring system. Reconfiguring your monitoring system can be a constant challenge, especially if your monitoring systems are controlled by a different group in the company. This is one of the things I like about Quest Foglight Performance Analysis – the dashboard metrics show a historical high/low range, so you’re only alerted when a metric is outside of the established norm for a given server. Foglight PA even refines its baselines based on the day of week and time of day, because a CPU load metric that’s perfectly normal for noon on a workday might be completely out of the ordinary on Saturday at 9AM.

The second challenge is to be able to act faster when the alert comes in. In my experience, reaction times seem to be grouped in sizes of companies:

  • Small companies with one DBA – as soon as the DBA sees the alert, they either know right away exactly what action they’re going to take, or they have to hit the web to figure things out. They don’t have more senior DBAs on staff who may have seen a particular problem before, so some problems take longer than others to research before reacting.
  • Midsize companies with a couple/few DBAs – one DBA might be on call, but they may not know exactly what action they’re going to take right away. They may need to get approval from other DBAs before acting, or they may have security restrictions that stop them from taking serious actions like rebooting servers.
  • Large enterprises with multi-tier support groups, rigid policies, and run books – some problems are handled autonomously by help desk staff or first level support, and more serious problems are quickly escalated to the appropriate staff.

Each type of company has different solutions for reducing reaction times, and this sounds like a great idea for a future blog post series.  Note to self…

Braking Times: The Time Required to Fix Things

Just Like The Ones On Your Neon.

Just Like The Ones On Your Neon.

Just as race teams improve their stopping power by using new tools like ceramic brakes, you can use more advanced technology to help you solve problems faster. Some of the examples include:

  • Clustering improves your reaction time when dealing with broken server hardware.
  • Database mirroring helps you recover from a borked SAN or page corruption quicker.
  • SQL Server Enterprise Edition helps your database mirroring become even more powerful by compressing the data and by fetching corrupt pages from the mirror.
  • Virtualization can give you high availability for servers that might not ordinarily be able to afford HA.

Just like ceramic brakes, which can cost upwards of $10,000, none of these technologies are free. If you wanna go seriously fast, you gotta spend serious money, despite what you heard from that guy selling “Type R” stickers on eBay. Start by improving your reaction times first, because that’s free.

Want More Racing Performance Tips?

I’m doing a “Performance Tuning for Race Car Drivers” session at the SSWUG Virtual Conference. I illustrate SQL Server performance tuning using lessons from legendary Formula 1 icons Colin Chapman, Enzo Ferrari and Michael Schumacher.

I’ve been dying to do this presentation for months, and I’m excited to debut it at the SSWUG Virtual Conference. You can watch it in high definition along with dozens of other top-notch presentations from top-notch presenters on SQL Server, SharePoint and Business Intelligence.

Register today and use VIP code SPBOUVC09 to save $10 off the cost of registration!

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

Another Giveaway: Keyboards and Mice

Dayton Brown and Netster won themselves 120gb USB hard drives a couple of weeks ago in my Clean Brent’s Office Contest, but now that I’m settling into my new home office in Chicago, I’m finding even more unneeded gear lying around.

If Only I Had Something Insightful to Type

If Only I Had Something Insightful to Type

I have no clue how this happened (well, that’s not true – I have a pretty good clue, but I’m too ashamed to admit my stupidity on the blog) but I’ve found myself with half a dozen keyboards and another half-dozen mice.

Drawing time!

Prize Package #1: a Microsoft Natural Ergonomic Keyboard 4000 and a Microsoft Wireless Laser Mouse 6000

Prize Package #42: a Microsoft Natural Ergonomic Keyboard 4000 and a Microsoft Wireless IntelliMouse Explorer 2.0

Prize Package #11: an Apple Bluetooth keyboard and a Microsoft Wireless Presenter Mouse 8000.  Includes a Microsoft USB Bluetooth adapter.

Leave a comment by Sunday the 27th, and on Monday the 28th I’ll draw a winner.

In your comment, put the number of the prize package you’d like to win (only one). This introduces a little strategy; should you pick one you think nobody else will pick, or do you pick the one you really want?  Good luck!

Only one entry per person.  US residents only, because shipping overseas is complicated and I’m lazy.  No purchase required to win – all comments on this entry will be completely free of charge!  It’s your lucky week.

All of this gear is used – albeit lightly, because what human being in their right mind can use this many input devices at home?!?  None of this stuff comes with warranties or batteries, though, so your mileage may vary.  Odds are it all works – I don’t keep stuff around when it breaks, as evidenced by the fact that I’m not holding a drawing for the many Ethernet cables with busted jacks that I’m throwing away.

Update 9/29 – the winners were Brett Flippin (#1), Matthew Chestnut (#42) and Jack Corbett (#11).  Congratulations, guys!

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

More SQLServerPedia Bloggers

The #SSPDreamTrip contest keeps attracting new members to the community.  You can read more about the contest, and here’s our four newest bloggers:

Jason Crider (BlogTwitter)

Jason is a DBA/Sysadmin in Little Rock, Arkansas with over 10 years of IT experience. He holds a degree in Management Information Systems, a Masters in Christian Education, and is a certified MCITP Database Administrator for SQL Server 2005.  Some of his recent posts include:

John Sterrett (Blog)

John works for Orrick, Herrington & Sutcliffe LLP a Database Professional and Web Engineering Specialist in Wheeling, WV (Pittsburgh Area).  He focuses on developing data driven applications and database management.  Some of John’s recent posts include:

Lee Anne Pedersen (BlogTwitter)

Lee Anne is a SQL Server administrator with seven years of experience. She also tinkers in server administration, database development and programming.  When not studying SQL, Lee Anne is learning how to trade on the stock market.  Some of her recent posts include:

  • Where in the World is SQL Server 2008? No, it’s not a comment about the low adoption rate, but a tutorial on spatial data.
  • Discovering Aliases and Symptoms – Oracle folks use aliases kind of like SQL Server DBAs use linked servers, but different.  SQL Server’s new synonym feature gets even closer.
  • Disappointment But Hope – Like many other DBAs I’ve heard, Lee Anne was initially approved to go to the PASS Summit, but the recession knocked out those plans.

Todd McDermid (Blog)

Todd has been developing software for two decades. In recent years, he’s discovered Business Intelligence and the Microsoft platform – turning him into an evangelist for using BI to support performance management in his current organization. He’s currently a moderator of the MSDN SSIS forums, coordinator of several CodePlex open-source projects, a frequent blogger on SSIS topics, and has spoken at a few user group meetings and conferences.  Some of his recent posts include:

  • Looking Forward to Win 7′s XP Mode v2 – Todd talks about the challenges he’s had with this new virtualization technology.
  • One Year Milestone – he looks back at his most popular posts.  I used to do this on Jan 1 every year, need to get back to doing that.
  • Microsoft’s BI Certifications – the weaknesses of the current BI certification roadmap.  This same problem exists on the engine side too – I’d love to see a “Performance Tuner” certification, for example, because the current certs just don’t mean that much.

Two More Bloggers On Deck

We’ve had several requests from bloggers who write in other languages, but I didn’t want to have multiple languages in our RSS feed.  Long-term, we’ll need to create separate RSS feeds per language, but for now, two bloggers have decided to start writing in English to start reaching more readers.  I’m pairing them up with English-savvy editors to help improve the quality of their blogs.  More news on that this week.

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