This script simply returns the most recent restore information about databases for a server.
Returns the destination database name, the device used to perform the restore and the restore date.
2015-07-15 (first published: 2015-06-10)
751 reads
This is an expansion of the sys.schemas table.
User schemas are sorted to the top, schema type is decoded, schema authorization is included.
2015-07-14 (first published: 2015-06-10)
1,858 reads
it is a 3X3 dynamic sudoku
2015-07-10 (first published: 2015-06-11)
1,004 reads
IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.
2015-07-02 (first published: 2015-06-04)
679 reads
This script either generates or execute statements to SQL data and log files from C:\ to D:\
2015-07-01 (first published: 2015-06-03)
2,485 reads
-- Backup Growth Trend Check To Understand how much disk space you need in future
2015-06-23 (first published: 2015-06-02)
1,296 reads
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2015-06-17 (first published: 2015-06-03)
1,667 reads
If you have a requirement to setup with a default global dbmail profile and account you can use my script.
2015-06-16 (first published: 2015-05-28)
1,086 reads
Backup all user databases on a SQL Server instance.
2015-06-15 (first published: 2015-05-22)
2,411 reads
https://github.com/ktaranov/sqlserver-kit/blob/master/Scripts/Count%20character%20matches.sql
2015-06-08 (first published: 2015-05-18)
1,090 reads