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
Blogging – goal achieved – 72 days early
By HamishWatson
So I started blogging in 2016: So why blog….now? It is very interesting going...
Last Week Reading (2019-10-20)
By Kamil
Hello folks! 2 weeks passed but eventually, I have some news for you. Press...
“xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun” – git in terminal does not work after macOS upgrade to Catalina
By HamishWatson
This blog post is how to get git going after upgrading to Catalina (10.15)....
Forums
Modular ETL Architecture Design in SSIS
Comments posted to this topic are about the item Modular ETL Architecture Design in...
Backing up SSAS Databases
Comments posted to this topic are about the item Backing up SSAS Databases
Losing The Security Game
Comments posted to this topic are about the item Losing The Security Game
Ask SSC