Where Is My Primary Replica Again?
We have many clients with multi-node Availability Groups - that is, AGs with more than two replicas. One of the problems...
2016-05-03 (first published: 2016-04-22)
4,168 reads
Your search for "availability+groups" returned 100 results:
We have many clients with multi-node Availability Groups - that is, AGs with more than two replicas. One of the problems...
2016-05-03 (first published: 2016-04-22)
4,168 reads
Post Updated: Replaced Query 3 with transactions/sec query.
When we first published 7 ways to Query Always On Availability Groups using...
2019-02-19
183 reads
SQL Server Availability Group Auto Seeding is a wonderful thing, it saves database administrators time when setting up availability groups. ...
2018-07-30
444 reads
Oct 5, 2021 ... I was adding databases to an availability group (SQL Server 2017 CU20 instance) the other day and one database failed to automatically seed ...
During the keynote for TechEd North America 2013, Microsoft announced the planned release of SQL Server 2014. As part of...
2013-06-12 (first published: 2013-06-10)
3,585 reads
Apr 29, 2019 ... If it's the later, when you failover they'll, at best be hitting a read-only copy of the database or, if the what was primary is now set to a ...
Its pretty often that you have to sit down at a SQL Server and need sort out what the backup...
2015-06-10
1,202 reads
This problem was first flagged by a daily operational validation test I wrote using everything in my recent webinar to...
2017-03-15
202 reads
Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking about SQL Server Availability Groups.
2023-04-05 (first published: 2023-03-21)
221 reads
3. Install SQL Instance
a) Configure the firewall setting on both 2 nodes.
echo Default Instance
netsh advfirewall firewall add rule name="SQLServer"...
2013-06-25
2,059 reads
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
hi we run 2019 std. we saw this week that someone hid 3 important...
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