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 SQL Server changes I’d love to see (DROP_EXISTING, ALTER TABLE, STRING_SPLIT fixes) Aaron Bertrand on five SQL Server behaviours he'd like Microsoft to fix: DROP_EXISTING needing an existing index, ALTER TABLE DROP... 01 January 2025 6 min read 65
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
Goodness Woke in Other Development Frappe’s Configuration vs Laravel’s Code-Centric Customisation This article compares the Frappe and the Laravel frameworks, focusing on key technical differences in customization, database management, and API... 23 December 2024 23 min read 1
John Kerski in Data Science Comparing Groups for Similarities in Power Query – Using Cosine Similarity I’ll admit upfront—I am not a data scientist by trade. Instead, I’ve picked up my data science skills over time,... 17 December 2024 7 min read 21
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 221
Phil Factor in Other Development Data Documents and Common Sense What can be so difficult in creating a sensible standard for Structured Data Documents? To understand why they tend to... 13 December 2024 5 min read
Koen Verbeeck in General Analytics A gentle introduction to dbt In a typical data warehouse project, data is loaded, transformed and stored into a data store using an ETL (extract... 10 December 2024 12 min read 11
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 11
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 1
Lee Asher in PostgreSQL PostgreSQL Range Overlap Queries: GiST Indexes, EXCLUDE Constraints for Non-Overlapping Rows, and tstzrange Semantics PostgreSQL range types and overlap queries - GiST indexes for efficient range overlap detection, EXCLUDE constraints preventing overlapping rows in... 29 November 2024 11 min read 32
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
John Kerski in Career Hiring and Motivating Technical Polyglots in Data Analytics In this article, I will discuss hiring and motivating technical polyglots. A polyglot is a person who speaks multiple languages... 22 November 2024 9 min read 331
Dennes Torres in Conferences Breaking Down Ignite: A Pragmatic Look at the Conference’s Best Innovations The amount of news brought by Ignite is huge. I was not expecting to find so many new features, resources,... 21 November 2024 10 min read
Edward Pollack in SQL Server Read and Write Parquet Files with SQL Server and Python Read and write Apache Parquet files from SQL Server using Python, pandas, and pyarrow - no native SQL Server Parquet... 19 November 2024 17 min read 21
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
Bravin Wasike in CI/CD Demystifying Continuous Integration vs. Continuous Delivery: Part 2 Welcome to part 2 of our Demystifying Continuous Integration vs. Continuous Delivery series. In Part 1 of the series, we... 08 November 2024 27 min read 1
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
Phil Factor in AI AI and Databases Although it is probably true to say that “AI is reshaping the landscape of database technology“, it’s also an over-simplification.... 01 November 2024 12 min read 211
