Edward Pollack in Featured SQL Server 2025 PRODUCT() Function: Multiply Values in T-SQL Learn the new PRODUCT() aggregate function in SQL Server 2025 - multiply values across rows like SUM() adds them. Covers... 21 July 2025 9 min read 21
Lee Asher in Python Incrementally Loading Data into Parquet with Python In this article, we'll introduce the Parquet format, explain some strategies for incrementally updating a Parquet repository, and, with a... 17 July 2025 14 min read 1
Koen Verbeeck in General Analytics Scripting Dimension Tables with dbt Macros: Type 1 and Type 2 SCD Patterns for Data Warehouses Building dimension tables with dbt macros - Type 1 (overwriting changes) and Type 2 (preserving history with effective dates) slowly... 16 July 2025 10 min read
Edward Pollack in Featured Regex in SQL Server 2025: All Seven REGEXP Functions Explained SQL Server 2025 adds native regex support with seven new REGEXP functions: REGEXP_LIKE, REGEXP_COUNT, REGEXP_INSTR, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_MATCHES, and REGEXP_SPLIT_TO_TABLE.... 14 July 2025 18 min read
Edward Pollack in SQL Server Columnstore Index Improvements in SQL Server 2025 Learn about the improvements to columnstore indexes in SQL Server 2025, including detailed demonstrations for each of these new changes.… 30 June 2025 11 min read 51
Ben Johnston in SQL Server A complete guide to Azure SQL Managed Instance server and database configuration options A tested reference of sp_configure, ALTER DATABASE, and tempdb options that aren't supported in Azure SQL Managed Instance -plus the... 13 May 2025 10 min read
Ben Johnston in Databases 5 key problems from a SQL Server to Azure SQL Managed Instance migration (and how to avoid them) Planning an Azure SQL Managed Instance migration? Here are five surprises a real transactional SQL Server move uncovered - and... 31 March 2025 10 min read 2
Dennes Torres in Microsoft Fabric Fabric: Query a SQL Endpoint from a Notebook Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can dig into how... 26 March 2025 5 min read 1
Ben Johnston in SQL Server SQL Server 2022 CU Updates and Error Code 0x851A0043 I’ve been working in the Azure space for the last few years and less with full server installations. Azure leaves... 18 February 2025 5 min read
Dennes Torres in Other Azure SQL Serverless: Discover What’s new and Increase Your Savings Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure SQL Serverless? The... 22 January 2025 3 min read 21
Ben Johnston in SQL Server When to enable memory-optimized tempdb metadata in SQL Server (and how to diagnose it) How to diagnose tempdb metadata latch contention in SQL Server - and decide whether enabling memory-optimized tempdb metadata is the... 08 January 2025 10 min read
Kellyn Pot'Vin-Gorman in Oracle Introduction to Oracle: Key features, architecture, and getting started with 23ai Oracle Database is a powerful enterprise RDBMS built for scalability, security, and high availability. Learn its architecture, key features, and... 05 December 2024 12 min read 211
Ben Johnston in SQL Server How to write an efficient SQL query: practical guidelines for faster, lighter queries Practical guidelines for writing efficient SQL queries: sargable predicates, set-based operations, index candidates, and how to read a query plan.… 19 October 2024 21 min read 3
Chisom Kanu in Development EsProc SPL and SQL: Complementary, But Different, Technologies Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your every desire? Have... 26 August 2024 23 min read 1
Ben Johnston in SQL Server How to master a database configuration audit in SQL Server: a complete guide A SQL Server database configuration audit is where most issues are found — from compatibility levels and file locations, to... 20 August 2024 16 min read
Ben Johnston in SQL Server SQL Server Configuration Audit: Complete Checklist and T-SQL Scripts Complete SQL Server configuration audit checklist with T-SQL scripts: edition and patch level, file locations, sp_configure settings, logon triggers, login... 25 July 2024 22 min read 1
Ben Johnston in SQL Server How to successfully execute a SQL Server hardware audit (complete guide) Learn how to audit SQL Server hardware and Azure cloud configuration — covering CPU, memory, storage, OS version, and backups... 17 July 2024 14 min read
Ben Johnston in SQL Server SQL Server Audit Checklist: Discovery & Setup Audit SQL Server with a structured discovery checklist. Covers server configuration, disk and memory, backups, security, database settings, and code... 06 June 2024 30 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
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
