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
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
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 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
Chisom Kanu in MySQL Introduction to MySQL Shell and Basic Configuration Management (Part 1) 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 Blogs 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 Database for Database Professionals Oracle Database, often referred to simply as Oracle, is one of the most powerful and widely used relational database management... 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 Overlapping Ranges in Subsets in PostgreSQL In Part I of this series, we explored overlap queries and the problems that accompany them, along with ways to... 29 November 2024 10 min read
Robert Sheldon in MongoDB Working with MongoDB Indexes Throughout this series, I’ve covered a number of topics about working with MongoDB collections and their data. One topic I... 26 November 2024 20 min read
Anil Kumar Moka in Snowflake Essential Strategies for Optimizing Snowflake Performance and Reducing Costs In today’s data-driven enterprise environment, businesses increasingly rely on Snowflake’s cloud data warehouse for handling large-scale data analytics and storage... 25 November 2024 16 min read
Edward Pollack in SQL Server Reading and Writing Parquet Files in SQL Server When analytic data is stored directly in SQL Server, a clustered columnstore index is an ideal place for that data... 19 November 2024 16 min read
Aisha Bukar in Databases MySQL vs PostgreSQL: Numeric Datatype Comparison When you think of how to store data in a database, you think of data types. A data type represents... 15 November 2024 18 min read
Joe Celko in Theory and design Data Control Language (aka Security) Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the data. This is... 12 November 2024 11 min read
Robert Sheldon in MongoDB Connecting to MongoDB through Python This article is a bit of a departure from the previous articles in this series. Rather than focusing exclusively on... 05 November 2024 19 min read
Joe Celko in Theory and design Transactions By now, pretty much everyone has heard the stories about the first computers. They were huge, cost a fortune, required... 29 October 2024 10 min read
Lukas Vileikis in MySQL MySQL Index Overviews: FULLTEXT B-Tree Indexes If you’ve been following Simple Talk for a while, you know that we’re fans of databases and everything they involve.... 25 October 2024 17 min read
Chisom Kanu in Big Data Consistency and Concurrency in NewSQL Database Systems Companies today require database systems that are reliable and capable of efficiently handling large volumes of data and numerous transactions.... 18 October 2024 36 min read
