2024-06-21
456 reads
always on
MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases
This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
7,796 reads
Configuring Availability Groups in Ubuntu
In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQL Server on Ubuntu 16.04 Install Pacemaker agents and configure the cluster Create Always On Availability Groups Create […]
2020-08-25
3,591 reads
Deployment of SQL Server 2019 Always On Availability Groups on Azure AKS
Step through a demonstration illustrating a sample deployment of SQL Server 2019 Always On Availability Group cluster on Azure AKS. You'll discover how to leverage the Microsoft Azure-hosted managed Kubernetes service referred to as AKS.
2019-09-10
SQL Server AlwaysOn Availability Groups Monitoring and Alerting - Part 2
In this tip we look at some additional scripts that you can use to monitor your SQL Server AlwaysOn Availability Groups.
2018-12-18
2,855 reads
Configuring SQL Server Always on Azure Servers(Iaas)
Configuration of SQL Server Always on in Azure Virtual machines differs in multiple ways comparing with the on-premise Implementations. This article will help you to have a handy note to configure always on in Azure servers from a DBA perspective.
2020-09-04 (first published: 2018-12-06)
14,482 reads
2018-11-13
701 reads
Automatically Failover (Enable or Disable) Jobs Based on HADR Role
If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.
2018-11-14 (first published: 2018-11-12)
5,901 reads
Always On - Endpoint Ownership
Whoever creates an AlwaysOn group is, by default, the owner of the endpoint. This is generally not a problem…unless that person leaves the company and you need to delete the login.
2018-10-25
15,559 reads
Configure Read Only Routing
The advantage of Setting the readable secondary as Read-Intent Only will allow the secondary server to serve the read-only workload only if the connection string of the application contains Application Intent=Readonly parameter.
2018-02-05
17,397 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers