SQL Server Distributed Availability Group with Forwarder in Microsoft Azure

mysql queries

Architecture diagram Register the application with the name terraform. Leave all options as default. Add a secret that will be used as a password to authenticate terraform. Provide a description and expiry period for the secret. Copy the Secret ID…

Read More >

User “Guest” Does Not Have Permission to Run DBCC CHECKIDENT For Object

DBCC CHECKIDENT Example DBCC CHECKIDENT is used to check or change the value of an identity column in the specified table. To run this command, the login needs at least one of the following: own the schema that contains the…

Read More >

Top 10 New Features of SQL Server 2019

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from the past. We originally published today’s post on October 29, 2019. It’s no secret to anyone that software release…

Read More >

Save Costs by Consolidating SQL Server On-Prem or in the Cloud

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…

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 >

SQL Encryption 101

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…

Read More >

Migrating SQL Server On-Premise to Azure SQL

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…

Read More >

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