When we talk about snapshots of SQL Server there are two types, application consistent snapshots and crash consistent snapshots. Application consistent snapshots require freezing IO on a database allowing...
2023-01-26 (first published: 2023-01-25)
10 reads
EightKB is back! The biggest online SQL Server internals conference is back in 2023…happening on May 24th. We’ve open our call for speakers, you can submit here: – https://sessionize.com/eightkb-may-2023/...
2023-01-24 (first published: 2023-01-23)
12 reads
Today we have launched Data Céilí (pronounced kay-lee) Dublin 2023, Ireland’s free, community led, Microsoft Data Platform event. We tried in 2020 but certain global events prevented us from...
2023-01-16 (first published: 2023-01-09)
87 reads
SAVE THE DATE: VMUG Ireland Relaunch Event February 9th, 2023 Location: Dublin VMUG Ireland is back! We are hosting a VMUG Relaunch event in Dublin on February 9th, 2023....
2022-12-20
8 reads
I previously blogged about how to create a STONITH resource for a pacemaker cluster in VMWare virtual machines. Ok, I have a confession…you need to specify credentials when creating...
2022-12-16 (first published: 2022-12-01)
69 reads
We’ve all been there as DBAs…people requesting access to the servers that we look after to be able to view certain things. I’ve always got, well, twitchy with giving...
2022-12-07 (first published: 2022-11-23)
326 reads
A while back I wrote a post about creating a pacemaker cluster to run SQL Server availability group using the new Ubuntu images in Azure. Recently I had to...
2022-11-16 (first published: 2022-11-03)
109 reads
In a previous post I talked about an issue with storage failover when a Kubernetes node goes offline. In a nutshell, the issue is that the attachdetach-controller in Kubernetes...
2022-10-19 (first published: 2022-10-11)
119 reads
I previously wrote a post on how to convert a SQL Server Docker image to a Windows Subsystem for Linux distribution. I did this because if you tried to...
2022-10-05 (first published: 2022-09-27)
859 reads
EightkB is back! Today we announced the schedule for the next EightKB, which is happening at 1pm UTC on the 3rd of August. We have five more amazing, mind-melting...
2022-07-13
14 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
I have seen the articles on this website that talk about connecting Exchange to...
I have a two-replica SQL Server Availability Group running on Windows VMs in the...
I have a SQL agent job which starts the trace (for audit purpose) everyday...
Ask SSC