How to Set Up Microsoft Fabric Database Mirroring for Azure Cosmos DB
This article shows how to configure database mirroring from CosmosDB to Microsoft Fabric.
2024-06-10
1,255 reads
Articles
How to Sort String Date Values on a Power BI Slicer Visual
In this article, we look at how to build a slicer visual in Power BI and how to create a custom sort order for the slicer values.
2024-06-10
Identify Tables With Dropped Columns
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,500 reads
Manage Elastic jobs in Azure using Azure Elastic Jobs Manager
Microsoft Azure offers Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Learn how to configure the service in this article.
2024-06-07 (first published: 2024-05-24)
1,623 reads
Snake draft sorting in SQL Server, part 3
In part 2 of this series, I showed an example implementation of distributing a long-running workload in parallel, in order to finish faster. In reality, though, this involves more than just restoring databases. And I have significant skew to deal with: one database that is many times larger than all the rest and has a higher growth rate.
2024-06-07
Basic Always On Availability Groups in SQL Server Standard
Once Windows Server Failover Clusters have been set up, we can set up Availability Groups in SQL Server. This article will focus on setting up Basic Always-On Availability Groups in SQL Server Standard Edition.
This facilitates High Availability in SQL Server Standard, with three levels of availability and failover:
Asynchronous commit with manual or forced failover,
Synchronous commit with manual or forced failover,
Synchronous commit with automatic failover.
2024-06-05
13,408 reads
PowerBI premium capacity administration: dataset monitoring and tuning
Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its turn demands several supporting roles: there are, of course, developers, data engineers and data scientists, but there is need for one more, i.e. a capacity administrator.
2024-06-05
789 reads
WITspiration - Year 2
A new cohort of WITspiration is strating, the women in technology mentoring circle.
2024-06-05
Bridging Snowflake and Azure Data Stack: A Step-by-Step Guide
This article shows how to access Snowflake information from Synapse Analytics.
2024-06-03
1,646 reads
Who’s Changing the Table? Answers and Discussion
Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column in the Stack Overflow database.
2024-06-03
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
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,...
Forums
Foreach Loop still executes after process and delete all the folders
I have two challenges XML source control not displaying the XML file parent node...
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers