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
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
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
NoSQL Robert Sheldon in NoSQL 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 Pagination and ordering by large values Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on Amazon, or browsing... 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
NoSQL Robert Sheldon in NoSQL 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
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
Database Administration 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