The migration to a different VCS should not be underestimated, as there is a lot more involved than just switching tools, and that’s what Tonie Huizer covers in this article.
First, the team needed to migrate the monolithic repos over to Git, second the team needed to make sure we had a branching strategy and workflow in place.
It involved a big process change for the team as well, but this switch is mandatory to make full use of branch-based database development.

Coaching the Digital Transformation

by Steve Jones

SQLServerCentral

Helping your business get value from a digital transformation can start within your own team or group.

A Simple Example of Flyway Development using GitHub Branching

by Additional Articles

Redgate

Vendors/3rd-party Products

This article demonstrates one way to do branch-based database development with Flyway, using GitHub to manage the branches and Flyway configuration files to allow Flyway to switch smoothly between databases, when we move between branches in GitHub.

Index Types in PostgreSQL: Learning PostgreSQL with Grant

by Additional Articles

SimpleTalk

Uncategorized

In this article I’m going to go over the different types of indexes and some index behaviors. We’ll get into what the indexes are, how they work, and how best you can apply them within your databases. I’m hoping you’ll develop an understanding of which indexes are likely to work better in each situation.

Coding Magic Values

by Steve Jones

SQLServerCentral

Steve notes that developers should not be hard-coding values.

Fear of "What If"

by drsql@hotmail.com

SQLServerCentral

Career Growth

Fear and aging. Two of the things that most human beings have in common is that we are scared and getting older. Most of us we fear getting older, but that is a very different conversation altogether. I want to talk about the fear of what if. Today I have two things I am keenly […]

Outsourcing Operations

by Steve Jones

SQLServerCentral

When I first started working in technology in the 90s, it was a time of outsourcing lots of work overseas. Many large companies followed the wave of manufacturing in the 70s and 80s by many companies, including lots of semi-conductor manufacturers. I watched as a number of jobs moved overseas, though fortunately not mine. In […]

Privileges and Roles in SQL Server, Oracle and PostgreSQL - Part 1

by Additional Articles

MSSQLTips.com

Uncategorized

This tip will review the different ways of granting privileges in SQL Server, Oracle, and PostgreSQL, the differences in the concepts of roles, schemas, and owners, and the way to grant permissions on the whole schema.