Does Version Control Scare You
Steve finds a lot of people don't use version control and don't want to learn how to use it.
2025-05-21
176 reads
Version Control Systems (VCS)
This is Why You Use Git for Scripts
Git is a good tool for DBAs and other Operations staff. Today Steve gives you a few reasons why.
2024-02-14
442 reads
Source Control with GIT, Power BI and Microsoft Fabric
Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present some challenges related to source control. But it’s finally providing us with a solution to these challenges. Let’s analyse this piece-by-piece.
2023-12-18
Stairway to Database DevOps Level 2: Manage Code with Red Gate SQL Source Control
In this second level of the Stairway to Database DevOps, we learn to use Redgate's SQL Source Control to save and updates changes to objects, as well as tracking data in certain tables.
2023-10-18
1,368 reads
2023-08-28
287 reads
2023-08-25
395 reads
Your First Repo in Azure Data Studio or VS Code
Learn how to get started with Git and avoid the command line by using VS Code or Azure Data Studio.
2022-05-11
4,941 reads
Azure Data Studio and Version Control
This article examines how you can use Azure Data Studio with your git Version Control System.
2022-04-29
8,565 reads
2021-03-26
398 reads
2021-03-19
433 reads
Blogs
Deploying an Updated Model with SQL Compare 16
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
Forums
Adding and Dropping Columns II
Comments posted to this topic are about the item Adding and Dropping Columns II
Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform
Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...
More Documentation is Needed
Comments posted to this topic are about the item More Documentation is Needed
Question of the Day
Adding and Dropping Columns II
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) , [Country2] [char] (3), [stateprovince2] [char] (2), [Country] [char] (3), [stateprovince] [char] ) ON [PRIMARY] GOI decide to drop the stateprovince2 and country2 columns. What code should I use? See possible answers
