When is fast recovery used?
It’s been a bit light on technical posts here over the last few months but now that summer’s over I’ll be ramping up again with
Menu
It’s been a bit light on technical posts here over the last few months but now that summer’s over I’ll be ramping up again with
This is an interesting case that came up recently, and that I’ve seen a few times before, but which I haven’t seen explained anywhere. Using
The July 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
Last week I kicked off a survey about network latencies and database mirroring. See here for the original post. Here are the results of the
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
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
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
The 20-page whitepaper I wrote this Spring for the SQL team has just been published. This whitepaper is titled Proven SQL Server Architectures for High
The May 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
(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
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
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
Over the last week or so I've been helping the Product Support folks at Microsoft write a new KB article which discusses some of the
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
(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
A few weeks ago I kicked off a survey on how you add geo-redundancy to a failover cluster (see here for the survey). The results
There's another SQL Quiz (from Chris Shaw) doing the rounds where people blog the answer and then tag someone. This I got tagged by two
The June 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
While trawling through the latest 2008 Books Online this morning to answer a question, I noticed a new section that I hadn't seen before, which
OK – last content post today. I forgot that the February TechNet Magazine also has the latest edition of my regular SQL Q&A column. This
It's really scary how quickly time flies – seems like it was just last week when I last blogged about TechNet Magazine (actually it was
Today's post is based on a bunch of questions I've had around the various compression features in SQL Server 2008. Does turning on data compression
It’s been almost two weeks since my last post as we’ve been offline in Scotland (another photo post to follow – I owe you two
I just heard today that the first whitepaper I’ve written for Microsoft has been published! The abstract is: SQL Server Replication: Providing High-Availability using Database
My first magazine article is in print! I’ve taken over the bi-monthly SQL Q&A column for TechNet Magazine and I just received the June magazine
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
Wow – almost 10 days without a blog post – that must be a record for me! :-) Never fear – I'll be posting more
Phew – last week Kimberly and I spent 3 days teaching the ins-and-outs of SQL Server 2008 for DBAs/IT-Pros to about 130 Microsoft SQL Server
Just got an email notification of a new whitepaper from the SQL Customer Advisory Team on Database Mirroring and Log Shipping Working Together. It covers:
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
Here’s a question that came up yesterday in our chalk-talk on database mirroring at TechEd IT Forum that Kimberly and I talked about this morning (here
This is a question I was asked multiple times over the last week: the Microsoft guidelines for database mirroring say not to mirror more than
Sitting here in our Disaster Recovery class at SQL Connections and Kimberly’s on till lunch so I’m banging out a quick blog post covering the
(Been a few days since I posted – had some real work to do :-) Today I'll post a few things from the queue that's been
There’s been some discussion over on the SQL Server Central forums about database mirroring performance, and one question in particular on how to do index
As I mentioned in a previous post, one of the new features for database mirroring in SQL Server 2008 is log stream compression. There’s a
Ok – I’m on a roll today so to finish off I’d like to repost some info about database mirroring failover types (including how you
Part of the improvements to database mirroring in SQL Server 2008 are the addition of 10 new performance counters under the Database Mirroring Performance Object.
This was a question from the MSDN Disaster Recovery forum I started while I was at Microsoft. I have a 600 gig database that has
One of the hottest features in SQL Server 2005 is database mirroring, and it’s helped many companies implement successful and relatively inexpensive high-availability strategies. In
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.