liveBook · Manning

GitHub

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

GitHub is a hosted software-development platform for storing Git repositories and collaborating on code changes.

GitHub is a hosted service for storing Git repositories and collaborating on code changes. Keeping code only on a development server makes recovery dependent on that server and its backups. section 7.6.1

Avoid the mistake of treating a development server as source control:

  • Store code in a known, secure, reliable repository with version history, so introduced bugs can be rolled back. section 7.6.1
  • Use parallel development without locking files, while managing conflicts before merging a branch into the main trunk. section 7.6.1
  • In Visual Studio, create the repository, choose a local path and gitignore template, connect a GitHub account, and create a branch. section 7.6.1

MagicChoc’s lost code

MagicChoc could not recover its code after relying on a development server with backups. A GitHub repository would have provided an additional managed copy and recoverable version history. section 7.6.1

Figure 7.7 Creating and configuring a repo in GitHub

Repository configuration shows the initialization settings, GitHub account connection, repository name, description, owner, and optional license. section 7.6.1

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

How deep it goes
Demonstrates repository setup and branching but stops short of detailed conflict resolution or deployment workflows.
Examples
Uses the MagicChoc recovery failure, a SQL Server Database project, and Visual Studio’s Git Changes workflow.
What it assumes
Assumes familiarity with project files and development servers while introducing Git repositories, branches, and source-control recovery.
What you can do after
Operate/configure GitHub by creating a repository, applying a gitignore template, creating branches, and preparing changes for merging.
How it connects
Connects GitHub with Git, source control, version history, branches, merging, and Visual Studio.

Also explained in

Compare how 8 books explain GitHub →

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.