Louis Davidson in Books

Introduction to PostgreSQL for the Data Professional

Learning something new has elements of bliss and terror. We all know the bliss of learning something new. The first...

13 May 2025 2 min read

Ben Johnston in Blogs

Managed Instance Gotchas – Configuration Items

In my last post I described issues that might stop your migration to a SQL Server Managed Instance (SQL MI)....

13 May 2025 10 min read

Rodrigo Ribeiro Gomes in Database Administration

Recovering data in SQL Server without full backup

In more than 10 years of experience, I have dealt with cases where someone has performed incorrect operations on a...

13 May 2025 32 min read

Louis Davidson in Editorials

What’s Your Price?

Everyone has a price, and that price takes many forms. It could be money, loved ones, comfort, duty, or a...

12 May 2025 7 min read

Farooq Aziz in Snowflake

Parent – Child Task Automation in Snowflake via Task Graph

In the fast-paced world of business, fast, effective data management is crucial. One of the places where this is the...

09 May 2025 12 min read

Anil Kumar Moka in Snowflake

Real-time Data Streaming in Snowflake

Real-time data ingestion has become essential for modern analytics and operational intelligence. Organizations across industries need to process data streams...

08 May 2025 24 min read

Dennes Torres in T-SQL Programming

Techniques to query Azure SQL’s new JSON Datatype

The new JSON field type and new functions in Azure SQL brings a new world of possibilities for JSON manipulation...

07 May 2025 15 min read

Louis Davidson in Conferences

Jacksonville SQL Saturday 2025 Roundup

Are SQL Saturdays finally back to the way they should be? This past weekend in Jacksonville Florida things sure felt...

06 May 2025 5 min read

Lukas Vileikis in MySQL

MySQL Index Overviews: Hash Indexes

Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as well as walked...

06 May 2025 14 min read

Louis Davidson in Editorials

Data-Based Movie Reviews: Moneyball

A while back, a friend of mine, who is big into baseball, tried to encourage me to watch the movie:...

05 May 2025 8 min read

Dennes Torres in Blogs

Query Lineage in Fabric Lakehouses

I already wrote about query performance analysis in lakehouses, but one secret was left behind: The capability to track the...

02 May 2025 7 min read

Matt Gantz in T-SQL Programming

Purging Data from a Large Table in SQL Server

Purging data from a table is a common database maintenance task to prevent it from growing too large or to...

01 May 2025 8 min read

Robert Sheldon in MongoDB

Working with the MongoDB Database Tools

The MongoDB Database Tools are a set of command-line utilities for working with MongoDB instances and their data. You can...

29 April 2025 16 min read

Louis Davidson in Editorials

The power of connecting in person

To start off I want to be clear, I am a big proponent of telecommuting. Big. It has been at...

28 April 2025 6 min read

Louis Davidson in Conferences

PGDay Chicago 2025 Roundup

Just got back home last night about 2 AM, and I am sitting in a park thinking about the last...

28 April 2025 4 min read

Goodness Woke in Web

Frappe vs. Laravel: REST API Integration Techniques

REST APIs are fundamental in enabling communication between applications. Frappe and Laravel offer large frameworks to build and consume REST...

24 April 2025 17 min read

Koen Verbeeck in General Analytics

How to Load a Date Dimension in Microsoft Fabric using Macros in dbt?

With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features at our disposal...

23 April 2025 7 min read

Dennes Torres in Blogs

Azure Function & API Rate Limits: How NAT Gateway Helps You Stay Under the Radar

Rate limit is common when consuming API’s: They control how many calls you can make in an interval of time....

23 April 2025 4 min read

Bravin Wasike in DevOps

Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security

Strengthening Deployments and Runtime Protection In Part 1 of this series, we explored the foundational aspects of securing a DevOps...

22 April 2025 16 min read

Simple Talk Editor in Conferences

Sponsoring PGDay Chicago this week

On Friday, April 25, Simple Talk is excited to be a sponsor of PGDay Chicago 2025. This will be the...

22 April 2025 1 min read

Register for Simple Talk

Articles

Introduction to PostgreSQL for the Data Professional

Managed Instance Gotchas – Configuration Items

Recovering data in SQL Server without full backup

What’s Your Price?

Parent – Child Task Automation in Snowflake via Task Graph

Real-time Data Streaming in Snowflake

Techniques to query Azure SQL’s new JSON Datatype

Jacksonville SQL Saturday 2025 Roundup

MySQL Index Overviews: Hash Indexes

Data-Based Movie Reviews: Moneyball

Query Lineage in Fabric Lakehouses

Purging Data from a Large Table in SQL Server

Working with the MongoDB Database Tools

The power of connecting in person

PGDay Chicago 2025 Roundup

Frappe vs. Laravel: REST API Integration Techniques

How to Load a Date Dimension in Microsoft Fabric using Macros in dbt?

Azure Function & API Rate Limits: How NAT Gateway Helps You Stay Under the Radar

Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security

Sponsoring PGDay Chicago this week