2025-12-22
9,000 reads
GitHub
Introduction to GitHub Actions Part 2: GitHub-hosted runners
In this article, you’ll learn about the many options for using a GitHub-hosted runner, including Docker.
2025-05-23
Introduction to GitHub Actions Part 1: Getting Started
This article series will teach you what you need to know to take advantage of GitHub Actions, especially for deploying database code.
2025-04-07
2024-10-21
2,001 reads
2024-09-09
4,278 reads
Git, GitHub and Visual Studio Code for SQL Server
Learn how to get started with Git and Visual Studio Code.
2024-08-05
5,938 reads
GitHub Copilot - Our Best Ally for T-SQL
This article examines how GitHub Copilot might be used when working with T-SQL Code.
2023-12-05
7,472 reads
2023-04-29
136 reads
2022-07-30
328 reads
Basic Git for DBAs: Managing PowerShell Scripts
This next article in the git series looks at managing powershell code in Git.
2022-04-11 (first published: 2020-08-27)
5,035 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