SQL Server 2000 Backup and Restore

This paper discusses the types of backups that are available in SQL Server 2000 and how backup functionality can be used in a disaster recovery plan. It includes general recommendations on how to improve backup and restore throughput and several case scenarios.

A Guide to SQL Server 2000 Transactional and Snapshot Replication

Two MVPs at one shot in this one. SQL Server MVP Hilary Cotter has written a book on replication, one of the very few there are on this topic. And it's presented as a review by MVP Adam Mechanic, a regular visitor to SQLServerCentral.com. If you're looking for replication help, check out this book.

Extending Microsoft SQL Server 2000 Reporting Services with Custom Cod

This article presents an excerpt from the book, Microsoft Reporting Services in Action, by Teodor Lachev. Learn how to implement advanced report functionality using custom code.

Importing The Latest File In A Folder Via DTS

Using the Dynamic Properties Task in SQL Server 2000 DTS is a great way to build a flexible package that can handle a variety of situations. Things are much improved in SQL Server 2005 Integration Services, but many of you will need to solve a common problem until you can upgrade. New author David Jackson brings us a technique for finding and processing the latest file in a folder.

Deliver User-Friendly Reports from Your Application with SQL Server Re

Flexible reporting capabilities are a requirement for most business applications and their integration into Web apps makes them more versatile than ever. With the recent release of SQL Server™ 2000 Reporting Services, you can easily add reporting from diverse data sources. In this article I will introduce report authoring using Visual Studio® and Reporting Services and demonstrate how to integrate reports into your Web applications.

Reporting Services is a server-based reporting platform that is built on the .NET Framework and integrated with SQL Server 2000, so you can integrate rich reporting features into your apps using an extensive Web services-based API. Although the report server uses SQL Server as the repository for reports, any data source with an OLE DB, ODBC, or ADO.NET provider can be used to supply data to the reports, making Reporting Services a great choice for reporting in diverse enterprise environments.

SQL Server Scripting and WMI

Ever been paged while out with your family for some SQL Server problem that had you cutting an evening short? New author Anthony Loera has and he brings us some scripts that he uses to handle some of those crisis from any email device, PDA, phone, and keep him in front of his kids on the weekends.

Step-by-Step Guide: How to patch SQL Server

ADVERTISEMENT

So you've decided to secure your SQL Server infrastructure and you don't know where to start. This first guide in a two-part series on SQL Server patch deployment will help you track down those pesky servers before getting them properly patched.

SQL Servers represent a significant security challenge for a number of reasons. Primarily, they are ubiquitous. Hundreds of software packages use SQL Server as a data store as do a large number of commercial websites.

Congratulations Frank

A Longtime SQLServerCentral.com member and a very valued member of the community has just received a great honor in our field. Take a moment to read and add your congratulations.

Anatomy of an IT disaster: How the FBI blew it

Some FBI agents ruefully refer to the trilogy project, a massive initiative to modernize the FBI's aging technology infrastructure, as the "Tragedy" project. It certainly has all the earmarks of tragedy: the best intentions, catastrophic miscommunication, staggering waste.

More Portable DTS Packages

There have been a few articles over time on how you can build DTS packages in SQL Server 2000 that are easily moved from one server to another. New author Tito David brings us another technique that not only migrates packages easily between servers, but between your development and production environments.