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
Weekly reading #22
By damianwidera
A little bit late but it is here! It is Wednesday already and we...
A simple powershell script to look up server hardware and OS information
By SQLPals
This is a simple powershell script to query and display hardware and OS information...
Collecting Server Performance Metrics: Performance Monitor
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...
Forums
Evergreen SQL Server
Comments posted to this topic are about the item Evergreen SQL Server
Do you really know what’s happening with your servers?
Comments posted to this topic are about the item Do you really know what’s...
Going from long to wide
Comments posted to this topic are about the item Going from long to wide
Ask SSC