2018-04-19 (first published: 2018-04-12)
3,990 reads
2018-04-19 (first published: 2018-04-12)
3,990 reads
Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion.
2018-04-13 (first published: 2013-03-19)
1,346 reads
Create views based on table definitions for backwards compatibility when relocating tables to a new database.
2013-08-16 (first published: 2013-07-30)
1,105 reads
Outputs an easily readable result of the database and server roles for database principals.
2013-08-05 (first published: 2013-06-14)
1,056 reads
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
2,008 reads
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots...
I wanted to share with you tools from my personal toolbox. If your code...
I have a tabular cube, with myself included in one of the roles. I...
Hi all, I’ve just open‑sourced T‑TEST, a tiny alternative to tSQLt that lives...
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers