Automatically Gathering Server Information Part 5
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-24
6,900 reads
Administration
Automatically Gathering Server Information Part 4
The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-22
5,862 reads
Quickly Disconnect Users
Nothing is more annoying than having to disconnect users one by one. With this script, you will be able to quickly disconnect them with a few keystrokes.
2001-04-21
17,626 reads
Automatically Gathering Server Information Part 3
The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-20
11,151 reads
Process Tracking
It is not always possible to run a process on a set schedule. This article by Steve Jones looks at a technique for ensuring that your processes can run on whenever you need them to without any loss of data.
2001-04-18
4,691 reads
Renaming a SQL Server
Renaming a server can be a mystery in SQL Server. The symtoms that SQL Server displays after you rename a server makes it look like you made a bad mistake.
2008-02-15 (first published: 2001-04-11)
63,072 reads
Blogs
T-SQL Tuesday #153: The Thing That Changed Everything for Me – SQLFamily
Kevin Kline (b | t) is hosting T-SQL Tuesday this month and it is to “Tell...
Daily Coping 9 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Visiting with DBAs at midnight : T-SQL Tuesday #153
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our...
Forums
Any way to scale MS Vulnerability Assessment Tool
Hello experts, It seems like MS Vulnerability Assessment Tool is available only on a...
TDE setup during DB migration
Hello Experts I need to migrate a few DBS from one environment to another....
MAX not working with a CTE
I have a query that is supposed to return one patient id but even...
Ask SSC