SQL – Managing Jobs in Availability Groups

This blog post will show how to dynamically add logic at the beginning of jobs in Availability Groups in order to avoid job execution errors in the replica or replicas. Problem In SQL Availability Groups the SQL jobs have to…

Read More >

Managing SQL Jobs in Availability Groups – Method Job Category

Method – Job Category This blog post will show how to setup SQL Jobs in multiple availability groups. This method will allow you to dynamically detect the role of the SQL Server replica and avoid job execution errors in the…

Read More >

Upgrade SQL Server Reporting Services to 2017

In the past, we could run the SQL installer to do an in-place upgrade of SQL server including the SSRS instance to a newer version. As of 2017, SSRS is a separate install from SQL server, so this is no…

Read More >

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 >

Top 10 New Features of SQL Server 2019

It is no secret to anyone that software release cycles are more aggressive than ever. Now that the cloud has become ubiquitous as a strategic component of IT services, we are spoiled by a constant release of new features and…

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 >

Five ways to migrate your on-premises SQL database to Azure

There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in elastic pool is essentially just Azure SQL Databases grouped into an…

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 >
Page 1 of 2212345...10...Last Page »