Offline for four weeks…
Hey folks, Just a quick note to let you know that Kimberly and I will be offline from this weekend for four weeks. We're going
Hey folks, Just a quick note to let you know that Kimberly and I will be offline from this weekend for four weeks. We're going
Last time I posted about SSDs I presented the findings from sequential inserts with a variety of configurations and basically concluded that SSDs do not provide
The July edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column (and I
Back at the start of July I kicked off a survey around your plans for SSDs (see here) and now I present the results to
Last week we sat down with our good friends Richard Campbell and Greg Hughes of RunAs Radio and recorded an interview about how to learn
Every month there's a flurry of blog posts around the same topic – it's called T-SQL Tuesday and is a neat concept. This month it's
Over the last month we've been teaching in Europe and I haven't had much time to focus on benchmarking, but I've finally finished the first
This November Brent, Kimberly and I will be at the PASS Summit in Seattle as usual doing workshops and Spotlight Sessions (90 minute sessions to dive deeply
With exactly a month to go until our 5-day Immersion event in Bellevue, WA we've got 25 people registered for the class (wow!) and space
It's been a while since I conducted blog surveys so I'm going to do a few through July and August. First up – I'd like
(Happy Independence Day to everyone back home in the USA! We’re in Dublin for another week…) Back at the end of April I conducted a
Since the start of the year we've been inundated with consulting and auditing requests, which is a good sign for the recovery from the economic effect
One of the places I really look forward to going every year is Dublin – not just for the countryside, friendly people, and our very
Many times I'm asked whether having multiple data files can lead to an improvement in performance. The answer, as with all things SQL (except concerning
(Check out my online training courses: SQL Server: Detecting and Correcting Database Corruption and SQL Server: Advanced Corruption Recovery Techniques. We can also help you with disaster recovery.) As a
(Check out my online training courses: SQL Server: Detecting and Correcting Database Corruption and SQL Server: Advanced Corruption Recovery Techniques. We can also help you with disaster recovery.) One of
Yesterday morning I was tagged in a blog post by my very good friend Buck Woody (twitter|blog), wondering how I travel (and by extension, how
A couple of weeks ago, Kimberly and I spent a week on the *excellent* live-aboard dive boat Cayman Aggressor IV, diving off Grand Cayman, Little
The 20-page whitepaper I wrote this Spring for the SQL team has just been published. This whitepaper is titled Proven SQL Server Architectures for High
Next Wednesday, June 9th, I'll be presenting at the monthly meeting of the PASS DBA virtual chapter. The Live Meeting starts at 11am PST and
It's official! We're doing another 5-day SQL Immersion Event (our ever-popular SQL Server master-class) this year in the US! We decided to put on a
It's been a while since we had a vacation (and more than a year since we last went diving!!) so tomorrow we're off for a couple
The top things YOU need to know about managing SQL Server – in one place, on one day – presented by two
I was teaching an internals/maintenance/performance class for Microsoft DBAs this week on the Redmond campus and one of the students (thanks Crystal!) showed me a
[Edit March 2026: Everything in this post applies to all versions of SQL Server still.] This blog post is part of the monthly T-SQL Tuesday
This evening I was reading an article in The Washington Post called Twelve Things The World Should Toss Out and it inspired me to start a
In the previous post in the series I introduced SSDs to the mix and examined the relative performance of storing a transaction log on an
The May edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
Well it's been almost 6 weeks since my last benchmarking blog post as I got side-tracked with the Myth-a-Day series and doing real work for clients :-)
I’m starting a new blog category to talk about some of weird and confusing stuff I see while query tuning. First up is the case
Here's yet another reason to be very careful when using the missing index DMVs… There's a bug in the missing index DMVs that could end
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
For about 6 months we'd bee trying to hook up online with SharePoint MVP Hilton Geisenow for an interview but unfortunately the bandwidth to South Africa is
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
Over the last few months there's been some noise (mostly of my making) on Twitter about the number of VLFs in transsction logs. Given the
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
Just when I thought I'd discovered all the online networks that could successfully prevent me from doing useful work, I re-discovered LinkedIn this morning after
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
We enjoyed Dublin so much in 2008 and 2009 that we're going back for two weeks this time – and teaching three classes while we're
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
Yes, it's that time again. We've just completed the Spring show so its time to start planning for the Fall 2010 show. Once again Kimberly and I
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.