2018-04-19 (first published: 2018-04-12)
3,055 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,338 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,099 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,053 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)
1,867 reads
Blogs
You should be running on SQL Server 2022
It’s me again with my apparently semi-annual blog post. This time we’re going to...
Removing a PowerShell Array Element–#SQLNewBlogger
By Steve Jones
I saw an article on this and realized I had no idea how to...
PostgreSQL Backup Failure
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
Forums
SQL AOAG with listener ( without windows clustering)
Hello, I am deploying SQL 2019 Enterprise edition with AOAG ( without windows clustering)....
Event ID 65102 [Warning] FailoverClusterQueryError
Hello @all, i am facing a problem and can not find a solution... I...
Check scheduled pipelines in ADF
We are used to the job activity monitor in SQL server allowing quick checks...
Ask SSC