TechNet Magazine: Effective Database Maintenance article and August SQL Q&A column

Well, we’re just back from vacation (photo blog post to follow) and I’ve heard that the feature article on Effective Database Maintenance I wrote for the August issue of TechNet Magazine is live on the web. It also includes a 5 minute long screencast I recorded where I demo the effect of database shrink on index fragmentation.

You can get to the article at http://technet.microsoft.com/en-us/magazine/cc671165.aspx. The topics covered are:

Managing data and transaction log files
Eliminating index fragmentation
Ensuring accurate, up-to-date statistics
Detected corrupted database pages
Establishing an effective backup strategy

It’s written around 2-300 level and presents a good overview (well, at least I think so :-)) of the concepts involved.

Also, the August SQL Q&A column is available at http://technet.microsoft.com/en-us/magazine/cc671180(TechNet.10).aspx. This month’s topics on the web (more in the print magazine) are:

Database version changes with upgrades
Benefits of partitioning
Consistency checking options for VLDBs

Enjoy!

Posted Under:

Backup/Restore, Corruption, Database Maintenance, Involuntary DBA, Shrink, TechNet Magazine

Leave a Reply Cancel reply

Other articles

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

SQL101: Phishing attacks

I thought it was bad previously, but in 2026 I’ve noticed a big rise in emails trying to scam me into clicking a link –

SQL101: Top Ten SQL Server Performance Tuning Best Practices

There are a huge number of best practices around SQL Server performance tuning – I could easily write a whole book on the topic, especially

The Curious Case of… no buffer pool memory and no OS memory available

Jonathan had a client issue recently where SQL Server’s buffer pool had been forced down to a ridiculously small size, only a few hundred MB,

The SQL Server Transaction Log, Part 3: The Circular Nature of the Log

(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: Indexing Strategies for SQL Server Performance

One of the easiest ways to increase query performance in SQL Server is to make sure that it can quickly access the requested data, and

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.