2007-09-11 (first published: 2007-05-03)
561 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,962 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)
364 reads
Blogs
Elastic Jobs for Azure SQL DB
I know if you are a SQL Server DBA using Azure SQL DB, you’ve...
Undercover Catalogue 0.4.4 Released – Database Last Accessed Time and NEW Snapshot Module
Full documentation on the Undercover Catalogue can be found HERE It’s been a while...
Forums
Full vs. Incremental Loads – Data Engineering with Fabric
Comments posted to this topic are about the item Full vs. Incremental Loads –...
Restoring the Resource Database
Comments posted to this topic are about the item Restoring the Resource Database
Missing the Office
Comments posted to this topic are about the item Missing the Office
Question of the Day
Restoring the Resource Database
How can I restore a version of the Resource Database in SQL Server 2022?
See possible answers