I’ve encountered an issue while trying to compare a local SQL Server database against an Azure SQL DB using Redgate SQLCompare. When trying to specify my credentials, I got the following error: “Unable to load adalsql.ddl”.
Following that link actually leads you to a helpful page, where you can download the Active Directory Authentication Library for SQL Server. However, during set-up I got the following message:
Ugh. What you need to do is go to Control Panel and remove the program from the list, then re-install it again. Problem fixed! Keep in mind you cannot use the dropdown to select the database when connecting to Azure SQL DB, you need to type in the database name yourself. Otherwise you get this error:
The reason behind this is that you cannot connect directly to the master database in Azure.
I was asked to do a review of the book Microsoft Power BI Performance Best…
This is a quick blog post, mainly so I have the code available if I…
Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…
This book was making its rounds on social media, and the concept seems interesting enough…
I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…
The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…