Theory and design Joe Celko in Theory and design The CHECK() Constraint One of the many ways a relational table differs from the file structures used by pre-relational storage systems is that... 20 May 2024 11 min read
MySQL Adrien Payong in MySQL Exploring MVCC and InnoDB’s Multi-Versioning Technique In the realm of relational databases, MySQL stands out as one of the most popular choices. Maximizing its performance is... 20 May 2024 33 min read
Lukas Vileikis in MySQL Optimizing MySQL: Deleting Data In the previous parts of these MySQL optimization series, we told you how query optimization works on a high level,... 17 May 2024 14 min read
T-SQL Programming Aaron Bertrand in T-SQL Programming Snake draft sorting in SQL Server, part 3 Part of a series: [ Part 1 | Part 2 | Part 3 | Part 4 ] In part 2... 15 May 2024 5 min read
BI Fabriano Richard in BI PowerBI premium capacity administration: dataset monitoring and tuning Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its... 13 May 2024 12 min read
Koen Verbeeck in BI How to Build Metadata Driven Pipelines in Microsoft Fabric Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined software engineering approach.... 06 May 2024 11 min read
Robert Sheldon in MongoDB Updating Documents in MongoDB In the previous articles this series, I demonstrated various ways to retrieve document data from a MongoDB database, using both... 29 April 2024 21 min read
PostgreSQL Ryan Booz in PostgreSQL Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3 The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – taking raw input... 22 April 2024 15 min read
Theory and design Phil Factor in Theory and design Database Subsetting and Data Extraction Let’s start by defining a subset and why you would require a data subset? When dealing with the development, testing... 17 April 2024 11 min read
T-SQL Programming Aaron Bertrand in T-SQL Programming Snake draft sorting in SQL Server, part 2 Part of a series: [ Part 1 | Part 2 | Part 3 | Part 4 ] In my previous... 15 April 2024 7 min read
T-SQL Programming Aaron Bertrand in T-SQL Programming Snake draft sorting in SQL Server, part 1 Part of a series: [ Part 1 | Part 2 | Part 3 | Part 4 ] I recently had... 12 April 2024 8 min read
BI Dennes Torres in BI Fabric and Azure SQL in a few clicks: Mirroring a Database Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for CosmoDB and Snowflake... 12 April 2024 11 min read
PostgreSQL Ryan Booz in PostgreSQL Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2 In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in ingesting and transforming... 08 April 2024 13 min read
Editorials Louis Davidson in Editorials Giving Feedback on Microsoft Data Platform Tools As a data professional, there is a set of tools that you use on pretty much a daily basis. Before... 08 April 2024 3 min read
MongoDB Robert Sheldon in MongoDB Building MongoDB Aggregations in MongoDB Compass In the previous article in this series, I demonstrated how to build and run an aggregate statement in MongoDB Shell.... 02 April 2024 22 min read
Theory and design Joe Celko in Theory and design SQL Logic In this article, I will discuss the history and thinking behind several types of logic that are typically associated with... 29 March 2024 13 min read
T-SQL Programming Aaron Bertrand in T-SQL Programming Pagination and ordering by large values Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on Amazon, or browsing... 25 March 2024 9 min read
Theory and design Joe Celko in Theory and design Department of Redundancy Department Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too... 18 March 2024 12 min read
PostgreSQL Ryan Booz in PostgreSQL Transforming and Analyzing Data in PostgreSQL In our data hungry world, knowing how to effectively load and transform data from various sources is a highly valued... 12 March 2024 20 min read
Database Administration Aaron Bertrand in Database Administration Get the most out of SQL Server Agent logs If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on SQL Server Agent... 11 March 2024 6 min read