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)
618 reads
Blog Posts
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)
540 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
54 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
38 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
55 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
23 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)
521 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)
276 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
27 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-06-06 (first published: 2022-05-13)
496 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers