Check owners, collations and backups
A script to check the owners, collations and backups on the server.
2012-04-16 (first published: 2007-10-19)
2,643 reads
Scripts
2012-04-13 (first published: 2007-10-19)
3,405 reads
Restore Server/Database users/roles
Restore server/database users and roles from another server when we are restoring databases to another server.
2012-04-12 (first published: 2007-10-23)
3,121 reads
Auto compression all indexs on all online db
Auto compression of index, if index includes > 1 million rows.
2012-04-11 (first published: 2012-03-19)
935 reads
Remove Logins Script
Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.
2012-04-05 (first published: 2012-03-26)
1,365 reads
2012-03-30 (first published: 2008-04-21)
3,224 reads
Generate index on foreign key columns
Script find all foreign key without index in database and create new one for them.
2012-03-29 (first published: 2008-01-25)
3,404 reads
Select, Update, Delete, Insert etc.. in many servers using 1 query
Query Servers using 1 sql statement. Will make your job easy!!!
2012-03-28 (first published: 2008-01-16)
3,366 reads
DBCC Reindex with Statistics Information and table name optional
Reindex all tables, showing statistics before and after reindexing, table name optional.
2012-03-27 (first published: 2008-01-30)
3,121 reads
2012-03-26 (first published: 2008-01-23)
3,251 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Kontak BCA KCP Suniaraja Telp:(08218154392)
Alamat Kontak WA CS 08218154392 Jl. Suniaraja Timur No.49, Braga, Kec. Sumur Bandung, Kota...
Alamat Kantor BCA KCU Bintaro Telp:08217555651
Hub Via Wa:628217555651 Alamat: Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd....
Alamat Kantor BCA KCU Alam Sutera Tlp:08217555651
Hub Via Wa:628217555651 Alamat: Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec....
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers