Backup of an Azure SQL DB downloaded outside of Azure
From a dev colleague: “Asking for a client... do you know how to get a backup of an Azure SQL DB downloaded outside of Azure?”
Short answer - You can’t…
Medium...
2019-03-05
33 reads
How can we merge multiple dacpacs into one
Reading Time: 4 minutes (not a minute longer)
TLDR; You probably don't want to actually merge dacpac's you probably want to deploy multiple and use /p:IncludeCompositeObjects=true.
If you do really want...
2019-03-05
12 reads
How can we merge multiple dacpacs into one
Reading Time: 4 minutes (not a minute longer)
TLDR; You probably don’t want to actually merge dacpac’s you probably want to deploy multiple and use /p:IncludeCompositeObjects=true.
If you do really want...
2019-03-05
232 reads
SSIS Catalog Dashboard
For organizations using SQL Server 2012 and newer, the SSIS catalog is the ideal tool for storing, executing, and monitoring ETL logic. The SSIS catalog includes built-in reports that...
2019-03-05
31 reads
SSIS Catalog Dashboard
For organizations using SQL Server 2012 and newer, the SSIS catalog is the ideal tool for storing, executing, and monitoring...
2019-03-05
821 reads
Using Indexing To Solve Blocking and Deadlocking Issues
A while back, I was having a conversation about a deadlocking issue and suggested that an index could perhaps help...
2019-03-20 (first published: 2019-03-05)
3,051 reads
Time Zones and Daylight Saving Time
Watch this week’s episode on YouTubeAT TIME ZONE is great because it makes it easy to perform daylight saving time and...
2019-03-19 (first published: 2019-03-05)
9,411 reads
Time Zones and Daylight Saving Time
Watch this week's video on YouTube
AT TIME ZONE is great because it makes it easy to perform daylight saving time and time zone conversions in our queries.
However, when using AT...
2019-03-05
42 reads
Time Zones and Daylight Saving Time
Watch this week's video on YouTube
AT TIME ZONE is great because it makes it easy to perform daylight saving time and time zone conversions in our queries.
However, when using AT...
2019-03-05
14 reads
Invoke-Sqlcmd is Now Available Cross-Platform in the SqlServer module
Invoke-Sqlcmd is Now Available for MacOS & Linux in the SqlServer module. The module has been posted as v21.1.18095-preview which means to download the module you’ll have to add...
2019-03-05
14 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers