2016-12-05
11,865 reads
2016-12-05
11,865 reads
High availability solution with cross cluster support using the new Distributed Availability Groups
2016-11-14
3,059 reads
On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.
2016-11-07
19,451 reads
If you have Always On and need to stop running database backups to the stand by server, use the script.
2019-05-03 (first published: 2016-11-01)
270 reads
In this post, I’m going to talk an issue that I found when creating an availability group listener by using SQL Server Management Studio's Add Listener. This article helps you to resolve the issue.
2016-09-06
22,932 reads
Ahmad Yaseen takes a look at how to deal with an endpoint encryption compatibility error when using SQL Server's AlwaysOn Availability Group Wizard.
2016-06-08
2,497 reads
Enabling Transparent Data Encryption on Databases in Always On Scenario
2016-02-09
13,262 reads
An alternative read-only routing technique for non-Microsoft clients.
2015-12-28
2,633 reads
2015-07-20
3,372 reads
2014-11-04 (first published: 2014-10-06)
1,335 reads
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
I need to update greatherthan8 (category) record to Missing (status) if the same member...
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Hi everyone I am looking at the size of my db on disk (ie...
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers