Your search for "availability+groups" returned 100 results:
Hi SQL Experts, We have SQL 2014 Enterprise Edition instance in our environment and Alwayson availability groups configured. Assume Server-1 and Server-2 are the two AG replicas. In our environment (dev reporting enviornment), we have sql agent jobs configured only on "Server-1" and no jobs present on "Server-2". Just incase if any reason(patching,unexpected sql shutdown, […]
2016-09-26
572 reads
I have a 2 node AlwaysOn Availability group I want to create. One node will be in one data center and the other node will be in a second data center. If the connection to the primary data center is severed, then the primary server would be unable to communicate to the secondary to tell […]
2018-06-12
1,550 reads
Hi Experts, I've encountered a login timeout issue when running a BCP command on a SQL 2014 "AOAG" multisubnets environment.This issue was initially encountered with all the connections to the Database, as some of the connections attempts succeeded and some failed due to timeouts. The Application connections issue was resolved by adding the MultiSubnetFailover parameter to the […]
2018-06-19
1,923 reads
Feb 9, 2017 ... Synchronous Always On Availability Groups Is Not Zero Data Loss ... In theory, when you configure AlwaysOn Availability Groups with synchronous ...
Jan 14, 2013 ... Configure all AG Replicas as Publishers. Each of those replicas that are participating in an AG and will have a published database needs to be ...
Hello everyone, I am playing with Availability Groups for the first time (a bit late to the party) and there is something I don't understand about connections during a Failover. I currently have a 2 nodes AG (SQL 2017 CU15) in Synchronous commit mode but without readable secondary (licensing reason). I have 2 very basic […]
2019-12-05
450 reads
Mar 3, 2023 ... To start the Always On dashboard · In Object Explorer, connect to the instance of SQL Server on which you want to run the Always On Dashboard.
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.
The transport...
2016-01-28
1,866 reads
I'm trying to set up an SQL 2012 Availability Group between 'ServerA' and 'ServerB' On the source server (ServerA) I get the following message in the 'AlwaysOn High Availability' tab in SQL Server Configuration Manager: 'An error occurred while loading the AlwaysOn High Availability properties [return code: 0x80070005]. This server is running Windows Server 2008 […]
2013-03-07
1,711 reads
My company is considering a new database server, and I'm exploring if it's possible to use Standard edition instead of Enterprise. We'd like to have automatic failover, and the Basic Availability Group looks good for that. It has the limitation of one db per group. I'm fine with that, I can script the creation of […]
2017-11-02
32 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
I have had a hard time to understand how to use EXISTS. I Always...
Dears, We are using Azure Data factory pipes to run some stored procedures against...
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers