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
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 Deep Dive: 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
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
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 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
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
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
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
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
Koen Verbeeck in Azure How To Embed Your Azure Logic Apps in a Metadata-driven Data Platform In this article, I am going to explain how you can dial your productivity up to 11 when you’re dealing... 22 October 2024 27 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
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
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
