2007-09-11 (first published: 2007-05-03)
557 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,961 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)
363 reads
Blogs
Flyway Desktop Projects for My PoC
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Daily Coping 30 Jan 2023
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Forums
flekosteelbalzam
flekosteelbalzam Svratite u jedan od brojnih kozmetičkih salona u četvrtima Hawthorn, Kew ili Richmond...
Microsoft SQL over IPSEC VPN TPLink routers - 2 locations
Hi Experts. We recently set up a second location. our software at our first...
Trouble moving from a 2017 SQL Express DB on one HP laptop to another HP laptop
I am trying to migrate a DB from an old dying laptop to a...
Ask SSC