2018-04-19 (first published: 2018-04-12)
4,240 reads
Rename Foreign Key Constraints
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,361 reads
Generate Create View statements for database tables.
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,116 reads
Quick view of User database and server roles
Outputs an easily readable result of the database and server roles for database principals.
2013-08-05 (first published: 2013-06-14)
1,066 reads
Search for String in all columns
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
2,068 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers