SQL Server 2008 High Availability whitepaper published on MSDN

The 35-page whitepaper on high availability I wrote for the SQL team over the summer has been published on MSDN. It’s a 2-300 level whitepaper that describes the various high-availability technologies in SQL Server 2008 and how they can be used to mitigate disasters. It’s chock-full of links to other whitepapers, technical articles and Books […]

How do checkpoints work and what gets logged

This is a blog post I've been meaning to do for a while, and I've recently noticed some info on the web about checkpoints which is a little misleading, so I want to do a quick post to explain how checkpoints work as far as log records are concerned. When a checkpoint operation occurs, no […]

TechNet Magazine: October 2009 SQL Q&A column

(First blog post from Poland! We're here to present at the Microsoft Poland Technology Summit.)  The October 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: Unexpected consistency checks? How much space is each database using in the buffer […]

TGIF in Dublin

We've had a great week here in Dublin teaching our first public Immersion Event for a while – nearly 50 attendees spent the week with us exploring internals, performance, indexing, maintenance, and HA. Today's the last day where I'm teaching my favorite module on consistency checking and corruption recovery – excellent way to spend a Friday! […]

DBCC CHECKFILEGROUP bug on SQL Server 2008

Here's an interesting bug that surfaced recently, first reported by Bryan Smith on the MSDN disaster recovery/HA forum three weeks ago. One of the mechanisms I advise for running consistency checks on VLDBs with multiple filegroups is to run successive DBCC CHECKFILEGROUP operations on the filegroups holding the partitions (see CHECKDB From Every Angle: Consistency Checking Options […]

Birds, beasts, sunsets, and scenery on the Olympic Pensinsula

At the start of September we took a trip out to Kalaloch and Cape Flattery. I've been there quite a few times but it was the first time for Kimberly. As usual we took loads of photos and I've put three albums up on Facebook. Here's a small selection from each album. Birds and beasts […]

Survey: how do you create and maintain statistics

This survey is based on a suggestion from Jonathan Kehayias (blog/Twitter). In this survey I'm asking two questions: When you're designing/implementing a database, do you manually create statistics or let SQL Server create them automatically? How do you maintain statistics? Manually or letting SQL Server do it for you? Or both?  I'll probably collaborate with Kimberly on […]

Importance of having a good disaster recovery plan

A few weeks ago I kicked off a survey asking what kind of disaster recovery guide/run-book/plan (I'll just call it a plan from now on) you have (see here for the survey). Here are the results as of 9/15/09:   Out of all these answers, IMHO the last answer is the only acceptable one for […]

10-minute TV interview with me and Kimberly, plus a big announcement

While we were at Connections in Orlando in April, we sat down with our good friend Carl Franklin to discuss the conference, life, and a big announcement. Check it out at http://www.youtube.com/watch?v=6Tb0V-e0dCk. Enjoy!

When was the last time you saw one of these?

I've been spending some time reorganizing my electronic components and came across a serious blast from the past…   (Click the image for a larger version – 354Kb) Left to right, from top down: Zilog Z80 (popular in the Sinclair ZX computers) Intel 8085 from 1980 AMD 8080 from 1977 Intel 8086 from 1978 Intel […]

Memory: Large Pages and MemToLeave

I'm constantly surprised by the number of people that don't follow the CSS SQL blog – some of the best SQL people in the industry post there. I just revisited a couple of really interesting posts by my good friend Bob Ward on memory management internals that I'd like to publicize. The first (from June […]

Ireland SQL User Group September 23rd

While we’re in Ireland teaching our Immersion Event (week-long in-depth class on SQL Server internals/performance/maintenance/DR), we’ll be doing a user group meeting as well in Dublin on Wednesday September 23rd.  The Immersion Event (Septemer 21-25) already has a good class size but of course we have space for a a few more attendees – check […]