When deploying business critical applications in the cloud you want to make sure they are highly available. The good news is that if you plan properly, you can achieve...
2020-08-05 (first published: 2020-07-24)
160 reads
I recently helped someone build an iSCSI target server cluster in Azure and realized that I never wrote a step-by-step guide for that particular configuration. So to remedy that,...
2020-06-03 (first published: 2020-05-20)
191 reads
If you want to use ASR to replicate SQL Server 2008 R2 standalone or clustered instances, you will need to update the SQL Writer to 2012 or later. You...
2019-06-18
87 reads
Google first reported an “Issue” on Jun 2, 2019 at 12:25 PDT. As is now common in any type of disaster, reports of this outage first appeared on social...
2019-06-03
18 reads
I just noticed today that there is a new blade in the Azure portal when creating a new SQL Server virtual machine. I’ve been looking for an announcement regarding...
2019-06-11 (first published: 2019-05-24)
441 reads
If you are like me and were unable to get away from the office to attend Microsoft Build 2019 you will be glad to know that Microsoft has published...
2019-05-10
49 reads
If you are deploying SQL Server in Azure, or any Cloud platform for that matter, instead of just provisioning storage like you did for your on-premises deployments for many...
2019-05-14 (first published: 2019-05-02)
508 reads
Intro On July 9, 2019, support for SQL Server 2008 and 2008 R2 will end. That means the end of regular security updates. However, if you move those SQL...
2019-05-02 (first published: 2019-04-19)
715 reads
Introduction
The topic of mixing SQL Server Failover Cluster Instances (FCI) with Always On Availability Groups (AG) is pretty well documented....
2019-03-13
1,339 reads
If you have been following my blog, you probably know that I write a lot of step-by-step guides for building...
2019-02-15
468 reads
By gbargsley
Have you ever been asked to make a schema only copy of a database?...
Based on Microsoft Documentation <The Resource database is a read-only database that contains all...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hello All, I have a string something like below("inputstring" column) and i want to...
Hello experts, I keep seeing this error alert sent from SCOM about some of...
Hello, DBA Gurus, so we have a prod SQL Server VM instance. I noticed...
Ask SSC