This article demonstrates how to use a 'state' approach to database source control, when the nature of the database changes cause you to hit difficulties with migrating existing data. These difficulties happen when the differences are such that it is impossible for any automated script to make the changes whilst preserving existing data.
2019-10-10
In this Simple Talk editorial Kendra Little discusses how SSMS is as relevant as ever.
2019-10-10
Learn how to quickly deploy a new SQL Server instance on Azure using Azure Container Instances ACI.
2019-10-09
The latest version of SQL Compare now offers a Command Line Interface on Linux for the first time. Now teams can benefit from the industry standard tool for comparing and deploying SQL Server databases, whether they choose to work on Windows, Linux, or both.
2019-10-09
Azure SQL Database, unlike its on-premises counterparts, restricted its integration capabilities to those implemented directly by the database engine. To remediate this shortcoming, Microsoft provided equivalent functionality by relying on integration runtime of Azure Data Factory. In this article, you get an overview of this Azure-based SSIS offering.
2019-10-08
Phil Factor shows how to integrate use of SQL Change Automation, SSMS registered servers, SMO, and BCP to automatically build or update a database on all servers in a group.
2019-10-08
Phil Factor describes the freedom of being able to "self-serve" databases, during testing and development, and explains how it works with SQL Clone.
2019-10-07
Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that takes parameters.
2019-10-07
Phil Factor demonstrates how to tackle builds when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems caused by 'missing references' when building the individual objects.
2019-10-04
In this article we look at how to run SQL Server queries with Entity Framework Core using the DbSet.FromSql method, parameterized queries, stored procedures and using the Database.ExecuteSqlCommand property.
2019-10-04
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
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...
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