Managed Service Account Naming Convention
A while back I had to help a customer update their naming standard for their Managed Service Accounts, so I thought I would share some of those details. The...
2022-01-18
110 reads
A while back I had to help a customer update their naming standard for their Managed Service Accounts, so I thought I would share some of those details. The...
2022-01-18
110 reads
In my opinion, all customers should be encrypting connections to their SQL Servers to secure data in-transit, but that’s a discussion for another day. Today, I wanted to discuss...
2022-01-04
353 reads
The 64Kb Allocation Unit size is one of the easiest SQL Server best practice items to complete during your new builds, but from time to time, I still see...
2021-12-07
722 reads
On January 15, 2021, PASS will cease to exist. https://www.pass.org/PASS-Blog/ArticleID/888/ArtMID/99177/preview/true I cannot tell you how much this disappoints me. PASS has been around for my entire database career, and...
2020-12-29
2 reads
In my last Management Studio tip, I demonstrated how you can drag and drop column names to a query window. The only part I do not like about that...
2020-07-28
12 reads
Continuing on my recent trend of Management Studio tips, here is another that could save you a few minutes. In today’s scenario, we need to write a select statement...
2020-07-07
11 reads
This article assumes you already have a basic understanding of SQL Server Audit, but if not, use this link to catch...
2018-07-17
170 reads
Every now and again as a Microsoft PFE, you get a chance to make a big difference for a customer....
2018-01-08 (first published: 2018-01-02)
2,649 reads
A while back, I posted an article about creating a WhiteList for access to SQL Server. Since then I have...
2017-05-16
4,495 reads
For the past few months, one my customers had been trying to diagnose an issue with SQL Server paging out...
2017-05-02
1,285 reads
By Chris Yates
In today’s enterprise landscape, agility and reliability go hand-in-hand. As organizations modernize legacy infrastructure...
By Steve Jones
I’m honored to be speaking at the PASS Data Community Summit in Seattle this...
By Brian Kelley
herefore, from Northwind and pubs to WideWorldImporters, I've compiled where to get those databases...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Migrate from Linux to Windows...
Comments posted to this topic are about the item We Gave Memory-Optimized Tables a...
You're responsible for managing a SQL Server environment using Always On Availability Groups across two data centers. During a recent planned failover to the secondary replica, you noticed increased application latency and errors related to read-only routing. Upon investigation, you discover that read-only routing continues pointing to the former primary, now a secondary, for a period of time after the failover.
Which of the following best explains this behavior and how to resolve it?