Read-Scale Availability Group Setup
What is a Read-Scale Availability Group? A Read-Scale Availability Group is a Clusterless Availability Group. It’s sole purpose and design is to scale out a read workload. More importantly...
2018-07-05
2 reads
What is a Read-Scale Availability Group? A Read-Scale Availability Group is a Clusterless Availability Group. It’s sole purpose and design is to scale out a read workload. More importantly...
2018-07-05
2 reads
What is a Read-Scale Availability Group? A Read-Scale Availability Group is a Clusterless Availability Group. It’s sole purpose and design is to scale out a […]
The post Read-Scale Availability...
2018-07-05
1 reads
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice...
2018-06-19
670 reads
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice...
2018-06-19
70 reads
Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016. The best...
2017-11-09
160 reads
Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016. The best...
2017-11-09
71 reads
In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option...
2017-06-08
675 reads
In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option...
2017-06-08
77 reads
Buffer Pool Extension was released in SQL 2014 so it’s not new. It is also not advertised very much, but...
2017-05-29 (first published: 2017-05-18)
1,395 reads
Buffer Pool Extension was released in SQL 2014 so it’s not new. It is also not advertised very much, but...
2017-05-18
107 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...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
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