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 [...]
Paul S. Randal
In Recovery...
Importance of monitoring a database mirroring session
Posted on: January 31, 2011 12:29 pm
Survey: inter-team relationships
Posted on: January 30, 2011 12:59 pm
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
Posted on: January 30, 2011 11:10 am
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
Posted on: January 29, 2011 8:10 am
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?
Posted on: January 28, 2011 12:52 pm
Anywhere in the world? If you do and you'd like a SQLskills swag-pack (cups, pens, laptop stickers), drop me an email (paul@sqlskills.com) and let me know your average attendance and your address and we'll get some stuff in the post for you. Cheers
So why do you want to come to our training? And the winner is…
Posted on: January 26, 2011 12:41 pm
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
Posted on: January 24, 2011 11:12 am
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?
Posted on: January 24, 2011 9:55 am
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!
Posted on: January 20, 2011 5:59 pm
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 SQLskills.com 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
Posted on: January 19, 2011 9:27 am
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 http://technet.microsoft.com/en-us/magazine/gg552991.aspx.
PASS Performance VC recording and slides on index fragmentation available
Posted on: January 19, 2011 9:19 am
Yesterday I presented my lecture Index Fragmentation: The Hidden Menace for the PASS Performance Virtual Chapter. The recording of the session, plus a PDF of my slides, and the demo scripts are now available from the PASS website. Check it out here (look for January 18, 2011). Enjoy!
SQLskills.com takes 5 of the top-10 sessions at PASS 2010
Posted on: January 19, 2011 5:24 am
PASS 2010 was a resounding success – the best ever PASS according to most. We at SQLskills.com 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
Posted on: January 17, 2011 11:58 am
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
Posted on: January 16, 2011 1:07 pm
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
Posted on: January 16, 2011 10:51 am
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
Posted on: January 11, 2011 7:20 am
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?
Posted on: January 8, 2011 9:36 am
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
Posted on: January 4, 2011 11:48 am
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 [...]
