Who owns your availability groups?
Question: Who owns your availability groups?
The person who creates the AG becomes the owner by default. Did you know that...
2016-10-20
13,548 reads
Your search for "availability+groups" returned 100 results:
Question: Who owns your availability groups?
The person who creates the AG becomes the owner by default. Did you know that...
2016-10-20
13,548 reads
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-07 (first published: 2016-04-04)
6,226 reads
Oct 24, 2019 ... Finding the Primary Replica of an Availability Group · #set $ServerName to any node that's part of the AG that you're interested in · $ ...
The TL;DR - beware of Failover Cluster Manager trying to steal your non-shared storage!
--At a client recently two availability groups on...
2015-04-02
12,317 reads
Few days ago I was surfing on Twitter when dbatools asked about how it’s PowerShell module changed the way people work. We're looking to highlight how dbatools has changed...
2020-06-03 (first published: 2020-05-20)
1,012 reads
In my opinion one of the key features of SQL Server 2016 is the rebuilt and optimized log redo mechanism...
2016-03-16 (first published: 2016-03-10)
1,724 reads
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,865 reads
Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention...
2016-01-29
800 reads
In previous posts here and here we discussed AlwaysOn Availability Group replication latency and monitoring concepts, specifically the importance of monitoring the send_queue and redo_queue. In this post I’m going to...
2015-06-17
3 reads
SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It...
2018-01-22 (first published: 2018-01-13)
50,297 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Thesis help services offer expert guidance and topic selection to final submission. They provide...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers