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,116 reads
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,596 reads
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,912 reads
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,414 reads
The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-29
6,676 reads
This article shows you in a step-by-step manner how to restore the master database.
2001-04-29
8,935 reads
Everyone needs a stable environment. This article discussed ways to keep your team on the same page.
2001-04-25
5,798 reads
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-25
5,636 reads
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-24
6,961 reads
The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-22
5,913 reads
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
The post When is the perfect moment to build a data strategy in a...
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
We have a db close to 3 tb and rebuilding/ reorganizing indexes weekly is...
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers