Git

As explained in 100 SQL Server Mistakes and How to Avoid Them

Git is an open-source distributed version control system for tracking changes to files and coordinating software development.

Git is an open-source distributed version control system that keeps code in a known, reliable location, preserves history, and supports parallel development. Relying only on a development server and its backups can leave code unrecoverable, as MagicChoc discovered. section 7.6.1

A practical Git setup for a SQL Server Database project includes:

• Create a repository from Visual Studio’s Git Changes window, choosing its local path, license template, and gitignore template. section 7.6.1
• Connect the repository to GitHub, specifying the account, repository name, owner, and optional description. section 7.6.1
• Create a code branch, review changes there, and merge acceptable work into the main or master branch. section 7.6.1
• Expect occasional conflicts because files remain unlocked, then use version history to roll back introduced bugs. section 7.6.1

Figure 7.7 Creating and configuring a repo in GitHub

Repository creation in GitHub, including initialization settings and account configuration. section 7.6.1

How 100 SQL Server Mistakes and How to Avoid Them covers it

How deep it goes

Explains repository creation, GitHub configuration, branching, conflicts, and rollback without detailing command-line operations.

Examples

Uses the unrecoverable MagicChoc code scenario and a Visual Studio workflow for creating, configuring, branching, and committing a repository.

What it assumes

Assumes familiarity with Visual Studio and SQL Server Database projects while introducing repository, branch, trunk, and gitignore usage.

What you can do after

Operate/configure Git repositories, create branches, manage conflicts, preserve history, and roll back faulty code.

How it connects

Connects source control with GitHub, branching, version history, rollback, Visual Studio, and SQL Server Database projects.

liveBookmanning.com

Read 100 SQL Server Mistakes and How to Avoid Them on liveBook Get the book at manning.com

Also explained in

• 

  liveBookmanning.com
  Automating API DeliveryGit is a distributed version control system for tracking changes to files and coordinating collaborative software development.
• 

  liveBookmanning.com
  Road to KubernetesGit is a distributed version control system for tracking changes to files and coordinating software development.
• 

  liveBookmanning.com
  Learn PowerShell Scripting in a Month of Lunches, Second Edition: Write and organize scripts and toolsGit is a distributed version-control system for tracking and managing changes to files and coordinating work on software projects.
• 

  liveBookmanning.com
  Practical Automation with PowerShell: Effective scripting from the console to the cloudGit is a distributed version control system for tracking changes to files and coordinating work across repositories.
• 

  liveBookmanning.com
  AI for Everyday ITGit is a distributed version control system that records changes to files and supports branching and collaboration.
• 

  liveBookmanning.com
  Shipping Go: Develop, deliver, discuss, design, and go againGit is a distributed version-control system for tracking changes to files and coordinating software development.
• 

  liveBookmanning.com
  Bootstrapping Microservices, Second Edition: With Docker, Kubernetes, GitHub Actions, and TerraformGit is a distributed version control system for tracking changes to files and coordinating software development.

Compare how 8 books explain git →

Related concepts

• GitOpsused by · GitOps is an operational approach that uses version-controlled declarative configuration as the source of truth and automation to apply or reconcile system state.
• cryptographic hashuses · A cryptographic hash is a fixed-length digest computed from input data by a deterministic function designed to resist preimage, second-preimage, and collision attacks.
• versioningkind of · The practice of identifying and managing successive revisions of files, data, models, interfaces, or other artifacts so changes can be tracked and earlier states recovered.
• repositoryuses · A software repository is an organized storage location or collection of project files and related artifacts, often managed with version history and change tracking.
• GitHubused by · GitHub is a web-based platform for hosting Git repositories and supporting collaborative software development.
• .gitignoreconfigured by · .gitignore is a Git configuration file containing patterns that specify files and directories Git should exclude from version-control tracking.

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.