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,662 reads
Scripts
2008-08-01
847 reads
2008-07-29 (first published: 2008-06-08)
1,302 reads
2008-07-28 (first published: 2008-05-28)
4,335 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-25 (first published: 2008-06-10)
857 reads
get users across all databases on the SQL Server instance
Quick way to get all users on all Databases
2008-07-24 (first published: 2008-06-06)
1,690 reads
2008-07-23
490 reads
2008-07-23 (first published: 2008-06-05)
1,244 reads
2008-07-20
2,017 reads
2008-07-20
1,637 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers