PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant

The focus of your backup strategy should not be backups. Instead, you should be focused on restoring databases, because, after...

07 September 2024 12 min read

Phil Factor in General

Storing and Retrieving the Initialization and Configuration Data for Applications

All developers hit the problem of how and where to store and set their configuration, profile, or initial data. A...

05 September 2024 14 min read

Dennes Torres

Microsoft Fabric and PySpark: Coding tricks to improve your solutions

PySpark has some unconventional syntaxes which provide power to the development process, making it easier. We talked about loops before. Let’s...

04 September 2024 4 min read

Louis Davidson in Blogs

Why don’t you work like this?

No matter how much I love social media, there are some annoying patterns that work better than most sincere ones....

04 September 2024 5 min read

Lee Asher in PostgreSQL

Solving the Overlap Query Problem in PostgreSQL

Range queries are a very common task in SQL: selecting dates, numbers, or even text values that fall within some...

03 September 2024 10 min read

Ben Johnston in Blogs

Choosing Data Types and Column Options

An entire post on choosing the correct data types either seems like overkill or much needed and overdue. The perspective...

31 August 2024 27 min read

Lukas Vileikis in MySQL

MySQL Index Overviews: Composite B-Tree Indexes

Indexes in MySQL are one of the primary ways to enhance query performance and they are especially useful when the...

30 August 2024 16 min read

A person standing next to a cloud computing server Description automatically generated

Dennes Torres in Blogs

The Big IT Outage: Where are we going?

As you all know about, just a few weeks ago we had the big CrowdStrike global IT outage. Some lucky...

28 August 2024 5 min read

Joe Celko in Theory and design

Bad Data and Dirty Databases

Many years ago, my wife and I wrote an article for Datamation, a major trade publication at the time, under...

28 August 2024 10 min read

Chisom Kanu in Development

EsProc SPL and SQL: Complementary, But Different, Technologies

Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your every desire? Have...

26 August 2024 23 min read

Louis Davidson in Editorials

Time to opine in this year’s Redgate’s State of the Database Landscape Survey

Every year, Redgate puts out a survey to technology workers around the globe asking a set of straightforward, non-invasive questions...

23 August 2024 2 min read

Edward Pollack in T-SQL Programming

Effective Strategies for Storing and Parsing JSON in SQL Server

Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or semi-structured data. Because...

23 August 2024 26 min read

Robert Sheldon in NoSQL

Introducing Schema Validation in MongoDB

Similar to other NoSQL database systems, MongoDB is known for its flexible and variable schema models, unlike relational database systems...

21 August 2024 21 min read

Ben Johnston in Blogs

Auditing SQL Server – Part 4 – Database Configuration Audit

This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and...

20 August 2024 15 min read

Joe Celko in Theory and design

LIKE Constraints

In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of...

19 August 2024 10 min read

Lee Asher in PostgreSQL

PostgreSQL Partitioning: The Most Useful Feature You May Never Have Used

Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often thought of only...

16 August 2024 10 min read

Farooq Aziz in Snowflake

Change Data Capture Pipeline Automation in Snowflake

This article offers technical guidance on automating updates and tracking changes of data examples using Snowflake’s CDC capabilities. The examples...

15 August 2024 12 min read

Louis Davidson in Editorials

PASS Summit Scholarships? Awesome!

This year, PASS is introducing scholarships to support individuals who might not typically have the opportunity to attend the PASS...

15 August 2024 3 min read