Hello again... I came across something weird recently while trying to understand some strange behaviors we seen on our RDS instances in AWS. Here's some background. We have 18 RDS instances in AWS (various sizes) spread across 3 environments: test, stage and production. All 18 of them are using multi-az and SQL 2017 Standard Edition. … Continue reading AWS RDS multi-az setup falsely reports multiple secondary partners
Category: bugs
The joy of FILEGROUP_NAME (and probably other as well)
Part of my scripts collection, is a script that returns the details of a table: storage, metadata (sys.objects), partitioning, etc. I was using this script for quite a while and ran ok. Few days ago, however, after I disabled an index on a partitioned table it failed and the error was a bit puzzling: Msg … Continue reading The joy of FILEGROUP_NAME (and probably other as well)
SQL-PLAY 