Using SQL Source Control projects in Azure Data Studio
David Atkinson describes how developers who were previously writing and managing SQL source code in SSMS can make a smooth transition to Azure Data Studio.
2020-07-09
source control
Custom Deployments from Source Control using SQL Compare Command line
Giorgi Abashidze explains how his team use a 2-phase deployment process with SQL Compare Command line, and some SQL Synonyms, to automate custom deployments for each of their customers, while only needing to maintain one branch per release in source control.
2020-02-05
From Source Control to Database using SQL Compare Command Line
Giorgi Abashidze explains how his team use SQL Compare Command line to automate database deployments for their customers, without having access to the real staging or production databases, merely by using our development database contained under TFS Source Control.
2019-12-06
Core Database Source Control Concepts
Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and workflow. In this article, taken from Robert Sheldon's book 'SQL Server Source Control Basics' , he takes a step back from the details to explain the whole purpose of database source control and the most important operations within source control such as versioning, branching and merging.
2017-03-21
5,188 reads
Write Cleaner T-SQL Using Version Control
If we only use version control as a way to back up our code then it is pure overhead but actually there are real benefits. We can use source control to write better, cleaner, more readable code.
2015-10-05
6,127 reads
Why Put Your Database into Source Control?
Checking program code into source control is a daily ritual for most developers, but versioning database code is less well-understood. Grant Fritchey argues that getting your databases under source control is not only vital for the stability of development and deployment, but it will make your life easier when something does go wrong.
2014-07-25
12,084 reads
Version Control as a Cloud Service
Robert Sheldon wonders if cloud-based version control still too risky for a service that must be secure, and risk-free?
2014-07-15
11,224 reads
Finding SQL Server objects that reference invalid objects
Since many environments haven't committed to using a source control system, identifying mismatched objects can offer a challenge. Tim Smith offers a solution.
2014-07-01
3,659 reads
Branching and Merging: Ten Pretty-Good Practices
After experiencing 'merge misery' personally, Konrad Lukasik came up with 10 well-tested ways of making branches and merges a stress-free part of application development.
2014-05-29
7,273 reads
Database Source Control- The Crib Sheet
As part of our long-running Cribsheet series, we asked William to come up with a brief summary of what was involved in bringing database development work under source control. What are the advantages it brings, and are there disadvantages?
2010-07-30
3,656 reads
Blogs
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
A Small LLM Fail
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
ETL Framework In Production
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...
SQL Server Ghosts
Comments posted to this topic are about the item SQL Server Ghosts