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

Louis Davidson in Editorials

Simple Talk 2024 Year in Review

Edit: Added pictures to the PASS section of the Redgate Hub Happy New Year to all of the Simple talk...

31 December 2024 7 min read

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

Bravin Wasike in DevOps

Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD

This article covers examples of how some larger companies have successfully implemented CI/CD practices to transform their development processes. Through...

20 December 2024 12 min read

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

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

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

Louis Davidson in Career

TSQL Tuesday #181 – The first SQL Server Feature that made me go “Wow!”

First off, thank you to Kevin Chant for hosting TSQL Tuesday this month. And equally, thank you for not putting...

11 December 2024 4 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

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

Dennes Torres in Microsoft Fabric

Granting Permissions in a Fabric Data Warehouse and Lakehouse

We are becoming used to being a bit lazy when granting permissions to Data Warehouses and lakehouses in Fabric. We...

04 December 2024 4 min read

Louis Davidson in Editorials

Love Your Conference Sponsors

You probably already realize this, but I work for a company that sponsors conferences. As the editor of Simple Talk,...

04 December 2024 4 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

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

Register for Simple Talk

Articles