2011-09-09 (first published: 2007-11-19)
8,945 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,288 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,623 reads
2011-09-06 (first published: 2011-08-13)
1,989 reads
2011-09-05 (first published: 2007-01-25)
3,997 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,062 reads
2011-08-31 (first published: 2011-08-24)
2,579 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)
766 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)
970 reads
2011-08-24 (first published: 2011-08-12)
1,177 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers