There’s a lot of buzz around consolidation nowadays, as well as some fear of change. You may want to consolidate your SQL Server environments to save on maintenance and license costs, and also potentially on hardware and the size of…

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…

Over the past month, I organized #DataSessions for the Singapore SQLPASS group. Singapore SQLPASS is the data platform user group community in Singapore. In June, we held free live webinars every Tuesday and live-streamed it on Facebook and YouTube. I…

Let’s revisit our options when moving your SQL Server workloads to Azure and check out ways to migrate on each of them. Let’s break them down into sections in case you want to jump to specific ones. Deployment Options SQL…

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…

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…

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…

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…

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…

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…