Resolving an Availability Group Sync Issue – HADR_AR_CRITICAL_SECTION_ENTRY

We recently ran into an interesting issue on a three-node SQL Server Availability Group (AG) cluster. There was a cluster failure that impacted the availability group for a few minutes during which the replicas changed to resolving state. Once the…

Read More >

How to Fix: The Selected Subscriber does not satisfy the minimum version compatibility

Problem: You are trying to add a new subscriber to a SQL Server Publication using the SQL Server Management Studio and you receive an error similar to the one below: “The selected Subscriber does not satisfy the minimum version compatibility…

Read More >

A look at new features Azure SQL Database Serverless and Hyperscale

Last May, the Microsoft Build 2019 conference took place in Seattle. A number of new features and capabilities were announced and demonstrated. This week, communities in the Asia Pacific held their own version of Build, bringing the best and the…

Read More >

Fix: SQL Server to PostgreSQL Linked Server Error – “Requested conversion is not supported.”

Problem: You created a linked server on SQL Server to a PostgreSQL database. You can open and navigate the linked server on SSMS up to listing the tables, but can not perform select to certain tables, returning the below errors:…

Read More >

How to fix SQL backup to URL error: The remote server returned an error: (400) bad request

Problem: You are trying to take a native SQL Backup to URL and you receive the error below: Msg 3271, Level 16, State 1, Line 1 A nonrecoverable I/O error occurred on file “https://MyStorageAccount.file.core.windows.net/MyContainer/Adventureworks_full_20190420.bak:” Backup to URL received an exception…

Read More >

How to fix SQL backup to URL failure – operating system error 50

Problem: You run an SQL backup to URL and get the following error: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device ‘https://<mystorageaccountname>.blob.core.windows.net/<mycontainername>/AdventureWorks_full_20190420.bak’. Operating system error 50(The request is not supported.). Msg 3013, Level 16, State 1,…

Read More >

How to fix SSIS deployment error “please create a master key”

Problem: You are deploying a SQL Server Integration Services Package to the SSIS Catalog and keeps on failing with the following error: The error is succinct and direct to the point: “Please create a master key in the database or…

Read More >

How to restore SSISDB to another server and migrate the SSIS catalog

It is easy to get this one wrong. SSISDB is just a database, after all, and I’ve seen a number of instances where it was restored to another server and a number of errors/issues crop up. After all, SSISDB is…

Read More >

How to solve an SSIS Deployment Error

Problem: You are deploying a SQL Server Integration Services Package to the SSIS Catalog and it keeps on failing with the following error: The error seems daunting but the main information to take away is: The server may be running…

Read More >

Microsoft Ignite 2018 special cloudscape podcast

This episode of the Cloudscape podcast is dedicated to the announcements that were made at the recent Microsoft Ignite 2018 conference. We are joined solely by Warner Chaves to walk us through the most important and exciting announcements from the…

Read More >
Page 2 of 2212345...10...Last Page »