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.

Coding Magic Values

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

Fear of "What If"

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

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

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 […]