2024-09-09
4,125 reads
Git
Git, GitHub and Visual Studio Code for SQL Server
Learn how to get started with Git and Visual Studio Code.
2024-08-05
5,381 reads
Getting Your DBA Teams Scripts into Git
In this article, you will learn how a team can start to better manage the scripts they use for their daily work.
2024-07-01
7,570 reads
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
390 reads
GIT Configuration and Automated Release for Azure Data Factory
Learn a step-by-step method to save your ADF pipelines in Git and automatically release new changes to test and production.
2024-09-23 (first published: 2023-10-16)
2,494 reads
Stairway to Database DevOps Level 1: Setup a Local Git Repo with Azure DevOps
In this first level of the Stairway to DevOps, you will learn how to get version control set up on your local machine and connect to an Azure DevOps repository.
2023-10-16 (first published: 2023-09-13)
2,870 reads
2023-08-28
274 reads
2023-08-25
391 reads
2023-02-06 (first published: 2023-01-27)
509 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,904 reads
Blogs
Understanding Zonal Redundancy in Azure SQL MI
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
SQL Server Database Compatibility Levels
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Execution plan shows enormous number of records
The problem was reported to us by a customer. They shared a graphic execution...
T-SQL to SELECT rows where 2 columns in TBL_A do not exist in TBL_B
I have 2 tables: TBL_A and TBL_B each with the same 2 columns; ServerName...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers