2008-02-25 (first published: 2008-01-15)
918 reads
Scripting extended properties
I use these to manage the addition and removal of extended properties on all tables and columns in my company's dbs.Rather than writing complicated joins or calling functions every time, I use views on sysobjects and INFORMATION_SCHEMA tables. I tried to make these scripts as flexible as possible so you can reuse them in procedures, […]
2006-01-05 (first published: 2005-11-11)
1,228 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