Querying MongoDB Documents
MongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with […]
Homepage
The Importance of Retention
It is always an afterthought. New objects are created that start off small and current. New feature […]
Optimized locking in Azure SQL Database
I don’t think I’ve ever had a great impression of Azure SQL Database as a place for […]
PowerShell Dynamic Parameters and SQL Server
Have you ever been in a situation that you want to call a cmdlet or a function […]
Two-Dimensional Interval Packing Challenge
Packing intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective […]
Eager Aggregation in SQL queries
Aggregation is a widely used way to summarize the content of a database. It is usually expressed […]
Introducing the MongoDB Document
MongoDB is a document database. As such, the data is stored as individual documents. A document is […]
Counting more efficiently
Nearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” […]
Using a SQL Tokenizer
Imagine this: you have several directories full of SQL script files, and you need to know where […]
Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric
I have published videos and articles before about Lakehouse maintenance. In this article I want to address […]
MySQL Error Log Management in DevOps Operations
When it comes to the development and operations (DevOps), one thing stands out as a critical aspect […]
Exploring PostgreSQL Indexes
In this blog, we continue our exploration on PostgreSQL indexes which we started here. In that article, […]