Aaron Bertrand in Database Administration

Upgrade SQL Server on your workstation

Lately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. The main source...

26 February 2024 6 min read

PostgreSQL

Grant Fritchey in PostgreSQL

Functions and Procedures: Learning PostgreSQL with Grant

One of the most useful constructs in SQL Server is the stored procedure. It gives you a way to do...

15 February 2024 9 min read

Database Administration

Aaron Bertrand in Database Administration

Leave it better than you found it

This is for the folks who still have to log into remote machines and do work manually on the box....

12 February 2024 8 min read

BI

Dennes Torres in BI

Top-Down and Bottom-Up Approaches in Microsoft Fabric

Nikola Ilic, best known as Data Mozart, published a great article and video about how to make semantic model data...

25 January 2024 9 min read

Louis Davidson in Career

State of the Database Landscape Results 2024

Every year, Redgate surveys technologists to ask a big question (through lots of little questions, naturally.) This year’s question was...

23 January 2024 3 min read

Robert Sheldon in MongoDB

Querying MongoDB Documents

MongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with MongoDB will not...

22 January 2024 25 min read

Database Administration

Edward Pollack in Database Administration

The Importance of Retention

It is always an afterthought. New objects are created that start off small and current. New feature development takes over...

19 January 2024 24 min read

Database Administration

Aaron Bertrand in Database Administration

Optimized locking in Azure SQL Database

I don’t think I’ve ever had a great impression of Azure SQL Database as a place for production applications. In...

08 January 2024 8 min read

T-SQL Programming

Itzik Ben-Gan in T-SQL Programming

Two-Dimensional Interval Packing in SQL Server: Itzik Ben-Gan’s Unpack/Pack Solution

Itzik Ben-Gan's two-dimensional interval packing challenge in SQL Server: packing overlapping student schedule intervals across date and period axes. Complete...

02 January 2024 17 min read

Ben Johnston in SQL Server

11 proven data warehouse load patterns (complete guide, part two)

11 proven data warehouse load patterns — revised date, modified flag, hash comparison, history tables, and more — with the...

31 December 2023 30 min read

PostgreSQL

Boris Novikov in PostgreSQL

Eager Aggregation in SQL queries

Aggregation is a widely used way to summarize the content of a database. It is usually expressed with GROUP BY...

27 December 2023 15 min read

Robert Sheldon in NoSQL

Introducing the MongoDB Document

MongoDB is a document database. As such, the data is stored as individual documents. A document is a data structure...

26 December 2023 18 min read

T-SQL Programming

Aaron Bertrand in T-SQL Programming

Counting more efficiently

Nearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” In that post,...

20 December 2023 7 min read

Theory and design

Phil Factor in Theory and design

Using a SQL Tokenizer

Imagine this: you have several directories full of SQL script files, and you need to know where a certain table...

18 December 2023 9 min read

BI

Dennes Torres in BI

Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric

I have published videos and articles before about Lakehouse maintenance. In this article I want to address a missing point...

17 December 2023 12 min read

MySQL

Mercy Bassey in MySQL

MySQL Error Log Management in DevOps Operations

When it comes to the development and operations (DevOps), one thing stands out as a critical aspect and that is...

14 December 2023 14 min read

PostgreSQL

Henrietta Dombrovskaya in PostgreSQL

Exploring PostgreSQL Indexes

In this blog, we continue our exploration on PostgreSQL indexes which we started here. In that article, we learned what...

11 December 2023 12 min read

PostgreSQL

Aboze Brain in PostgreSQL

Understanding SQL Join Types

Understanding how to join the data in one table to another is crucial for any data analyst or database developer...

04 December 2023 32 min read

T-SQL Programming

Aaron Bertrand in T-SQL Programming

When an update doesn’t update

Tell me if you’ve heard this one before: I changed data from my application, but when I checked the database,...

27 November 2023 5 min read

Ben Johnston in SQL Server

Getting started with data warehouse load patterns (complete guide, part one)

The requirements, prerequisites, and general patterns behind every solid data warehouse load — from natural keys and refresh rates to...

26 November 2023 28 min read

Register for Simple Talk

Databases

Upgrade SQL Server on your workstation

Functions and Procedures: Learning PostgreSQL with Grant

Leave it better than you found it

Top-Down and Bottom-Up Approaches in Microsoft Fabric

State of the Database Landscape Results 2024

Querying MongoDB Documents

The Importance of Retention

Optimized locking in Azure SQL Database

Two-Dimensional Interval Packing in SQL Server: Itzik Ben-Gan’s Unpack/Pack Solution

11 proven data warehouse load patterns (complete guide, part two)

Eager Aggregation in SQL queries

Introducing the MongoDB Document

Counting more efficiently

Using a SQL Tokenizer

Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric

MySQL Error Log Management in DevOps Operations

Exploring PostgreSQL Indexes

Understanding SQL Join Types

When an update doesn’t update

Getting started with data warehouse load patterns (complete guide, part one)