2007-09-11 (first published: 2007-05-03)
553 reads
Find The Database Recovery Model
A simple script to find the database recovery model. Cut & paste into Query Analyser
2007-05-17 (first published: 2007-05-08)
2,958 reads
Easily Kill All Users In A Database
This simple script (ran from the master database) in Query Analyser removes all the requirements of collating currently connected spids to a database and the need to systematically open a cursor to kill each spid individually by simply placing the database offline, then immediately online.
2007-03-16 (first published: 2007-02-13)
359 reads
Blogs
Fixing the PoSh Hotkey in ADS
By Steve Jones
I installed the PowerShell (PoSh) extension in ADS recently. This is available in the...
Capture Execution Plans Only For Long Running Queries
I love questions. Most of all, I love questions I can answer. I spotted...
Daily Coping 28 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Simple Python question...
I have a table in SQL Server like this: CREATE TABLE #SymptomData ( ...
Regular expressions in script component
In one of our SSIS package we have a script component that validate a...
Ask SSC