Use the following queries to list a result set of all column data types to any specified database. In the 2nd query, you will see a result set based on all text based data type columns in your database (XML data type not included). Modify accordingly.
2014-04-07 (first published: 2014-03-12)
1,703 reads
2014-04-03 (first published: 2014-03-12)
1,220 reads
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,587 reads
2014-03-31 (first published: 2014-03-03)
1,249 reads
Script to Automatically Backup, Drop and create Agent Job to restore from that backup.
2014-03-25 (first published: 2014-03-03)
1,082 reads
This script is an example of how to use Sequence, similar to Identity.
2014-03-24 (first published: 2014-02-25)
1,368 reads
Script to Check the Database Backup duration of entire instances
2014-03-19 (first published: 2014-02-25)
2,145 reads
Script to get the Database restore history details including with the files by which the database is restored.
2014-03-17 (first published: 2014-02-25)
1,318 reads
Script to get the database backup history on SQL Server 2000/2005/2008
2014-03-14 (first published: 2014-02-25)
1,549 reads
2014-03-13 (first published: 2014-02-25)
1,117 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Jl. Pantai Indah Selatan Blok DF No.1 & 2, RT.5/RW.6, Kapuk Muara, Kecamatan Penjaringan,...
Jl. Pantai Indah Kapuk Utara I Blok F, RT.6/RW.2, Kamal Muara, Kecamatan Penjaringan, Jkt...
Comments posted to this topic are about the item When And How to Automate?
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers