T-SQL Programming Aaron Bertrand in T-SQL Programming Snake draft sorting in SQL Server, part 3 Part of a series: [ Part 1 | Part 2 | Part 3 | Part 4 ] In part 2... 15 May 2024 5 min read
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
Containers and Virtualization Boemo Mmopelwa in Containers and Virtualization A Quick Guide on How to Containerize Your Application Using Docker Containerization has removed boundaries that limit developers from working on one application using different systems. Thus, boosting developer collaboration and... 10 May 2024 9 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
Web Goodness Woke in Web Headless CMS (Content Management Systems): Contrasting Git-Based and API-Based The presentation layer of a headless CMS is separated from the content management system itself, making it a backend-only system... 03 May 2024 18 min read
Phil Factor in Editorials Technology For Humanity There was a time, when I was in a team that was designing an important IT system for a multinational... 01 May 2024 3 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
Simple Talk Editor in Free Stuff Database technology learning resources Before I started as the editor of Simple Talk, I worked on SQL Server. Only. (Ok, I used Redgate’s tools... 27 April 2024 11 min read
Web Ukeje Goodness in Web Building RESTful APIs in Rust With Actix and Diesel There are many packages and tools that you can use to facilitate your API development with Rust. Rust has a... 26 April 2024 11 min read
.NET Camilo Reyes in .NET Working with IAsyncEnumerable in C# IAsyncEnumerable is a powerful interface introduced in C# 8.0 that allows you to work with sequences of data asynchronously. It... 24 April 2024 11 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 Building a Culture of Data: The Technical Aspects In the first part of this two-part series, I covered the mostly non-technical aspects of building a data culture. While... 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, part 1 Part of a series: [ Part 1 | Part 2 | Part 3 | Part 4 ] I recently had... 12 April 2024 8 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
Web Ukeje Goodness in Web How to Use Any SQL Database With Rust Rust is emerging as a frontrunner for ensuring memory safety without sacrificing performance. Its growing popularity isn’t solely based on... 11 April 2024 14 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
Ben Johnston in Culture Building a Culture of Data One of the major trends in enterprise computing, and really in enterprises themselves is an increased emphasis on data. My... 04 April 2024 19 min read
