Delete All Database User Accounts for a Given Server Login
Easily and quickly delete all database accounts even if they don't have the same name as server login.
2015-05-05 (first published: 2013-07-18)
6,867 reads
Find Stored Procedures and Functions That Reference Certain Tables
Find any code objects that interact with a given table/view, or call another given code object.
2015-04-10 (first published: 2013-07-05)
4,616 reads
Defrag All Indexes On a Database
Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.
2012-05-25 (first published: 2012-05-15)
3,199 reads
Blogs
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
A Small LLM Fail
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
SQL Server Versions: Out With the Old, In With the Supported
By Kevin3NF
If your production SQL Servers are still running 2016 (or older) you’re basically banking...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQL Server Ghosts
Comments posted to this topic are about the item SQL Server Ghosts
The Selfish Case for Learning AI
Comments posted to this topic are about the item The Selfish Case for Learning...