Grant Permission to Specific objects(e.g. SP's)
Grant permissions to specific objects in Database using dynamic SQL.
2008-08-01 (first published: 2008-06-08)
2,635 reads
Scripts
2008-08-01
842 reads
Quick table finder
This little script will search for all matching tables on the SQL Server instance
2008-07-30 (first published: 2007-10-15)
750 reads
2008-07-29 (first published: 2008-06-08)
1,292 reads
Find the row with the most data
This script is a quick throw together that tells you which rows in a table have the most data
2008-07-28 (first published: 2008-06-10)
844 reads
2008-07-23
484 reads
2008-07-23 (first published: 2008-06-05)
1,232 reads
2008-07-20
2,008 reads
2008-07-20
1,631 reads
2008-07-17
357 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Google – NotebookLM on ThakurVinay blog
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers