How to build a career in data: top tips from those who’ve done it (complete series)

Do you want a career in data? Maybe you're a recent grad, or perhaps you've tired of your current role...

DBA in Training (how to become a database administrator) – the complete series

Learn how to become a DBA (database administrator) - plus, learn the all the essentials of SQL Server, from the...

Windows containers & Docker basics: a complete guide

Windows containers package applications with their dependencies into isolated, portable units on Windows Server 2016+. Unlike virtual machines (VMs), containers...

Window function performance in SQL Server: a complete guide

Learn everything you need to know about window function performance in SQL Server.…

AI text embeddings in SQL Server: everything you need to know

Complete guide to AI text embeddings in SQL Server, featuring everything you need to know – with tips, advice and...

Oracle SQL query parsing: a complete guide

Here's everything you need to know about Oracle SQL query parsing in one detailed mini-series.…

The complete guide to SQL in Cosmos DB

Cosmos DB is a multi-model NoSQL database. However, one of the models it handles - the document database - can...

Overlap queries in PostgreSQL: a complete guide

Learn everything you need to know about overlap queries in PostgreSQL: complete guide featuring expert advice, examples, and sample code.…

The complete guide to Row-Level Security (RLS) in SQL Server

Learn everything you need to know about SQL Server Row-Level Security (RLS) with this complete, six-part deep-dive series.…

How I built an app just by talking to an AI LLM

Can you build an app, from the ground up, just by talking to an AI LLM? Find out in this...

SQL Server security vulnerabilities you weren’t aware of

SQL Server has a surprising number of security vulnerabilities, potentially leading to severe consequences. In this series, learn all about...

Startup Stories

Simple Talk's Startup Stories series - highlighting the good, bad and ugly of startups, and lessons learned along the way!…

The complete ‘Too Shy to Ask’ series

What are the database and technology questions you’re simply too shy to ask? Whether you’re confused about SQL Server foreign...

The complete guide to Dynamic Data Masking in SQL Server

Learn all about Dynamic Data Masking in SQL Server with Ben Johnston's detailed guide.…

How to overcome the cloud migration challenges of 2026 (a Grant Fritchey mini-series)

In this series, Grant Fritchey takes a deep dive into the findings from Redgate's 2026 State of the Database Landscape...

The complete guide to auditing SQL Server

Ben Johnston explores all things SQL Server auditing in this 2024 series. He covers everything from the basic initial setup...

How to code in T-SQL

Learn how to code in T-SQL with this extensive series of practical, ‘how-to’ guides.…

T-SQL Coding Basics

In this series, Robert Sheldon introduces you to the basics of working with T-SQL, covering such topics as readability, accuracy,...

How to migrate from on-prem to the cloud (a ‘DBA Stories’ series)

In this DBA Stories series, Pat Wright details the key steps of migrating from on-premises to the cloud. Each of...

How to transform and analyze data in PostgreSQL

Ryan Booz explains all you need to know about transforming and analyzing data in PostgreSQL in this three-part series.…