Index Types in PostgreSQL: Learning PostgreSQL with Grant

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.

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

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 Database DevOps Transformation

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.

Extend your Power BI Reports with Analysis Services 2022 Data

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.

Testing Databases: What’s Required?

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.

Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory

Learn how to setup, configure and ingest data from Google Drive using Azure Data Factory in this step-by-step article.

Introducing the MySQL common table expression

As with many relational database management systems, MySQL provides a variety of methods for combining data in a data manipulation language (DML) statement. You can join multiple tables in a single query or add subqueries that pull data in from other tables.

Dealing with Mutually Dependent Databases in Flyway

How to create and manage 'stub' objects, in Flyway migrations, in order to overcome build failures caused by circular, or mutual, dependencies between objects in different databases. The technique should be applicable to any RDBMS.

Encrypt SQL Server Stored Procedures to Protect Source Code

In this article, we cover how to encrypt a SQL Server stored procedure and how SQL Server hides the source code for these objects once encrypted.

Configure Contained Availability Groups for High Availability in SQL Server 2022

In this article, we look at how to setup and configure Contained Availability Groups in SQL Server 2022 and some of the new options this feature allows.