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

Blogs

Dennes Torres in Blogs

Fabric and Self-Service: Control who can use

We can say Fabric is the evolution of the Power BI environment. Power BI is a self-service environment, and so...

17 January 2024 2 min read

Blogs

Louis Davidson in Blogs

Working on Technology Off the Clock

I have always spent time learning relational databases on my own, non-work time. As the years have passed, I have...

16 January 2024 3 min read

Web

Benedict Ampea-Badu in Web

Making Accessibility Part of the Design Process – Part 2

Introduction to the concepts of accessibility in designs We live in the height of the digital age, where the digital...

15 January 2024 19 min read

Other Development

Goodness Woke in Other Development

Software optimization: leveraging algorithms for optimized performance/search.

Software optimization refers to the process of improving the performance, efficiency, and resource utilization of a software application. It involves...

11 January 2024 19 min read

Blogs

Dennes Torres in Blogs

Semantic Model: More than a Simple Name Change

The animation on the top of this article tries to track the evolution of the enterprise architecture since SQL Server...

10 January 2024 3 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

PowerShell

Laerte Junior in PowerShell

PowerShell Dynamic Parameters and SQL Server

Have you ever been in a situation that you want to call a cmdlet or a function with a parameter...

05 January 2024 6 min read

Blogs

Louis Davidson in Blogs

Being A Bit Less Comfortable in 2024

I hate coming up with ideas for editorials, but my last editorial of the year gives me a very simple...

03 January 2024 3 min read

T-SQL Programming

Itzik Ben-Gan in T-SQL Programming

Two-Dimensional Interval Packing Challenge

Packing intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective continuous intervals. In...

02 January 2024 17 min read

Ben Johnston in Blogs

Warehouse Load Patterns – Part 2 – Load Patterns

This continues and finishes my two-part series on warehouse load patterns. There are many methods to transfer rows between systems...

31 December 2023 29 min read

Other Development

Chisom Kanu in Other Development

Understanding the Importance of Data Lineage in Modern Data Management

Data lineage is a component of modern data management that helps organizations understand the origins, transformations, and movement of their...

28 December 2023 22 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

Register for Simple Talk

Articles

State of the Database Landscape Results 2024

Querying MongoDB Documents

The Importance of Retention

Fabric and Self-Service: Control who can use

Working on Technology Off the Clock

Making Accessibility Part of the Design Process – Part 2

Software optimization: leveraging algorithms for optimized performance/search.

Semantic Model: More than a Simple Name Change

Optimized locking in Azure SQL Database

PowerShell Dynamic Parameters and SQL Server

Being A Bit Less Comfortable in 2024

Two-Dimensional Interval Packing Challenge

Warehouse Load Patterns – Part 2 – Load Patterns

Understanding the Importance of Data Lineage in Modern Data Management

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