Daily Coping 19 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-19
4 reads
Blog Posts
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but still cost me hours and a ... Continue reading
2022-05-19
11 reads
Daily Coping 18 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-18
10 reads
Metadata-driven pipelines in Azure Data Factory | Part 2
(2022-May-08) If you happened to read the Part 1 of this blog series, the main message of it was the Azure Data Factory Copy activity was not just a simple...
2022-05-18 (first published: 2022-05-09)
196 reads
Updated Pluralsight Course – Maintaining, Monitoring and Troubleshooting Kubernetes
My updated course “Maintaining, Monitoring and Troubleshooting Kubernetes” is now available on Pluralsight here! If you want to learn about the course, check out the trailer here, or if...
2022-05-18 (first published: 2022-05-09)
86 reads
VMware & SQL Server 823-824 alerts
We’ve been tracking a weird state with SQL Server virtual machines on VMware and possible warnings on database corruption while VM backups are running, largely centered around (but not...
2022-05-18
15 reads
Daily Coping 17 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-17
4 reads
Getting a list of the articles in a publication.
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
11 reads
Storage Field Day 23 – SIOS
I am thrilled to have been a part of this year’s Storage Field Day 23 event, held by Gestalt IT during the first week of March. This event is...
2022-05-17
9 reads
Azure Synapse Explained
In this article we would like to give you a high level summary on Azure Synapse.
What it is, what are its strengths and weaknesses observed through our project implementations...
2022-05-16 (first published: 2022-05-13)
32 reads
Blogs
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but...
VMware & SQL Server 823-824 alerts
By kleegeek
We’ve been tracking a weird state with SQL Server virtual machines on VMware and...
Forums
SQL Duplicate remove Query
Hi Guys, I want to remove duplicates from the table. The duplicate is a...
Always On Primary Node needs to be rebooted
I have 2 node AAG setup. Currently listener is on Primary Node1. I have...
Create Alert for Number of connection
I have 2 columns , Count and Datetime I need to send alert for...
Ask SSC