2011-09-09 (first published: 2007-11-19)
8,962 reads
Scripts
Script a Database Role
Script one or all roles in a database. Includes users, obect permissions and column permissions.
2011-09-08 (first published: 2008-01-08)
5,301 reads
Generate Scripts to Compare Tables
Generate the scripts that will allow you to compare tables pass/fail.
2011-09-07 (first published: 2007-12-28)
12,637 reads
2011-09-06 (first published: 2011-08-13)
2,004 reads
2011-09-05 (first published: 2007-01-25)
4,022 reads
Getting Age in Text or Date Difference in text format
This function returns the difference between the date in text format
2011-09-01 (first published: 2011-08-30)
1,070 reads
2011-08-31 (first published: 2011-08-24)
2,602 reads
List all tables without LOB columns
Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).
Useful when rebuilding indexes online.
2011-08-30 (first published: 2011-08-25)
776 reads
Find gaps in primary keys across multiple databases
Output table of gaps in a primary key across multiple databases on same, remote and/or linked servers.
2011-08-29 (first published: 2011-08-12)
977 reads
2011-08-24 (first published: 2011-08-12)
1,187 reads
Blogs
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers