2011-06-13 (first published: 2008-04-19)
5,874 reads
2011-06-13 (first published: 2008-04-19)
5,874 reads
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,604 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,490 reads
Easily remove duplicate records without temp tables by using a CTE.
2011-06-07 (first published: 2008-03-19)
6,958 reads
2011-06-03 (first published: 2008-08-18)
1,123 reads
2011-06-02 (first published: 2008-04-24)
9,326 reads
2011-06-01 (first published: 2007-09-02)
10,507 reads
2011-05-30 (first published: 2011-05-23)
2,442 reads
Script generator to restore to a new DB. Designed on Ola Hallengren's backup solution.
2011-05-27 (first published: 2011-05-20)
977 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,234 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby. Baru, Kota...
WhatsApp:0817819444 Jl. Brawijaya 79, Dusun Muncar Baru, Tembokrejo, Kec. Muncar, Kabupaten Banyuwangi, Jawa Timur...
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers