Importance of monitoring a database mirroring session

Last week I kicked off a survey about how you monitor your database mirroring sessions. See here for the original post. Here are the results of the survey:   The "Other" values were: 6 people monitor mirroring session state changes One uses a 3rd-party product to do monitoring One monitors response time for the application […]

Survey: inter-team relationships

I'm going to do two surveys this week. In this one I want to know what the relationship is like between the DBA team and the dev team wherever you work (or whatever comes closest team-wise). Remember the survey is completely anonymous. If you want to, feel free to add an anonymous or otherwise comment […]

Survey: database mirroring latency between servers

In my survey for this week, I'd like to know what you what the network latency is between your mirroring principal and mirror servers, and what kind of mirroring you're using. I'll report on the results during the second week of February. Thanks!

Two great blog series on joins and query plan operators

I was doing some research this morning for some query tuning on a client system and I came across a couple of blog series with some excellent posts for those looking to learn more about query plans (and as a handy reference). The first series is by Craig Freedman on the Query Processor team at […]

Do you run a SQL Server User Group?

(Edit 7/11/13: We’ve given out all our current user group swag – thanks) Anywhere in the world? If you do and you’d like a SQLskills swag-pack (cups, pens, laptop stickers), drop me an email ( and let me know your average attendance and your address and we’ll get some stuff in the post for you. […]

So why do you want to come to our training? And the winner is…

Wow! We had 35 entries in 5 days for our competition to win a free seat at our Master Immersion Event on Internals and Performance in Dallas in February. That was a lot of reading to get through to pick the winner, but we made it. Five people even started SQL Server blogs so they […]

Survey: monitoring database mirroring

In my survey for this week, I'd like to know what you monitor if you're using database mirroring. [Edit: The survey has closed now. See here for the results.] I'll report on the results during the first week of February. Thanks!

What’s in a job title?

Just before Christmas last year I created a survey to ask you what your job title is and additionally, if you wanted, what you actually did in your job. See here for the original post. Here are the results of the survey: ¬† I think that clearly shows the type of people reading my blog […]

Competition: win a free place in our class in February!

We’re really excited about the classes we’ve got coming up and to say ‘thank you’ to the SQL community for all your support of over the years, we’re running a competition. The contest is now closed. The Prize The prize is a free seat in our class in our 5-day¬†Internals and Performance class in […]

TechNet Magazine: January 2011 SQL Q&A column

The January 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 topics are: Diagnosing I/O subsystem bottlenecks Capacity planning for transaction logs Why there are no non-logged operations in user databases Check it out at takes 5 of the top-10 sessions at PASS 2010

PASS 2010 was a resounding success – the best ever PASS according to most. We at have even more reason to celebrate as it was the best ever PASS for us too! We're very proud of the fact that we had 5 sessions in the top-10, taking 1st, 2nd, 3rd, 7th, and 9th place. […]

SQLskills crew at SQL Connections in March

The spring conferences are creeping up on us and there will be four of us at SQL Connections in Orlando, March 27-30 (me, Kimberly, Bob, and Brent). Here's what we're doing: Workshops  3/27: Day of Scripting: Plumbing The Depths of SQL Server / PowerShell Integration (Bob Beauchemin) 3/27: The Building Blocks of a Healthy and Available […]

Adventures in query tuning: non-seekable WHERE clause expressions

I’ve been doing a lot of performance tuning work over the last couple of months and this weekend found something that’s very pervasive out in the wild. Kimberly was helping me optimize a gnarly query plan and spotted something in the code I hadn’t noticed that was causing an index scan instead of an index […]

Results of CPU power saving survey

At the end of December I showed you how to discover if power saving is enabled on your server, which can lead to variable and often degraded performance. I also included a survey to let me know what you found after running the free CPU-Z tool on your servers. See here for the original post. […]

T-SQL Tuesday #14: Resolutions – continue having fun

  This month's T-SQL Tuesday is being run by newly-minted fellow-MVP Jen McCown (blog|twitter) and the topic is about resolutions. And specifically about resolutions around technology you've been pondering. One of the things I try very hard to do is make it a bit fun when teaching people about SQL Server. Let's face it, it's a very, very […]

So you want to blog about SQL Server?

I've noticed a few new SQL blogs spring up over the last month or so and someone asked me on Facebook this morning about linking etiquette so I thought I'd lay out a few quick thoughts I have on the subject – some "dos", mostly "don'ts" – as general advice for successfully blogging in the […]

All MCM free training videos now available

The final set of MCM training videos we recorded for Microsoft have been posted on TechNet and are available for download. For your convenience, I've created a page that lists all the videos, with links, grouped together to match the training classes we provide. These videos are designed to give you an idea of the […]