(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
We both just got the MVP renewal emails – although I must admit to having some April Fools fun this morning on Twitter and the
I couldn't think of a really good April Fools Day joke to play, so I thought I'd share with you one that I played on
Blog posts in this series: For the hardware setup I'm using, see this post. For an explanation of log growth and its effect on perf, see this
Great news! Kimberly and I have started doing a bunch of work with SQL Server Magazine (of course we're already pretty heavily involved with their parent
Once in a blue moon I come across something cool and it happens to be Friday, and I blog about it. Last time was drinking
Way back in the mists of time, at the end of the last century, I wrote DBCC SHOWCONTIG for SQL Server 2000, to complement my
Back in January I offered a promotion as a way of introducing our maintenance/operations auditing services. Now I've completed a bunch of them, with some
Blog posts in this series: For the hardware setup I'm using, see this post. For an explanation of log growth and its effect on perf, see this
The March 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
Christmas comes but once a year… really? Then mine just came early on this afternoon's UPS truck. The very nice folks at Fusion-io just sent
Our first public class of the year is just over 3 weeks away! This is the *only* public class we'll be teaching in the US
(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
The very worst piece of advice I ever saw on the Internet was in response to someone asking on a SQL newsgroup ‘how can I
Blog posts in this series: For the hardware setup I'm using, see this post. For the baseline performance measurements for this benchmark, see this post. For the
[Edit 2017: this query is still entirely applicable on all current versions of SQL Server.] Here’s a little script I knocked up this afternoon to
(For the hardware setup I’m using, see this post. For the baseline performance measurements for this benchmark, see this post.) In my previous post in the
Back in September I blogged about an old 2005 bug that prevented DBCC CHECKFILEGROUP checking the partitions of an object on the specified filegroup unless
(For the hardware setup I’m using, see this post.) As part of my new benchmarking series I first wanted to play around with different configurations of
Okay, this post is describing some new services we provide (we are a consulting firm after all :-), but there's a promotion at the bottom where
I'm running some performance tests on the hardware we have (more details on the first of these tomorrow) and I was surprised to see some
At the start of the year I decided to get seriously back into playing with electronics after a long haitus. I agonized about where to
Yesterday I was discussing life-direction-changing-events with Kimberly and our great friend Libby and I thought it would be interesting to find out from people how
A couple of years ago I blogged about 3rd-party file system filter drivers and how if they're not coded correctly to cope with NTFS alternate
I've blogged about ghost records and the ghost cleanup task a couple of time before (the only place it is really explained AFAIK), but one
This is a quick post to clarify an article I saw on SQLServerCentral this morning that seemed to state that transaction rollbacks push data into
Due to some Microsoft date changes, the Spring SQL Connections show had to move to the week of April 12th. As a knock-on effect –
Happy New Year! The January edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A
(This is my last blog post for 2009 – thanks to everyone who reads my blog and takes part in the SQL community – hope
Earlier today there was a thread on Twitter asking about what degrees and academic background people have who work on SQL Server. I volunteered to
Earlier today there was a question on SQL Server Central where someone wanted to know what could be causing so many reads on their transaction
The first of our public classes (what we call Immersion Events) in 2010 is now officially open for registrations! We've teamed up with our good
I made them up. Yup. I’m talking about the guidance which is: if an index has less than 1000 pages and is in memory, don’t
This is an interesting performance bug concerning a broken query optimizer rule in 2008. Thanks to Dan Shargel (Twitter) for sending me info on this
My goodness – no sooner are we done with one crazy conference season when planning starts for the next lot! We've just finalized the line-up
2005 SP3 CU6 contains a fix for a corruption bug that can happen after rebuilding an XML index that contains XML elements greater than 8000
It's been a few weeks since my last posts but I've got a bunch in the pipeline coming up. Firstly, I've got it together to
We're sitting here in the Las Vegas airport on the way home to Seattle for 3 whole weeks and I've just finished uploading the resources
One of the things I love teaching is how the transaction log and logging/recovery work. I presented a session on this at both PASS and
Today's our rest day here at SQL Connections and one of the things on my list is to post all the resources from our recent
The November 2009 edition of TechNet Magazine is up on the web and contains my latest feature article, the second in a 3-part series on
It's PASS time again in Seattle and we've got a busy week lined up. It's going to be a cavalcade of meeting new people, and
For the last few weeks we were in Australia, teaching classes with our sister company SQLskills.com.au. After we were done with work we headed out
As part of the 2008 DBA class we’re teaching down here in Melbourne, I did a demo of using predicates and file targets with extended
I've finally gotten around to tidying up and posting a bunch of photos from the second half of our trip to Europe trip in September.
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.