Joe Celko in Theory and design The CREATE DOMAIN Statement One of the least known, least used features of SQL is the CREATE DOMAIN statement. It does not exist in... 27 March 2025 6 min read
Lee Asher in PostgreSQL The Wide World of GiST Indexes In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets in PostgreSQL) of... 25 March 2025 15 min read
Aisha Bukar in MySQL MySQL vs PostgreSQL – String Datatypes A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents.... 20 March 2025 22 min read
Aisha Bukar in MySQL MySQL vs. PostgreSQL: Character Sets and Collations When working with strings in a database system, you need to ensure that the data is stored, sorted, and compared... 17 March 2025 18 min read
Joe Celko in Theory and design Scales & Measurements If you’re going to work with databases, you probably ought to know something about data. In particular, we don’t put... 07 March 2025 11 min read
Robert Sheldon in MongoDB Importing and exporting data in MongoDB Compass When working with MongoDB, you’ll likely need to import or export document data from time-to-time. You can use MongoDB Compass... 05 March 2025 16 min read
Anil Kumar Moka in Snowflake Implementing Enterprise Data Security in Snowflake: Practical Concepts As a data engineer who’s spent the last few years implementing enterprise-scale security in Snowflake, I’ve witnessed firsthand how challenging... 04 March 2025 16 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 3 – Disk I/O and Storage Optimization) So far, in our previous articles on MySQL optimization, we’ve looked at basic configuration management and memory and CPU tuning... 27 February 2025 15 min read
Louis Davidson in T-SQL Programming Crazy number of Parameters… and a challenge The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on X: So I... 24 February 2025 35 min read
Rodrigo Ribeiro Gomes in T-SQL Programming AI in SQL Server 2025: Embeddings One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for text, video, or... 18 February 2025 48 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Descending B-Tree Indexes Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly used data structures... 13 February 2025 11 min read
Edward Pollack in T-SQL Programming Exploring Scalar Solutions to Complex Data Math There are many functions and tools available to database professionals that can solve data math challenges, regardless of complexity. A... 12 February 2025 17 min read
Kellyn Pot'Vin-Gorman What is Oracle RAC and Why Use it for Scaling Workloads? Oracle Real Application Clusters (RAC) is a database clustering solution that enables multiple servers to operate as a single, unified... 10 February 2025 6 min read
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 Blogs 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