SQL Server 7.0 and 2000 Clustering Resources
A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.
Your Friend the Computer
You know it is time to reassess your relationship with
your computer when....
Removing NT Administrators as Sysadmins
By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.
Quickly Enabling and Disabling Constraints and Triggers
In some cases, you may have to be able to quickly disable all the constraints and triggers in a database. This article shows you how to do this with a few lines of T-SQL.
Simplifying Instead Of Triggers
Instead of triggers are a new feature in SQL Server 2000 which greatly extend the functionality of triggers. This article covers a basic introduction to Instead of Triggers and illustrates possibilities for their use.
Using FileSystemObject with DTS
This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.
SP_MSForeachtable - Life Without Cursors.
Is there such a thing as a task where you would not need a cursor? Hidden in the depths of the master database are a series of stored procedures that can replace some cursors with these one-liners.
Standing Back And Looking At Benchmark Results
What do the TPC-C benchmarks mean to the average DBA? In this article, Neil Boyle steps back and looks at them from a practical view.
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers