Quick Tip: Taking a Database Offline
An interesting database option which is hidden from Enterprise Manager in SQL Server 7.0 is offline.
2001-05-21
9,736 reads
Administration
Detaching and Attaching a Database
Detaching and attaching a database is an advanced trick that can be useful in anything from transporting your database to recovering from a disaster.
2001-05-10
17,093 reads
Sweeping Up The Slackers
Have you ever worked with an application that forgot to close its connections? Ever run out of connections on your SQL Server and had to manually go remove the ones that are not in use? This article will present a technique for keeping the database clean.
2001-05-07
5,143 reads
Using Xp_cmdshell
One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it.
2003-11-14 (first published: 2001-05-03)
39,696 reads
Moving Logins - A Gotcha!
This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5
2007-10-02 (first published: 2001-05-01)
10,939 reads
Log Your Changes
How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.
2001-04-30
5,438 reads
Restoring the Master Database
This article shows you in a step-by-step manner how to restore the master database.
2001-04-29
8,966 reads
Automatically Gathering Server Information Part 8
The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-29
6,711 reads
Keeping Your Developers Under Control
Everyone needs a stable environment. This article discussed ways to keep your team on the same page.
2001-04-25
5,819 reads
Automatically Gathering Server Information Part 6
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-25
5,687 reads
Blogs
A New Chapter: Why I Made the Move from Dayforce to ESO
By gbargsley
A New Chapter: Why I Made the Move from Dayforce to ESO Over the...
Lean Six Sigma – Brief
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
T-SQL Tuesday #200: Bad Query signals
NO AI was used to generate this content. Grammarly was used to check and...
Forums
Reading Parquet using openrowset
Hi, We are looking out to read parquet file directly from on premise shared...
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers