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
7 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
7 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
10 reads
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice...
2018-06-19
701 reads
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice...
2018-06-19
80 reads
Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016. The best...
2017-11-09
167 reads
Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016. The best...
2017-11-09
80 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
680 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
82 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,419 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
186 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers