Detect and Repair Non Trusted Foreign Keys
Create the code to detect and repair non trusted foreign keys
2018-10-23 (first published: 2018-09-27)
717 reads
Scripts
2018-10-12 (first published: 2018-10-04)
1,173 reads
How to Identify backup tables within production databases
How to identify backup tables within production databases that can be removed.
2018-10-05 (first published: 2018-09-28)
577 reads
number of rows and columns of an instance
Get the number of rows, columns, and space used by all tables in all databases
2018-10-03 (first published: 2018-09-20)
517 reads
Data Collections restart and clear cache files
Script to stop the default Data Collection sets, clear the cache files and then restart collection sets.
2018-10-02 (first published: 2018-09-25)
1,456 reads
Conditionally Order By Different Column
Order records based on a different column depending on which absolute value is greater.
2018-10-01 (first published: 2018-09-26)
651 reads
2018-09-26
476 reads
dba_CopyLogins
A copy of the late Robert Davis' dba_copylogins stored procedure with a bug fix. The SP copies logins, roles, and permissions between servers.
2018-09-24 (first published: 2018-08-28)
1,797 reads
2018-09-21 (first published: 2018-06-01)
2,094 reads
2018-09-20 (first published: 2018-08-28)
902 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers