2020-10-22
9,368 reads
Availability Group (AG)
2020-10-15
452 reads
2020-09-21 (first published: 2020-08-25)
2,607 reads
Adding a Database with Polybase External Tables to Always On Availability Group
Learn how to ensure your PolyBase objects are accessible from all nodes in an Availability Group.
2020-05-26
3,810 reads
Have You Deployed an Availability Group?
Learning about the Availability Group technology can be valuable for your career. Today Steve asks if you've deployed one, and if not, perhaps you want to try.
2024-03-11 (first published: 2020-04-03)
370 reads
A Step by Step Guide to the Availability Group (AG) Listener
Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]
2019-07-02
138,504 reads
The Curious Case of… very long failover times with a large ad hoc workload
In this case, the cause of the long failover time was enabling Query Store after upgrading, for a database with a large workload of ad hoc queries, meaning there was 100GB of Query Store data to load.
2019-05-31
2018-11-15
713 reads
2018-07-16
718 reads
2018-06-11
784 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers