BI

Fabriano Richard in BI

PowerBI premium capacity administration: dataset monitoring and tuning

Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its...

13 May 2024 12 min read

Koen Verbeeck in BI

How to Build Metadata Driven Pipelines in Microsoft Fabric

Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined software engineering approach....

06 May 2024 11 min read

Robert Sheldon in MongoDB

Updating Documents in MongoDB

In the previous articles this series, I demonstrated various ways to retrieve document data from a MongoDB database, using both...

29 April 2024 21 min read

PostgreSQL

Ryan Booz in PostgreSQL

Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3

The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – taking raw input...

22 April 2024 15 min read

Ben Johnston in Databases

How to build a data culture: the 8 technical pillars that make it work

Building a data culture takes more than good intentions. Here are the technical pillars — from data discoverability to error...

19 April 2024 13 min read

Theory and design

Phil Factor in Theory and design

Database Subsetting and Data Extraction

Let’s start by defining a subset and why you would require a data subset? When dealing with the development, testing...

17 April 2024 11 min read

T-SQL Programming

Aaron Bertrand in T-SQL Programming

Snake draft sorting in SQL Server, part 2

Part of a series: [ Part 1 | Part 2 | Part 3 | Part 4 ] In my previous...

15 April 2024 7 min read

T-SQL Programming

Aaron Bertrand in T-SQL Programming

Snake Draft Sorting in SQL Server: Distributing Workloads Evenly (Part 1)

Snake draft sorting in SQL Server divides processing tasks into evenly-distributed groups by assigning work in a serpentine order. Part...

12 April 2024 9 min read

BI

Dennes Torres in BI

Fabric and Azure SQL in a few clicks: Mirroring a Database

Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for CosmoDB and Snowflake...

12 April 2024 11 min read

PostgreSQL

Ryan Booz in PostgreSQL

Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2

In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in ingesting and transforming...

08 April 2024 13 min read

Editorials

Louis Davidson in Editorials

Giving Feedback on Microsoft Data Platform Tools

As a data professional, there is a set of tools that you use on pretty much a daily basis. Before...

08 April 2024 3 min read

Robert Sheldon in MongoDB

Building MongoDB Aggregations in MongoDB Compass

In the previous article in this series, I demonstrated how to build and run an aggregate statement in MongoDB Shell....

02 April 2024 22 min read

Theory and design

Joe Celko in Theory and design

SQL Logic

In this article, I will discuss the history and thinking behind several types of logic that are typically associated with...

29 March 2024 13 min read

T-SQL Programming

Aaron Bertrand in T-SQL Programming

SQL Server Pagination Performance: Sorting by Large Text Columns

SQL Server OFFSET-FETCH pagination becomes extremely slow when sorting by large text columns (varchar(max), nvarchar(max)). Learn to fix it using...

25 March 2024 9 min read

Theory and design

Joe Celko in Theory and design

Department of Redundancy Department

Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too...

18 March 2024 12 min read

PostgreSQL

Ryan Booz in PostgreSQL

Transforming and Analyzing Data in PostgreSQL

In our data hungry world, knowing how to effectively load and transform data from various sources is a highly valued...

12 March 2024 20 min read

Database Administration

Aaron Bertrand in Database Administration

Get the most out of SQL Server Agent logs

If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on SQL Server Agent...

11 March 2024 6 min read

Robert Sheldon in MongoDB

Building MongoDB Aggregations

In the previous article in this series, I discussed how to use a find statement to retrieve data from a...

01 March 2024 20 min read

Ben Johnston in SQL Server

Batch Delete in SQL Server: Six Patterns for Large-Scale DELETE Operations

Six practical T-SQL patterns for deleting large numbers of rows in SQL Server without locking tables, blocking users, or growing...

01 March 2024 25 min read

T-SQL Programming

Edward Pollack in T-SQL Programming

Find and Replace Text in Strings in T-SQL

String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts to normalize databases,...

29 February 2024 17 min read