Determine if BACKUP COMPRESSION is available
This script will determine the SQL Server version and edition in order to find out if BACKUP COMPRESSION is available.
2014-04-02 (first published: 2013-09-10)
916 reads
Scripts
Get the all user and their server role
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,570 reads
2014-03-31 (first published: 2014-03-03)
1,242 reads
DBCC,Backup, Verify and create Agent Job to restore
Script to Automatically Backup, Drop and create Agent Job to restore from that backup.
2014-03-25 (first published: 2014-03-03)
1,071 reads
Using Seqence Container instead of Identity
This script is an example of how to use Sequence, similar to Identity.
2014-03-24 (first published: 2014-02-25)
1,355 reads
Script to Check the Database Backup duration
Script to Check the Database Backup duration of entire instances
2014-03-19 (first published: 2014-02-25)
2,136 reads
Script to Get the Database Restore history
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,312 reads
Script to Get the Backup History
Script to get the database backup history on SQL Server 2000/2005/2008
2014-03-14 (first published: 2014-02-25)
1,541 reads
2014-03-13 (first published: 2014-02-25)
1,108 reads
Calendar Table by Year
Populate a calendar table with user set interval start and end datetime values.
2014-03-11 (first published: 2014-02-21)
2,142 reads
Blogs
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
Forums
ALAMAT KONTAK BCA KCP Pecatu Telp:08218154393
WA:08218154393 nomor 275 Blok 4, Jl. Raya Uluwatu dan 5 No.99, Ungasan, Kec. Kuta...
ALAMAT KONTAK BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
ALAMAT KONTAK BCA KCP Benoa Telp:08218154393
WA:08218154393 Jl. Suwung Batan Kendal No.2, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80222
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers