Daily Coping 10 Jun 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-06-10
29 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-06-10 (first published: 2022-05-19)
604 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-06-10 (first published: 2022-05-18)
526 reads
Azure VM Scale Sets
I really like scale sets. It lets you create and manage up to 1000 load balanced VMs per availability zone using windows or Linux images. (We can have flexible...
2022-06-09
47 reads
Daily Coping 9 Jun 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-06-09
26 reads
Beer, Brats, and Databases at DataGrillen 2022
Last week I attended DataGrillen 2022 in Lingen, Germany. This was my first time at this event, and I had a wonderful time. This despite the fact that I...
2022-06-08
44 reads
Daily Coping 8 Jun 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-06-08
12 reads
Installing the mssql-cli on Ubuntu 22.04
I really like the mssql-cli tool. I use it pretty much everyday however it seems like it’s not being maintained anymore and as such, there are issues when trying...
2022-06-08 (first published: 2022-05-13)
510 reads
Power BI connectors to Azure Synapse
When using Power BI and pulling data from Azure Synapse, you will use the “Get Data” feature in Power BI. There are now three connections that you can use...
2022-06-08 (first published: 2022-05-13)
262 reads
Daily Coping 7 Jun 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-06-07
15 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers