At a data warehouse project I’m using a couple of Logic Apps to do some lightweight data movements. For example: reading a SharePoint list and dumping the contents into...
2022-05-25 (first published: 2022-04-20)
332 reads
This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s ... Continue reading
2022-05-25
38 reads
This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s ... Continue reading
2022-05-25
32 reads
You can find my slidedeck for the session “Introduction to Azure Data Factory” on Github:https://github.com/KoenVerbeeck/SessionMaterials All demos given in the session are explained in the ADF tutorial at MSSQLTips.com.
The...
2022-05-25
23 reads
While I think SQL is interesting, I know some people struggle with the way the language work. Someone at work posted a link to this site: https://animatesql.com/ I think...
2022-05-25 (first published: 2022-04-18)
1,609 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...
2022-05-24
23 reads
SQL Server 2022 CTP is here
It has been announced today (2022-05-24) during the MS Build event. The blog post includes a download link. Unfortunately, the Docker container is...
2022-05-24
26 reads
I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately hit bad traffic, all four lanes of I-4 blocked that resulted in a 30 minute...
2022-05-24
69 reads
This months subject for T-SQL Tuesday was Your first technical job. I have to say I really really enjoyed reading ... Continue reading
2022-05-24
8 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...
2022-05-23
39 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers