Jonathan’s latest Pluralsight course has been published: SQL Server: Using SentryOne Plan Explorer. It’s almost 3 hours long, and from the course description: Query plan analysis is both
I just spent a couple of hours fruitlessly trying to solve a problem and thought I’d blog the solution in case anyone else hits the
It’s quite well known that you can optimize error log file management using SSMS to change the maximum number of error log files to 99
During every one of our Immersion Events, we designate Thursday evening as 'open mic' night where anyone can do a 15-minute presentation on anything they
This survey is off-topic and was suggested by Justin Dearing (blog|twitter) and I'm curious about the results too so I agreed to run it. We're
(In this post I'm not going to name-and-shame, as I'm sure the problems will be fixed in time.) I want to warn you about unthinkingly
I just about beat my fists against my laptop this afternoon while updating a couple of demo scripts for our Performance class in Dallas this
(Yes, I know I haven’t editorialized the last survey on What’s in a Job Title – I will in the New Year.) Over the last
A few people have asked over the last few days how Kimberly and I have SSMS set up for presenting so I thought I'd do
(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
(Check out our Pluralsight online training course: SQL Server: Improving Storage Subsystem Performance.) A while ago I blogged about disk partition alignment, and how the default
It's very commonly known that you can use the Script Wizard in Management Studio to script out tables or even an entire database. It's NOT
It's lunchtime for my class – time for a blog post! This is an interesting one that crops up every so often (just an hour
Just found this excellent blog post (continually updated) that lists a ton of free SQL Server tools for all sorts of purposes. Check it out
Hopefully all of you reading my blog already know to use the WITH ALL_ERRORMSGS option whenever you run DBCC CHECKDB (which is now the default
Last week's survey was two-fold – what's the largest SQL Server database you manage, and how many SQL Server databases are you responsible for managing.
Another quickie today. If you're using Activity Monitor in SQL Server 2008, or Performance Data Collection with the Server Activity system data collection set, then you may
Not much to do here in Tokyo while waiting for the Bangkok flight except read and blog, and I've already done enough reading for one
The May 2009 TechNet Magazine is now available online, and it's the annual security issue. In there is an article I wrote highlighting 10 common
I came across a good post over at the Data Management section of Less Than Dot, describing how to scan through a network looking for
In my previous post today I talked about error 825 and how you should have an Agent alert set up to catch it when it
Now this one’s sure to spark some controversy… I was checking my RSS feeds of the SQL blogs that I follow and noticed an interesting
A couple of weeks ago I blogged about the three tracks of the SQL Server 2008 JumpStart course that SQLskills.com taught internally for Microsoft and
The second part of our radio interview with TechNet has been released (see here for part 1). In this installment we discuss troubleshooting and manageability
There’s a new whitepaper on TechNet that I’ve just come across (even though it was published 6 months ago!) called Predeployment I/O Best Practices. It’s
Hit another issue last night while playing with the latest CTP – VS2005 can’t cope with some of the changes in SS2008. The problem arose
I came across an interesting bug in Management Studio in the latest Katmai CTP today – when a connection disconnects from a database, SSMS doesn’t
While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL
One of the cool features added in SQL Server 2005 for scaling-out a workload was peer-to-peer replication. The major drawback was that to change an
[Edit 8/25/2013: The tool referenced in this post is no longer available.] During SQL Server 2005 development I did a comprehensive rewrite of the Books
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.