Facebook, Instagram and WhatsApp just had a really bad Monday
It’s the end of the work day here on the east coast and I see that the Facebook is still unavailable. Facebook acknowledged the problem in the following two...
2021-10-04
39 reads
AWS BYOC – Bring your own SQL Server cluster with AWS EC2 and SIOS
Originally posted on DataSteve: Introduction They are multiple options to implement HADR solution for SQL Server in AWS public cloud. The easiest way to do that is to use...
2021-09-10 (first published: 2021-08-25)
135 reads
Clustering SAP #ASCS and #ERS on #AWS using Windows Server Failover Clustering
When ensuring high availability for SAP ASCS and ERS running on WIndows Server, the primary cluster solution you will want to use is Windows Server Failover Clustering. However, when...
2021-07-27
29 reads
How to create a DataKeeper Replicated Volume that has Multiple Targets via CLI
I often help people automate the configuration of their infrastructure so they can build 3-node clusters that span Availability Zones and Regions. The CLI for creating a DataKeeper Job...
2021-06-16 (first published: 2021-06-01)
152 reads
How to extend your existing SQL Server Failover Cluster Instance to the Cloud for Disaster Recovery
I get asked this question all the time, so I figured it was time to write a blog post, record a video and write some code to automate the...
2021-06-09 (first published: 2021-05-22)
222 reads
Changing a Drive Letter with PowerShell
Here is a short but sweet post on how to change the drive letter of a partition. Despite using my best Google skills I couldn’t find an example that...
2021-06-07 (first published: 2021-05-21)
238 reads
Using Amazon FSx for SQL Server Failover Cluster Instances – What You Need to Know!
Intro If you are considering deploying your own Microsoft SQL Server instances in AWS EC2 you have some decisions to make regarding the resiliency of the solution. Sure, AWS...
2021-01-14 (first published: 2021-01-08)
274 reads
Calculating Application Availability in the Cloud
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)
196 reads
Step-by-Step: iSCSI Target Server Cluster in Azure
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)
205 reads
Achieving application consistent recovery points of SQL Server 2008 R2 with Azure Site Recovery in Azure
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
112 reads
Blogs
Power BI Meets Programmability – TOM, XMLA, and C#
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
Do Full Backups Break Log Shipping?
By Kevin3NF
TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...
Daily Coping 15 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SSRS Zero-Day patching?
Hello all, I've been tasked (rather randomly) with finding out if there is somewhere...
Informatica -SQL Error
We get a sql connection from host informatica server and the query runs in...
Last Successful Completion Date for SQL Job
I am trying to write a query to get a list of all SQL...
Ask SSC