Michael D. Reilly

Michael D.

Michael D. Reilly is a former contributing editor for SQL Server Magazine and Windows & .NET Magazine, an MCSE, and an MCT.

Multiserver Task Administration
With multiserver task capability, you can set up a backup or database-maintenance task on one server and run it on multiple servers. Here's how to set up multiserver tasks and reap the rewards of convenience and centralized reports.
New in 2000
Here are some new features of SQL Server 2000 that you need to be aware of before you migrate your databases.
Before and After
Before you upgrade your SQL Server 6.5 system, you need to prepare. After the upgrade, you can take several steps to utilize SQL Server 2000's new features.
Move Up to SQL Server 2000
If you've been putting off upgrading your SQL Server 6.5 databases, now is the time to bring them into the twenty-first century. Don't miss our tips, tricks, and advice about how to prepare for and implement an upgrade to SQL Server 2000.
Upgrading from SQL Server 7.0 to SQL Server 2000 1
Upgrading from SQL Server 7.0 to SQL Server 2000 is much less of a hassle than upgrading from SQL Server 6.5. Here's what you need to know.
Recovery Models
Here's the scoop on SQL Server 2000's recovery models and how to use them effectively.
Top 11 Backup Tips
SQL Server's native backup and restore utility is powerful and reliable. Here are 11 best practices to help you make the most effective use of this capability.
All About Stored Procedures 5
Tips for SQL Server certification exams.
Restoring Databases 3
Planning and practice can ensure a smooth, efficient restore when the inevitable happens.
Answers to Practice Questions--Restoring Databases 1
Check your answers to the practice questions.
Practice Questions--Restoring Databases
Test your knowledge of restore processes.
Practice Questions—Backup Strategies 3
Test your knowledge about SQL Server's backup process.
Answers to Practice Questions: Backup Strategies 1
Check your answers to the practice questions.
Practice Questions--The Transaction Log 1
Test your knowledge about SQL Server's transaction log, checkpoints, and automatic recovery process.
The Transaction Log 10
Before you can plan an effective backup and restore strategy, you need to understand the interaction among SQL Server's transaction log, checkpoints, and automatic recovery process.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More
Sep 1, 2015

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks 3

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
Aug 27, 2015

A Replacement for Maintenance Plan Backups 1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×