liveBook · Manning

Repository

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

A repository is a version-controlled storage area containing a project's files and their revision history.

A repository is a version-controlled storage area for project code and its revision history. It provides a secure, reliable copy instead of treating a development server as the only backup. section 7.6.1

Avoid the mistake of leaving code only on a development server:

  • Create a Git repository for the SQL Server Database project through Visual Studio’s Git Changes window. section 7.6.1
  • Configure its local path, optional license, gitignore template, GitHub account, name, description, and owner. section 7.6.1
  • Create a code branch, review changes there, and merge approved work into the main or master branch. section 7.6.1
  • Use version history to investigate bugs and roll back damaging changes; expect conflicts because files remain unlocked. section 7.6.1
Figure 7.7 Creating and configuring a repo in GitHub

Use the repository configuration view to identify initialization settings, GitHub ownership, and tracking exclusions. section 7.6.1

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

How deep it goes
Explains repository setup, configuration, branching, conflicts, history, and rollback without detailing Git internals.
Examples
Uses MagicChoc’s unrecoverable development-server code and a Visual Studio SQL Server Database project.
What it assumes
Assumes a project managed in Visual Studio and introduces repository setup through Git and GitHub.
What you can do after
Operate/configure a GitHub repository, create branches, manage conflicts, review changes, and roll back buggy code.
How it connects
Connects Git, GitHub, source control, version history, branching, merging, and backups.

Also explained in

Compare how 10 books explain repository →

Related concepts

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.