2008-02-21 (first published: 2008-01-09)
2,014 reads
Scripts
2008-02-18 (first published: 2007-12-27)
829 reads
2008-02-14 (first published: 2007-12-20)
1,053 reads
2008-02-13 (first published: 2007-12-18)
1,767 reads
Change column type on constrained columns
Use this proc if you need to alter a column that is part of a primery key
2008-02-04 (first published: 2007-12-10)
1,135 reads
String Tokenizer with Complex Search
Sample solution to replace string in expressions with multiple delimiters.
2008-01-31 (first published: 2007-12-05)
2,014 reads
2008-01-29 (first published: 2007-11-23)
1,987 reads
2008-01-28 (first published: 2007-12-03)
1,718 reads
Server Login/Role And DB User/Role Script
This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results
2008-01-25 (first published: 2007-11-27)
3,815 reads
2008-01-24
1,249 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
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...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers