Louis Davidson in T-SQL Programming

SQL Server BIT_COUNT and an Alternative

I was editing an article the other day that uses the BIT_COUNT function that was added to SQL Server 2022....

08 February 2025 11 min read

Louis Davidson in SQL Server

Dark Mode in SSMS 21 and overall first impressions

Let me cut to the chase. If you are like me, you may have been searching for: How to turn...

02 February 2025 4 min read

Robert Sheldon in MongoDB

Creating Time Series Collections in MongoDB

Throughout this series, I’ve introduced you to different features in MongoDB and provided examples to help demonstrate how the database...

27 January 2025 15 min read

Joe Celko in Theory and design

Temporary Tables

There is a feature of SQL I have not seen used much and probably with good reason. It’s the use...

24 January 2025 9 min read

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

Chisom Kanu in MySQL

MySQL Shell Basic Configuration Management (Part 2 – Memory and CPU)

In the first part of the series article, we introduced MySQL Shell as a tool for managing and optimizing MySQL...

17 January 2025 17 min read

Joe Celko in Theory and design

VIEW Objects

A view is a virtual table, created when it’s invoked by the < view name>. The goal we had in...

13 January 2025 7 min read

Hacking MySQL - Breaking, Optimizing, and Securing MySQL for Your Use Case

Lukas Vileikis in Other

I Wrote a Book on How You Broke Your Database – Here’s Why You Should Read It

This blog introduces the book "Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case" by Lukas Vileikis.…

10 January 2025 7 min read

Edward Pollack in SQL Server

Customizing the Export and import of Parquet Files in SQL Server

Previously, we introduced and discussed the Parquet file format and SQL Server and why it is an ideal format for...

10 January 2025 10 min read

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

Oracle Architecture Overview

I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways are best, but...

02 January 2025 24 min read

Aaron Bertrand in T-SQL Programming

Five SQL Server changes I’d love to see (DROP_EXISTING, ALTER TABLE, STRING_SPLIT fixes)

Aaron Bertrand on five SQL Server behaviours he'd like Microsoft to fix: DROP_EXISTING needing an existing index, ALTER TABLE DROP...

01 January 2025 5 min read

Chisom Kanu in MySQL

MySQL Shell Basic Configuration Management (Part 1 – Introduction)

The database is an important part of any application and setting it up correctly is key to ensuring smooth performance....

27 December 2024 23 min read

Anil Kumar Moka in Snowflake

When Should You Employ Snowflake Materialized Views?

I’ve used both Snowflake views and materialized views with varying degrees of success. Both have their place and it’s on...

16 December 2024 16 min read

Dennes Torres in Other

T-SQL Tuesday #181: Query Store and its evolution

Query Store. This is my choice in relation to “What feature release made you say WOW!”, the subject of this...

09 December 2024 4 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

Lukas Vileikis in MySQL

MySQL Index Overviews: Clustered B-Tree Indexes

If you’re a frequent reader of the Simple-Talk blog, you’re no stranger to indexes as we’ve covered indexes in database...

03 December 2024 10 min read

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