2011-06-01 (first published: 2007-09-02)
10,414 reads
2011-06-01 (first published: 2007-09-02)
10,414 reads
Script generator to restore to a new DB. Designed on Ola Hallengren's backup solution.
2011-05-31 (first published: 2011-05-20)
938 reads
2011-05-30 (first published: 2011-05-23)
2,398 reads
This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).
2011-05-25 (first published: 2008-03-05)
9,972 reads
SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server.
Update to Simon Facer's script.
2011-05-23 (first published: 2007-09-25)
13,207 reads
2011-05-23
289 reads
Stored procedure to backup all DB (chose user or system). You can do full, differential and log backups
2011-05-13 (first published: 2011-05-06)
3,048 reads
View login information for all accounts that use SQL authentication.
2011-05-12 (first published: 2011-05-09)
2,892 reads
This script is used for drop and create a new or existing user. IF User is already exists in database then first it will dropped and then recreate.
2011-05-11 (first published: 2011-04-28)
1,766 reads
Find the last day (or number of days in a month) in one statement without having to use IFs or BUTs.
2011-05-10 (first published: 2011-04-29)
2,412 reads
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers