Backup all Filegroups
A short script to backup all filegroups, for those who utilise filegroups within a database.
2011-06-29 (first published: 2010-07-20)
1,323 reads
Richard Doering
2010-12-30 (first published: 2010-03-18)
2,451 reads
Linked Server Connectivity Test
A short procedure for your tools database. Use it to test connectivity to linked servers.
2010-12-28 (first published: 2010-03-19)
6,607 reads
SQL 2008 : Uncompressed Objects Procedure
A Stored Procedure for your tools database. It lists uncompressed tables and indexes and also generates the SQL to compress them.
2010-12-22 (first published: 2009-08-27)
897 reads
Charpad - Character Padding Function
A generic character padding function. Useful for situations where you need fixed width formatting e.g. email reports.
2010-12-20 (first published: 2010-03-31)
2,265 reads
Index Fragmentation Status (includes Partitioned Tables/Indexes)
This script reveals the state of your indexes. It breaks down the indexes where they are partitioned, matching the index to it’s partition and filegroup.
2010-12-16 (first published: 2010-04-22)
7,312 reads
Windows Group Membership Checker
A script to reveal which logins have access to your sql server via windows groups.
2010-12-09 (first published: 2010-08-26)
2,354 reads
Blogs
So You Want to Deploy Power BI Project files (PBIPs)?
By Angela
Have you heard the news about the new Power BI Project files? Okay, maybe...
DBAs, Organizing Your SQL Scripts in Git
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
Only Capture Extended Events For a Given Time
It’s a great question. Let’s say you want to capture stored procedure completions. But,...
Forums
Logic similar to EXIST to make all values the same if it meets a criteria
Hello everyone, I have a question. Please let me know if someone has any...
Query Store with AOAG stuck on waiting
Hey Folks, I have a database on SQL 2019 CU24 in an AOAG with...
SQL Server 2022 Std edition eval version
Hi We are planning to upgrade our SQL Server 2014 Ent edition to 2022...
Question of the Day
Database Mail Editions
In which editions can I use Database Mail?
See possible answers