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.

Schedule Jobs on a Clustered SQL Server

In this article, you will learn how you can schedule jobs in a clustered environment that will only execute on the primary node.

The Complexity of Metrics

We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.

The Rise of Vector Databases

Steve has a few thoughts on a new type of database: a vector database.

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.

Nullable vs Non-Nullable Columns and Adding Not Null Without Downtime in PostgreSQL

In this article, we are going to talk about nullable and non-nullable columns specifically related to Postgres databases. While the reasons to use nullable or non-nullable columns may seem obvious at first, there are pitfalls associated with each decision that either affect development velocity, affect application performance, or cause downtime. Let's start with definitions. Nullable […]

The Senior Advantage

Being more senior in a role can be an advantage if you work at using your extra knowledge.

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.

The Data Fabric – Future of Data Management

This article provides an overview of Data Fabric and its components.