SQL Server 2000 Reporting Services is becoming a more and more popular reporting option everyday. However, the disaster recovery plan for this add on is not a simple backup and restore since there are multiple pieces and servers usually involved. However the DBA may be responsible for the entire system. Mike Pearson brings us a look at some of the scenarios that you need to consider and what you might need to prepare for disaster recovery of SQL Server 2000 Reporting Services.

Reminiscing

by Steve Jones

SQLServerCentral.com

Miscellaneous

Steve Jones has been working with SQL Server for 10 years. Join him for a stroll down memory lane.

Removing the Builtin Administrators - Some Pitfalls to Avoid

by Kathi Kellenberger

SQLServerCentral.com

Security

The SQL Server 2000 security model is not the best one of all the RDBMS platforms and requires some work to secure properly. One of the practices that is recommended is removing the builtin/administrators group from accessing the SQL Server. New author Kathi Kellenberger shows us some of the pitfalls she encountered when removing this group from her servers.

Replacing Cursors and While Loops

by Clinton Herring

SQLServerCentral.com

Advanced Querying

Get some big performance gains by removing cursors from your code. New author Clinton Herring brings us a couple hints as he shows how two cursors were replaced in his code, resulting in 80 minutes of processing time dropping to 12!

Seamless Upgrade

by Steve Jones

SQLServerCentral.com

Editorial

One of the things mentioned in a keynote at the recent PASS conference was the idea that SQL Server 2008 would be a seamless upgrade. Or maybe I misunderstood and it will seem less like an upgrade 🙂

SQL 2000 to SQL 2005: Where have all the old features gone?

by Boris Baliner

SQLServerCentral.com

SQL Server 2005 is out and everyone is moving to test and deploy it. However many people are still managing SQL Server 2000 instances. New author Boris Baliner brings us a few tricks to find that information you are used to from Enterprise Manager.

SQL Server and SOX

by alzdba

SQLServerCentral.com

Security

The Sarbanes-Oxley act has changed many IT jobs, usually requiring more work and documentation. Johan Bijnens brings us a list of some things his team has had to do to comply with SOX regulations.

SQL Server Auditing - Part 1

by Brian Kelley

SQLServerCentral.com

Security

Our SQL Server Security expert, Brian Kelley, brings us the first part of a new series on auditing. Most of the auditing articles we've had are based on how you audit changes to data. Brian looks at auditing from the server itself, explaining the different levels of auditing built into SQL Server 2000.

SQL Server Security Part 1

by Chris Kempster

SQLServerCentral.com

Administration

In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion.

SQL Server Security: Server Roles

by Brian Kelley

SQLServerCentral.com

Administration

As yo probably know, Brian covers security topics for us and does a great job. This week he looks at the fixed roles and points out a few things you may not have thought about.

Recovery Planning For SQL Reporting Services

Reminiscing

Removing the Builtin Administrators - Some Pitfalls to Avoid

Replacing Cursors and While Loops

Seamless Upgrade

SQL 2000 to SQL 2005: Where have all the old features gone?

SQL Server and SOX

SQL Server Auditing - Part 1

SQL Server Security Part 1

SQL Server Security: Server Roles

Blogs

AI: Blog a Day – Day 6: Embeddings – How AI Understands

The Book of Redgate: Mistakes

ADF Pipeline Debugging Fails with BadRequest – The Sequel

Forums

Dynamic Unpivot

Writing as an Art and a Job

String Similarity II

Question of the Day

String Similarity II