TechNet Magazine: March 2010 SQL Q&A column

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 topics are:

Distributed transactions and database mirroring – why they don't work together
Background processes that can cause I/Os even with no connections to the server
How to restore backups from a file containing multiple appended backups
The perennial problem of production databases being too large to restore in development

Check it out at http://technet.microsoft.com/en-us/magazine/ff458345.aspx.

Posted Under:

Backup/Restore, Database Mirroring, IO Subsystems, Shrink, TechNet Magazine

Leave a Reply Cancel reply

Other articles

AI Stories and Thoughts

iAI is obviously the hot new thing and prognostications for the future range from the unicorns-and-rainbows life of idleness for us all to the post-apocalyptic

Reflections on 15 Years

(This was the editorial for my 300th SQLskills Insider newsletter last week, that I’ve been producing since March 2011! See bottom of browser window to

Presenting a workshop at PASS Summit West in Seattle!

I’m excited to be presenting at the Pass Summit in November! My pre-con workshop is my absolute favorite to teach Performance Tuning with Waits and

Summer Sale: $699 Blackbelt Bundle!

Summer Sale time! Hundreds of dollars lower-than-ever prices on our signature 158-hour Blackbelt training bundle: Check It Out! SQL Server Vector Search Bundle – 1

The SQL Server Transaction Log, Part 4: Log Records

(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the

SQL101: Application data consistency checking

It’s quite common for a company that experiences a corruption-causing disaster, but has no valid backups to restore from and no ability to fail over

Imagine feeling confident enough to handle whatever your database throws at you.

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.