Introduction According to Microsoft, DTSX is an XML-based file format that stores the instructions for the processing of a data flow from its points of origin to its points of destination, including transformations and optional processing steps between the origin and destination points. In a nutshell, when you are creating your SSIS package, the SQL […]
2021-03-25
4,580 reads
There are certain checks that need to be done after a database migration is complete. One good example of this is the check that a migration script, such as one that merges changes from a branch into main, doesn't cause 'invalid objects' (a.k.a. 'missing references') in your databases. I'll show you how to run this check, using sp_RefreshSQLModule, and incorporate it into a Flyway "after" migration script.
2021-03-25
In this article we explore additional capabilities of Azure Synapse Spark and SQL Serverless External Tables.
2021-03-25
Redgate has just published the 5th annual State of Database DevOps report, In this blogpost, Andrea Giardina explores key insights across four trends: DevOps adoption, performance & DevOps, the rise of cloud & cross-database, and the impact of the pandemic.
2021-03-24
Use these T-SQL strategies for dropping, creating, and populating tables in custom schemas across different SQL Server versions from SQL Server 2019 back to SQL Server 2005.
2021-03-24
Learn how to use Python and pandas to compare two series of geospatial data and find the matches.
2021-03-23
5,336 reads
We are experiencing some email issues with our sender. There are some spam reports for our newsletter, which are causing us issues. If you have any questions, please contact the webmaster@sqlservercentral.com.
2021-03-23
125 reads
There is more to DevOps than tools and automation. In this article, Robert Sheldon explains how to create a DevOps culture based on collaboration.
2021-03-23
In this article we look at how to do a side by side install of SQL Server Reporting Services to minimize downtime for the migration.
2021-03-23
In this article we cover some interesting facts about the SQL Server TempDB database that could be useful to know.
2021-03-22
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
I have two challenges XML source control not displaying the XML file parent node...
Thanks in advance for any clues on this. I am trying to write a...
Comments posted to this topic are about the item 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