Every now and then, I get a comment from someone thanking me for one of my older videos. There’s still a lot of good stuff in here, so I thought I’d put up a reminder – here’s some of my favorite videos from the past:
#5: BLITZ! SQL Server Takeovers
You’re just sitting there, minding your own business, when somebody comes running in out of nowhere and tells you the company’s got a SQL Server hidden under somebody’s desk. You need to get a quick picture of whether that server is healthy or not, and you don’t have much time to do it. In this video, we explain how to use my Blitz script.
#4: Top 10 Developer Mistakes That Won’t Scale
At TechEd last year, I covered the most frequent coding performance issues I’d been seeing in the field. Today, I still see these same issues over and over at client engagements, and I’m sure I’ll continue to see them in the future. It’s easy to misuse and abuse some of these features.
#3: SQL Server Index Tuning
Microsoft SQL Server constantly tracks which indexes are being used and which indexes should be added. That data is accessible to us in the form of Dynamic Management Views (DMVs), but those DMVs can be easily misread. I explain how to get started with index tuning in this video with Kevin Kline:
#2: T-SQL Tuning for Race Car Drivers
Formula 1 drivers live on the edge, pushing their cars as hard as they possibly can. The concepts in this video can’t be used on every server you have, but when you need to push your server to the limits, these help get you there.
Which brings us to our #1 classic video that every SQL Server database administrator should see…
#1: The Hawaii Chair
This one isn’t my video, but when you’ve mastered the content in those first four videos, you’re going to be a lot more relaxed around the office. You’ll be less stressed out, you won’t be running from emergency meeting to emergency meeting, and people won’t be bothering you. While you’re sitting around surfing funny source code comments at StackOverflow, take advantage of that spare time to lose weight with the Hawaii Chair:
As an added benefit, if anybody does come to your cubicle to ask a question, they’ll be so horrified by the Hawaii Chair that they’ll probably leave immediately. Win!