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 1
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 1
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 1
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 1
Rodrigo Ribeiro Gomes in T-SQL Programming AI in SQL Server 2025: Embeddings Discover how SQL Server 2025 introduces embeddings and vector support in T‑SQL. Learn to store, compare, and query AI-generated vectors... 18 February 2025 48 min read 1252
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 11
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 1
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 3
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 72
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 2
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 311
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 21
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 1
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 1
Lukas Vileikis in Blogs 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 21
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 331
Aaron Bertrand in T-SQL Programming Five changes to SQL Server I’d love to see I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very few of my... 01 January 2025 5 min read 64
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
