Microsoft recently came out with a blog on a bunch of new features available for Azure Synapse Analytics (see Azure Synapse Analytics November 2021 Update), and I wanted to...
2021-12-20 (first published: 2021-12-09)
197 reads
I recently worked on a project where we needed to copy some large files from a specified library in SharePoint Online. In that library, there were several layers of...
2021-12-20 (first published: 2021-12-07)
283 reads
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...
2021-12-20
9 reads
This is our current setup shown below. There is not much to failing over with Managed Instances, from experience it is similar to that of Azure SQL Database. Let’s...
2021-12-17 (first published: 2021-12-07)
263 reads
Yesterday, I had about 30 existing queries (and some multi-query processes) that I needed to turn into individual stored procedures. […]
The post SQL Server meta-development (with regular expressions and...
2021-12-17 (first published: 2021-10-13)
439 reads
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...
2021-12-16
12 reads
Our holiday gift to the Microsoft Data Platform Continuity Virtual Group is to have a massive panel of industry-leading experts answer YOUR questions with no strings attached! Bring your...
2021-12-16
30 reads
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...
2021-12-15
10 reads
This week’s blog post will help you check your SQL Servers up-time. There are numerous reasons I can think of that you would want to know how long your...
2021-12-15 (first published: 2021-12-07)
544 reads
There is a setting / feature in Managed Instance worth talking about, it is called SQL Trust Groups. What is this? At a basic level it’s a way to...
2021-12-15
94 reads
By Steve Jones
One of the cool things I’ve seen with the new Flyway CLI is that...
By Steve Jones
querinous – adj. longing for a sense of certainty in a relationship; wishing there...
My PC has been causing me problems for months. I've told my desktop support...
I have a measure with totals for specific dates with the LastNonEmpty aggregation, and...
I moved a table from MsSql to Postgresql that had a field defined as...
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers