AWS RDS multi-az setup falsely reports multiple secondary partners

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

Change the PowerBI desktop default language

For whatever reason, I ended up with Romanian as the default language for PowerBI desktop (no regional settings, no browser settings, no nothing would provide a hint to the installer that it should install and set the app to Romanian). This did not help either: https://community.powerbi.com/t5/Service/change-PowerBI-language-menus-to-english-while-maintaining/td-p/4782 I ended up in C:\Program Files\Microsoft Power BI Desktop\bin, … Continue reading Change the PowerBI desktop default language

Why is important to separate data from indexes

Hello again. You all probably heard here and there that separating data from the indexes is good. Some of you even went down that road and actually did it. Which is good. There are also a ton of articles on this topic and the ones that come quickly to my mind are the ones authored … Continue reading Why is important to separate data from indexes

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)