by Jim Czuprynski – If a disaster happened to your database server, could you recover from it? This article discusses the questions a DBA can ask to probe the realm of what we all hate to think about – the possibility of the untimely demise of a production database server. Learn how to become a fear
Author: SSWUG Research
SQL Server Startup Parameters
by Randy Dyess – Learn how to take advantage of SQL Server startup options.
Dynamic Context Switching
Writing a script that works with multiple databases spread across multiple servers isn’t as easy as you might think. Read how Alexander Kozak leveraged the notion of context switching to help him automate an onerous task.
An Automated Solution for Migrating Database Structures
by Simon Galbraith – Migrating database changes from the development database to the testing, staging, and live databases poses plenty of challenges. Learn why using an automated tool is the best way to deal with these challenges.
Troubleshooting SQL Server 2000 installation issues
In this article, Alexander Chigrik explains some problems that you can have when you install SQL Server 2000. He also tells you how you can resolve these problems.
Windows calls on the enterprise
By Joe Wilcox – Microsoft on Thursday will launch the most ambitious version yet of its Windows server operating system, as the company looks to push aside Unix servers and mainframes in the enterprise.
View Active dbprocs :: (Script Library)
Category: Backup Software Tags: Backup software, Restore softw Compatibility: SQL Server 7.x and later Description:
Check Last Backup Date :: (Script Library)
Category: Backup Software Tags: Backup software, Restore softw Compatibility: SQL Server 7.x and later Description:
Move logins :: (Script Library)
Category: Utilities Tags: Compatibility: SQL Server 7.x and later Description:
dfrag SQL :: (Script Library)
Category: Managed Hosting Services, Tools, and Solutions Tags: hosting, managed hosting, host Compatibility: SQL Server 7.x and later Description: