Koen Verbeeck in BI

How to Stream Data from Azure Event Hubs into a Fabric Eventhouse

At Microsoft Build 2024, Real-Time Intelligence was announced with the Real-Time hub as its centralized location for all data-in-motion. This...

26 July 2024 9 min read

Ben Johnston in SQL Server

SQL Server Configuration Audit: Complete Checklist and T-SQL Scripts

Complete SQL Server configuration audit checklist with T-SQL scripts: edition and patch level, file locations, sp_configure settings, logon triggers, login...

25 July 2024 22 min read

Aaron Bertrand in T-SQL Programming

Index cleanup : Harder than it looks

I’m not the first person to write about cleaning up unused or redundant indexes. You can read many articles about...

22 July 2024 7 min read

Ben Johnston in SQL Server

How to successfully execute a SQL Server hardware audit (complete guide)

Learn how to audit SQL Server hardware and Azure cloud configuration — covering CPU, memory, storage, OS version, and backups...

17 July 2024 14 min read

Boris Novikov in PostgreSQL

PostgreSQL Temporal Aggregates: SUM, AVG & COUNT Across Time

How to compute temporal aggregates in PostgreSQL when values change over time. Covers custom SUM, AVG, COUNT, MIN, and MAX...

16 July 2024 20 min read

Robert Sheldon in MongoDB

Working with Documents in the MongoDB Compass GUI

Throughout this series, I’ve discussed various ways to work with the documents in a MongoDB collection. If you’ve been following...

10 July 2024 23 min read

Aaron Bertrand in Database Administration

It’s a recovery strategy, not a backup strategy

I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. I can’t possibly...

08 July 2024 12 min read

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