This is the download page, where I’ve collected large scripts that aren’t practical to post in their entirety into a post, as well as other downloads. I’ve made an honest effort to test and verify them all, but bear in mind that I don’t have access to every type of advanced system setup and environment, so some of them may not work as planned on your particular server.
Read the complete disclaimer and copyright notice at the bottom of the page.
Display all effective permissions in a database
This script tries to compile all permissions, implicit and explicit for all user objects in a SQL Server database. Practical for security audits or general troubleshooting.
Decrypting SQL modules
This is the complete script as shown in the article Decrypting SQL objects. See the article for a full walk-through on what the script does.
Display active sessions and locks
This script is useful to identify long-running or blocked queries, including which resources are locked or blocked/blocking and loads of other information about the state of your server.
A function to calculate recurring dates
This is the fn_recurringDates() function featured in a post on creating a table value function that returns a series of dates based on a recurring pattern.
A replacement for sp_help: sp_ctrl3
A little hack that does what sp_help does – displays information about a database object. This procedure, however shows a bit more information, and uses a more “copy-paste” friendly layout so you can script the object more easily. Add “sp_ctrl3” as a keyboard shortcut in Management Studio to quickly view the definition of any database object.
Copying data from XML into tables
This is a script that I use to atomically insert relational data into multiple tables from a single XML blob. The XML blob can be built using the FOR XML AUTO construct.
Synchronizing logins from another server
This stored procedure will fetch logins, user-defined server roles and memberships from another server (like an AG primary replica) and sync those to the local instance.
General disclaimer and copyright notice
These are scripts that I’ve written and made available to you under the condition that you take responsibility for any consequences that may arise from using them. I do not recommend running them directly in production-like environments without thorough testing.
I cannot assume any responsibility regarding the accuracy of any output information, performance impacts on your server, whether the code performs correctly in your environment or any other consequences of using these downloads. It’s free, so it’s your ass. If your juristiction does not allow for this kind of waiver/disclaimer, or if you do not accept these terms, you are NOT allowed to store, distribute or use this code in any manner.
These documents are made available under the Creative Commons 4.0 (with attribution) license. In short, this allows you to freely use, modify and redistribute them without charge, though you have to quote the source (the URL of this blog, https://sqlsunday.com/, is fine).