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 1
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 4
Edward Pollack in SQL Server Reading and Writing Parquet Files in SQL Server This article demonstrates how to read data from SQL Server and write it to Apache Parquet files – and vice... 19 November 2024 17 min read 21
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 2
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 3
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 83
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 1
Robert Sheldon in MongoDB Creating Views in MongoDB Like many relational database systems, MongoDB supports the use of views. A view is a read-only object in a MongoDB... 16 October 2024 15 min read 11
Koen Verbeeck in BI Quick Tricks to Make Your Power BI Model Smaller, More Efficient and Almost Certainly Faster Power BI has been a leading data visualization tool in the market for years. It can be used as a... 11 October 2024 13 min read 11
Joe Celko in Theory and design Rounding Numbers I would hope by now everybody has figured out when you see a price like $39.99 that it might as... 23 September 2024 12 min read 651
Boemo Mmopelwa in Tools Boosting Database Development Efficiency Using AI SQL Code Generators Database development has become more complex over the years due to the introduction of new data and storage formats by... 20 September 2024 11 min read 41
Robert Sheldon in MongoDB Working with Schema Validation in MongoDB In the previous article in this series, I introduced you to schema validation in MongoDB. I described how you can... 13 September 2024 18 min read 1
Lukas Vileikis in Blogs Thoughts Before Covering MariaDB Indexes in the MariaDB Server Fest 2024 This blog outlines why you should be coming to see a talk on MariaDB indexes at the MariaDB Server Fest... 13 September 2024 4 min read
Adrien Payong in Theory and design Database Sharding: Strategies for Seamless Scaling and Performance Optimization Companies of all sizes and across industries are struggling to cope with an explosion of data never before seen in... 13 September 2024 21 min read 21
Boris Novikov in PostgreSQL PostgreSQL Temporal Tables: INSERT, UPDATE & DELETE Learn how to INSERT, UPDATE, and DELETE data in PostgreSQL temporal tables. Covers temporal integrity constraints using EXCLUDE clauses, temporal... 11 September 2024 19 min read 1
Lukas Vileikis in Blogs Devising the Perfect Index for Your Use Case – MySQL Edition This blog will walk you through how to choose the perfect index for your specific use case. It will also... 11 September 2024 7 min read
Joe Celko in Theory and design Uniqueness, Keys, and Identity If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as the founding principle... 09 September 2024 16 min read 111
Grant Fritchey in PostgreSQL PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant The focus of your backup strategy should not be backups. Instead, you should be focused on restoring databases, because, after... 07 September 2024 12 min read 111
