http://www.windowsitpro.com/authors/author/author/5777300/rss/5777300en-USSun, 27 May 2012 07:16:44 GMTSun, 27 May 2012 07:16:44 GMThttp://www.windowsitpro.com/article/remote-computing/multiserver-task-administration
By Michael D. Reilly
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.]]>Michael D. ReillyWed, 27 Mar 2002 00:00:00 GMThttp://www.windowsitpro.com/article/remote-computing/multiserver-task-administrationhttp://www.windowsitpro.com/article/installation2/before-and-after
By Michelle A. Poolet
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.]]>Michelle A. PooletFri, 25 Jan 2002 00:00:00 GMThttp://www.windowsitpro.com/article/installation2/before-and-afterhttp://www.windowsitpro.com/article/tsql3/new-in-2000
By Michelle A. Poolet
Here are some new features of SQL Server 2000 that you need to be aware of before you migrate your databases.]]>Michelle A. PooletFri, 25 Jan 2002 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/new-in-2000http://www.windowsitpro.com/article/configuration/move-up-to-sql-server-2000
By Michelle A. Poolet
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.]]>Michelle A. PooletThu, 24 Jan 2002 00:00:00 GMThttp://www.windowsitpro.com/article/configuration/move-up-to-sql-server-2000http://www.windowsitpro.com/article/installation2/upgrading-from-sql-server-7-0-to-sql-server-2000
By Michelle A. Poolet
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.]]>Michelle A. PooletThu, 24 Jan 2002 00:00:00 GMThttp://www.windowsitpro.com/article/installation2/upgrading-from-sql-server-7-0-to-sql-server-2000http://www.windowsitpro.com/article/database-administration/creating-sql-server-databases
By Michael D. Reilly
If database administration has been recently added to your list of duties, you’ll appreciate these step-by-step instructions about how to create and maintain SQL Server 2000 and SQL Server 7.0 databases.]]>Michael D. ReillyWed, 19 Dec 2001 00:00:00 GMThttp://www.windowsitpro.com/article/database-administration/creating-sql-server-databaseshttp://www.windowsitpro.com/article/log-files/top-11-backup-tips
By Michael D. Reilly
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.]]>Michael D. ReillyWed, 22 Aug 2001 00:00:00 GMThttp://www.windowsitpro.com/article/log-files/top-11-backup-tipshttp://www.windowsitpro.com/article/log-files/recovery-models
By Michael D. Reilly
Here’s the scoop on SQL Server 2000’s recovery models and how to use them effectively.]]>Michael D. ReillyWed, 22 Aug 2001 00:00:00 GMThttp://www.windowsitpro.com/article/log-files/recovery-modelshttp://www.windowsitpro.com/article/installation2/installing-sql-server
By Michael D. Reilly
Are you a network administrator who has recently become a database administrator, too? Here’s your guide to setting up SQL Server 2000 or SQL Server 7.0.]]>Michael D. ReillyTue, 14 Aug 2001 00:00:00 GMThttp://www.windowsitpro.com/article/installation2/installing-sql-serverhttp://www.windowsitpro.com/article/installation2/sql-server-7-0-installation-procedures
By Michael D. Reilly
Here’s a step-by-step guide to setting up SQL Server 7.0.]]>Michael D. ReillyTue, 14 Aug 2001 00:00:00 GMThttp://www.windowsitpro.com/article/installation2/sql-server-7-0-installation-procedureshttp://www.windowsitpro.com/article/stored-procedures/all-about-stored-procedures
By Michael D. Reilly
Tips for SQL Server certification exams]]>Michael D. ReillySun, 22 Oct 2000 00:00:00 GMThttp://www.windowsitpro.com/article/stored-procedures/all-about-stored-procedureshttp://www.windowsitpro.com/article/tsql3/restoring-databases
By Michael D. Reilly
Planning and practice can ensure a smooth, efficient restore when the inevitable happens.]]>Michael D. ReillySun, 24 Sep 2000 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/restoring-databaseshttp://www.windowsitpro.com/article/tsql3/practice-questions-restoring-databases
By Michael D. Reilly
Test your knowledge of restore processes.]]>Michael D. ReillyMon, 18 Sep 2000 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/practice-questions-restoring-databaseshttp://www.windowsitpro.com/article/tsql3/answers-to-practice-questions-restoring-databases
By Michael D. Reilly
Check your answers to the practice questions.]]>Michael D. ReillyMon, 18 Sep 2000 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/answers-to-practice-questions-restoring-databaseshttp://www.windowsitpro.com/article/sql-server-2000/practice-questions-151-backup-strategies
By Michael D. Reilly
Test your knowledge about SQL Server’s backup process.]]>Michael D. ReillyTue, 12 Sep 2000 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2000/practice-questions-151-backup-strategieshttp://www.windowsitpro.com/article/sql-server-2000/answers-to-practice-questions-151-backup-strategies
By Michael D. Reilly
Check your answers to the practice questions.]]>Michael D. ReillyTue, 12 Sep 2000 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2000/answers-to-practice-questions-151-backup-strategieshttp://www.windowsitpro.com/article/security/introducing-sql-server-security
By Michael D. Reilly
Learn how SQL Server logins, server roles, database roles, and permissions help you protect your enterprise data.]]>Michael D. ReillyThu, 31 Aug 2000 11:48:02 GMThttp://www.windowsitpro.com/article/security/introducing-sql-server-securityhttp://www.windowsitpro.com/article/sql-server-70/the-transaction-log
By Michael D. Reilly
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.]]>Michael D. ReillyTue, 22 Aug 2000 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-70/the-transaction-loghttp://www.windowsitpro.com/article/sql-server-70/setting-the-record-straight9793
By Michael D. Reilly
Contrary to SQL Server Books Online, SQL Server 7.0 checkpoints write all changed pages to disk immediately.]]>Michael D. ReillyTue, 22 Aug 2000 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-70/setting-the-record-straight9793http://www.windowsitpro.com/article/sql-server-70/practice-questions-the-transaction-log
By Michael D. Reilly
Test your knowledge about SQL Server’s transaction log, checkpoints, and automatic recovery process.]]>Michael D. ReillyTue, 22 Aug 2000 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-70/practice-questions-the-transaction-log