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,109 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
Azure Workbooks
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
SQL Prompt Tips–Using $surroundtext$ in a Snippet
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
SQL Server Quickie #46 – SQL Server on Linux
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
Forums
The World of Data Science
Comments posted to this topic are about the item The World of Data Science
PowerQuery in SSIS... is it only in 2023?
First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source,...
Slicing status based on conditions
Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points...
Ask SSC