Ben Johnston in SQL Server SQL Server 2022 CU Updates and Error Code 0x851A0043 I’ve been working in the Azure space for the last few years and less with full server installations. Azure leaves... 18 February 2025 5 min read
Robert Sheldon in MongoDB How to create MongoDB time series collections (setup and granularity guide) How to create MongoDB time series collections — timeField, metaField, granularity options, automatic expiration, and querying, with worked examples.… 27 January 2025 15 min read 2
Dennes Torres in Other Azure SQL Serverless: Discover What’s new and Increase Your Savings Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure SQL Serverless? The... 22 January 2025 3 min read 21
Ben Johnston in SQL Server When to enable memory-optimized tempdb metadata in SQL Server (and how to diagnose it) How to diagnose tempdb metadata latch contention in SQL Server - and decide whether enabling memory-optimized tempdb metadata is the... 08 January 2025 10 min read
Kellyn Pot'Vin-Gorman in Oracle Introduction to Oracle: Key features, architecture, and getting started with 23ai Oracle Database is a powerful enterprise RDBMS built for scalability, security, and high availability. Learn its architecture, key features, and... 05 December 2024 12 min read 211
Lee Asher in PostgreSQL PostgreSQL Range Overlap Queries: GiST Indexes, EXCLUDE Constraints for Non-Overlapping Rows, and tstzrange Semantics PostgreSQL range types and overlap queries - GiST indexes for efficient range overlap detection, EXCLUDE constraints preventing overlapping rows in... 29 November 2024 11 min read 32
Robert Sheldon in MongoDB How to connect to MongoDB with Python (PyMongo CRUD guide) How to connect to MongoDB from Python using the PyMongo driver, and perform create, read, update, and delete operations —... 05 November 2024 19 min read
Ben Johnston in SQL Server How to write an efficient SQL query: practical guidelines for faster, lighter queries Practical guidelines for writing efficient SQL queries: sargable predicates, set-based operations, index candidates, and how to read a query plan.… 19 October 2024 21 min read 3
Robert Sheldon in MongoDB MongoDB schema validation guide: handling existing documents How to find, bypass, update, and delete documents that violate MongoDB schema validation rules — plus validationAction and validationLevel options.… 13 September 2024 18 min read 1
Lukas Vileikis in Other Thoughts Before Covering MariaDB Indexes in the MariaDB Server Fest 2024 This blog outlines why you should be coming to see a talk on MariaDB indexes at the MariaDB Server Fest... 13 September 2024 4 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 431
Ben Johnston in Databases How to choose the right data types and column options in databases How to pick the right SQL Server data type for every column - covering size, performance, NULLs, and the code... 31 August 2024 28 min read 11
Robert Sheldon in MongoDB How to add schema validation rules to a MongoDB collection with $jsonSchema How to add schema validation rules to a MongoDB collection with $jsonSchema — required fields, data types, enums, null handling,... 21 August 2024 21 min read
Ben Johnston in SQL Server How to master a database configuration audit in SQL Server: a complete guide A SQL Server database configuration audit is where most issues are found — from compatibility levels and file locations, to... 20 August 2024 16 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 1
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
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
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
Robert Sheldon in MongoDB How to build MongoDB aggregations (match, group & sort explained) How MongoDB's aggregate method and pipeline stages work — $match, $unwind, $group, $project, and $sort — built up through a... 01 March 2024 21 min read
Ben Johnston in SQL Server 11 proven data warehouse load patterns (complete guide, part two) 11 proven data warehouse load patterns — revised date, modified flag, hash comparison, history tables, and more — with the... 31 December 2023 30 min read
