Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Does Version Control Scare You

As a part of my job, I often work with customers on how they can get database code into a version control system. That's Git for the most part today, which is the most popular system in the world. I'm comfortable using Git for many basic tasks, but I am not an expert by any means. I've used version control for years, and quite a few systems, and I like Git as a way of managing code.

I have been surprised how many people aren't comfortable with version control or Git. Many don't have the habit, but are amenable to it. What I'm amazed by in 2025 is how many people don't use it, given that so many tools we use to work with databases, and even other systems, will store items in Git. This isn't just for development code, but also for infrastructure code. Lots of data tools and servers can store data in Git and use it to deploy changes to all kinds of systems. I'd have expected more people to know Git.

As a part of my charity work, I manage the SQL Saturday site, which is stored in a public GitHub repo and all changes are submitted through pull requests to make changes to the site. A few organizers will fork the repo and submit changes to me as pull requests. I love those as I can approve those on my phone. A very few organizers can merge their own changes, as they've built up trust. I am, however, surprised at how few people are willing to do any Git work.

It seems that so many data professionals don't want to use or learn Git. I'd have thought this was a core skill for many technical people these days. At least the core ability to clone, branch, commit, and create pull requests. Squashing commits, rebasing, and more can be challenging, but often there will be someone in your organization that can help you if you need to perform those actions.

I wonder if you are intimidated by version control, or if you find yourself too busy to use it, or maybe you don't think it's valuable. I am curious what you think today.

I've written about how to use Git in ADS (don't do that anymore), but those instructions work for VS Code.  I've written a bit about how DBAs can start using Git. If you don't like the CLI, there are many thick clients, which are easy to use. Give Git a try today and see how it might help you manage and version your code, your scripts, your documentation.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
  Featured Contents
Stairway to Snowflake icon

Stairway to Snowflake Level 7 - Snowflake Tables

Mike McQuillan from SQLServerCentral

In this next level of the Stairway to Snowflake we examine the wide variety of table types that exist in the platform.

External Article

SQL STRING_AGG Function Use and Examples

Additional Articles from MSSQLTips.com

The STRING_AGG function concatenates strings separated by a specified separator. This was introduced with SQL Server 2017.

Blog Post

From the SQL Server Central Blogs - T-SQL Tuesday #186 - Agent Job History Visualization

alevyinroc from FLX SQL

I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs. In this post, we’ll be taking a look at a very handy combination of dbatools...

Blog Post

From the SQL Server Central Blogs - AI in the DBeaver Query Editor

Grant Fritchey from The Scary DBA

You know I had to do it as soon as I found it was possible. Yes, I installed and enabled AI in the DBeaver Query Editor so I can...

Microsoft Power BI Quickstart Guide cover

Microsoft Power BI Quick Start Guide: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more, 3rd Edition

Site Owners from SQLServerCentral

Bring your data to life with this accessible yet fast-paced introduction to Power BI, now in color.

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Unlimited Text

If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

The Minimal Linked Server

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?

Answer: 1

Explanation: The minimum is 1. With a SQL Server linked server, this is a valid command.

EXEC master.dbo.sp_addlinkedserver @server = N'Aristotle'

Ref: sp_addlinkedserver - https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addlinkedserver-transact-sql?view=sql-server-ver16

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2016 - Development and T-SQL
Question on SQL Query with NOT condition - I have a record, in those the three columns where firstname / last name and full name is empty. ID = 198765 FirstName = empty LastName = empty FullName = empty Flag = 0 I am trying to pull the record with ID 198765 out from select query where first and last or full name […]
SQL Server 2019 - Administration
SSPI handshake failed error code 0x80090311 - Hi, I have a workstation with SQL Express 2019 installed and I have a PC with a .NET application built in VB.NET. The App logs in as Attendance and the SQL PC logs in as Phone System. They are on the same domain and the SPNs match the server and Attendance has access to the […]
SQL Server 2019 - Development
isnull, coalesce overhead - hi, one of our sister division's erp extract view is going thru at least one mod to do the equivalent of a coalesce on a column that if null brings down our dw load job. since they were doing that i asked if they could do the same on all columns that had never be […]
is there an elegant way for agent notification to show failure if any step fails - hi our corp dw load sqlagent job goes to the next step on the 14+ erp loads if they fail.  but quits notifying of failure on any cube step at the end.  most of the loads are ssis but there is some t-sql too. without making the job really ugly, is there an elegant  way […]
is there an elegant way for agent notification to show failure if any step fails - hi our corp dw load sqlagent job goes to the next step on the 14+ erp loads if they fail.  but quits notifying of failure on any cube step at the end.  most of the loads are ssis but there is some t-sql too. without making the job really ugly, is there an elegant  way […]
Merge spans with Dates Logic - --for a given member if the startdate and endate is continous we need to keep in single record and if start date and end date is not continous i need to keep in separate record for a given member.   drop table #test create table #test (ID int, startdate datetime, enddate datetime ) insert into […]
Problem creating a Linked Server to MS Access 97 database from SQL Server 2019 - Hi there I need help on creating a Linked Server to an MS Access 97 database from a SQL Server 2019 express instance. We have a SQL Server Express 2019 instance and we are trying to create a Linked Server to an MS Access 97 database located on a network drive. Now I know that […]
continuous membership - Hi, I am trying to find everyone who had membership for a continuous year without any gaps. The sample below shows two members, one who is correct,760890291, and should be returned but the other one, 82928404, should not but it does. My code is below. What would I need to change? Thanks.   CREATE TABLE […]
SQL Azure - Administration
Azure Managed Instance Backups - Could Backup Be Completely Lost? - Some of our more regulated customers (banks, gambling sites and suchlike) like to know that we have a robust and tested recovery routine. We use Azure Managed Instance (MI) and the backup/restore process for 'normal' requirements is quite simple. But this had me thinking - is it possible for Azure to be in such a […]
DP-300 exam - Hi, I would like to know if anyone has taken the DP-300 exam recently, so that they can recommend some material for me to study. The company I work for has taken on a project and I need to get this certification as soon as possible. Thank you.
Integration Services
SSIS Automatically Coverting a NULL to a Blank Space - Hello, I was wondering if anyone knew how to prevent this issue I am experiencing. I have a SQL Source with a query that is just selecting data where fields are casted as a varchar value. When running the query in SQL Server, the values either have a valid value or are null as expected. […]
PostgreSQL
Need query help - MAX record - Hello - I have attached a Word document here with details about my issue. I have shown an excerpt from the main table in the first section.  There are 5 different records for the subscriber in question. The second section shows how the MAX command restricts the output to 2 records.  This output makes sense. […]
Need query help - MAX record - I am having trouble writing linking the MAX query that I created back to the table to produce other data elements about the MAX record.  I have created a Word document showing an excerpt from the main data table, how the MAX query pulls in the appropriate records, but then I am stumped on how […]
SQL Server 2022 - Development
CAST(VARCHAR(n)) resolved performance issue? - Hi, I would love to hear if anyone can tell me why a CAST in a query can "resolve" this performance issue. Same symptom on test server with a copy of the database. weblab_reportlog = 207 850 195 rows Requisitions = 30 143 466 rows DBCC FREEPROCCACHE SELECT [LID], [Datestamp], [logmessage], [Reporttype], [UserID] FROM [dbo].[weblab_reportlog] […]
Merge data from two different source until the data is available from both sourc - I have two sources , one coming from datalake and another is file. we need to match date to combine both dates. But , the data from source may not be avilable daily or might be delayed. So, we have data from datalake coming daily but data from file comes only from Tuesday - Saturday […]
 

 

RSS FeedTwitter

This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
[email protected]

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -