Fabriano Richard in BI

Microsoft Fabric, the Land of Wizards and Trolls

In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how it came about...

03 July 2024 9 min read

Boris Novikov in PostgreSQL

PostgreSQL Temporal Tables: Querying Historical Data with Time Dimensions

Store and query historical data in PostgreSQL using temporal tables. Covers valid time, transaction time, and bi-temporal models with SQL...

28 June 2024 17 min read

Robert Sheldon in MongoDB

Deleting Documents from a MongoDB Collection

So far in this series, we’ve looked at different ways that you can add, retrieve, and update documents in a...

24 June 2024 15 min read

Edward Pollack in T-SQL Programming

XML Performance Tuning and Added Options

SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes less space, all...

21 June 2024 12 min read

Koen Verbeeck in BI

Choosing Between the Lakehouse and Warehouse in Microsoft Fabric

Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services of the existing...

10 June 2024 20 min read

Phil Factor in Theory and design

Concepts and Issues in Test Data Generation

Data generation is the science and art of providing data for database development work that is as realistic and controllable...

10 June 2024 11 min read

Ben Johnston in SQL Server

SQL Server Audit Checklist: Discovery & Setup

Audit SQL Server with a structured discovery checklist. Covers server configuration, disk and memory, backups, security, database settings, and code...

06 June 2024 30 min read

T-SQL Programming

Edward Pollack in T-SQL Programming

Store, Parse & Convert XML in SQL Server

Master XML handling in SQL Server: store XML in typed columns, parse with XQuery and OPENXML, convert between XML and...

03 June 2024 22 min read

T-SQL Programming

Aaron Bertrand in T-SQL Programming

Snake Draft Sorting in SQL Server Part 4: Coordinating Parallel Job Completion

Part 4 of the snake-draft sorting series - coordinating parallel SQL Agent jobs when work units finish at different times....

27 May 2024 10 min read

Theory and design

Joe Celko in Theory and design

The CHECK() Constraint

One of the many ways a relational table differs from the file structures used by pre-relational storage systems is that...

20 May 2024 11 min read

MySQL

Adrien Payong in MySQL

Exploring MVCC and InnoDB’s Multi-Versioning Technique

In the realm of relational databases, MySQL stands out as one of the most popular choices. Maximizing its performance is...

20 May 2024 33 min read

Lukas Vileikis in MySQL

Optimizing MySQL: Deleting Data

In the previous parts of these MySQL optimization series, we told you how query optimization works on a high level,...

17 May 2024 14 min read

T-SQL Programming

Aaron Bertrand in T-SQL Programming

Snake Draft Sorting in SQL Server Part 3: Balancing Work Across Tables Within One Database

Part 3 of the snake-draft sorting series - extending the technique from balancing work across databases (parts 1-2) to balancing...

15 May 2024 5 min read

BI

Fabriano Richard in BI

PowerBI premium capacity administration: dataset monitoring and tuning

Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its...

13 May 2024 12 min read

Koen Verbeeck in BI

How to Build Metadata Driven Pipelines in Microsoft Fabric

Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined software engineering approach....

06 May 2024 11 min read

Robert Sheldon in MongoDB

Updating Documents in MongoDB

In the previous articles this series, I demonstrated various ways to retrieve document data from a MongoDB database, using both...

29 April 2024 21 min read

PostgreSQL

Ryan Booz in PostgreSQL

Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3

The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – taking raw input...

22 April 2024 15 min read

Ben Johnston in Databases

How to build a data culture: the 8 technical pillars that make it work

Building a data culture takes more than good intentions. Here are the technical pillars — from data discoverability to error...

19 April 2024 13 min read

Theory and design

Phil Factor in Theory and design

Database Subsetting and Data Extraction

Let’s start by defining a subset and why you would require a data subset? When dealing with the development, testing...

17 April 2024 11 min read

T-SQL Programming

Aaron Bertrand in T-SQL Programming

Snake draft sorting in SQL Server, part 2

Part of a series: [ Part 1 | Part 2 | Part 3 | Part 4 ] In my previous...

15 April 2024 7 min read