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.
The post Index Types in PostgreSQL: Learning PostgreSQL with Grant appeared first on SQLServerCentral.

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.
The post A Version Control Strategy for Branch-based Database Development appeared first on SQLServerCentral.

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.
The post A Simple Example of Flyway Development using GitHub Branching appeared first on SQLServerCentral.

In this article, you will learn how you can schedule jobs in a clustered environment that will only execute on the primary node.
The post Schedule Jobs on a Clustered SQL Server appeared first on SQLServerCentral.

Digital transformation is a buzzword that is often thrown about. But what isn’t discussed in depth, is how DevOps fits into the initiative and what the pitfalls are.
This on-demand session answers these questions and provides actionable takeaways from real-life database deployment automation projects.
You’ll also hear how the key trends in Database DevOps have influenced Flyway product development.
The post The Database DevOps Transformation appeared first on SQLServerCentral.

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.
The post Privileges and Roles in SQL Server, Oracle and PostgreSQL - Part 1 appeared first on SQLServerCentral.

An overview of the challenges of database testing and test data management, reviewing the different types of database test that need to run during development work, what sort of test data they require, and how to manage all the required data sets, during development, in a way that allows rapid cycles of parallel testing.
The post Testing Databases: What’s Required? appeared first on SQLServerCentral.

This tip walks through the steps of how to combine data from SQL Server Analysis Services SSAS 2022 with other data using Power BI Desktop.
The post Extend your Power BI Reports with Analysis Services 2022 Data appeared first on SQLServerCentral.