A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.
2011-06-10 (first published: 2011-05-27)
1,589 reads
When creating a backup that will be restored to a development database, you may need to mask PII information. This script will help you with that.
2011-06-09 (first published: 2011-05-25)
1,470 reads
Easily remove duplicate records without temp tables by using a CTE.
2011-06-07 (first published: 2008-03-19)
6,944 reads
2011-06-03 (first published: 2008-08-18)
1,108 reads
2011-06-02 (first published: 2008-04-24)
9,294 reads
2011-06-01 (first published: 2007-09-02)
10,486 reads
2011-05-30 (first published: 2011-05-23)
2,423 reads
Script generator to restore to a new DB. Designed on Ola Hallengren's backup solution.
2011-05-27 (first published: 2011-05-20)
966 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)
10,195 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,397 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...
Comments posted to this topic are about the item Hyperscale Replicas II
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Comments posted to this topic are about the item Your Favorite Quotes
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers