Matt Gantz in Databases How to Monitor and Optimize Batched Deletion Processes in SQL Server Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, but poorly tuned... 19 November 2025 9 min read
Lee Asher in Databases 5 Strategies to Refactor SQL Code Struggling with messy SQL queries? Discover 5 smart refactoring strategies to clean up your code, boost performance, and simplify maintenance.… 12 November 2025 17 min read
Fabiano Amorim in Security and Compliance SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data A SQL Server DBaaS privilege bypass exposed system tables and vendor-protected code on AWS, GCP, and Alibaba. This explains the... 05 November 2025 31 min read
Chandan Shukla in SQL Server IoT Meets OLTP: How to Handle Backfilling Challenges in Real-Time Systems Learn how IoT backfilling impacts OLTP systems and discover strategies to optimize performance for real-time data processing.… 23 September 2025 19 min read
Lee Asher in SQL Server Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples Discover how the FULL OUTER JOIN in SQL can simplify queries, improve performance, and solve real-world data problems with practical... 26 August 2025 12 min read
Lukas Vileikis in MySQL MySQL Index Overviews: PRIMARY KEY Indexes Learn how to use PRIMARY KEY indexes in MySQL - a type of B-tree index designed to help a database... 15 August 2025 16 min read
Joe Celko in SQL Server Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices Learn how to use SQL VIEWs effectively with practical examples, syntax breakdowns, and expert tips for recursive, union, and updatable... 05 August 2025 10 min read
Edward Pollack in Featured How to Increase SQL Server Column Width Without IO (Input/Output) Overhead One of the most hassle-prone changes that can be made in a SQL Server database is to widen an existing... 28 July 2025 14 min read
Matt Gantz in SQL Server How to Measure Replication Latency in SQL Server AlwaysOn Synchronous Availability Groups Learn how to measure replication latency in SQL Server AlwaysOn synchronous availability groups using performance counters and DMVs for better... 25 July 2025 8 min read
Robert Sheldon in PostgreSQL How to use pgAdmin with Azure Database for PostgreSQL flexible server Learn how to connect and manage Azure PostgreSQL Flexible Server using pgAdmin, a powerful GUI tool for PostgreSQL.… 23 July 2025 17 min read
Edward Pollack in Featured How to Use the New PRODUCT() Function in SQL Server 2025 Learn how the new PRODUCT() function in SQL Server 2025 simplifies multiplicative aggregation. See examples, performance tips, and use cases.… 21 July 2025 8 min read
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
Koen Verbeeck in General Analytics How to Script Dimensions with data build tool (dbt) Macros Learn how to script dimensions with data build tool (dbt) Macros, with this detailed follow-along guide.… 16 July 2025 9 min read
Edward Pollack in Featured Using Regular Expressions (Regex) in SQL Server 2025: A Complete Guide Everything you need to know about Regular Expressions (Regex) in SQL Server 2025 - learn what it is, how to... 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
Ben Johnston in Blogs Managed Instance Gotchas – Error Conditions I was recently on a project to migrate a very transactional installation of SQL Server to Azure SQL Managed Instance... 31 March 2025 9 min read
Dennes Torres in Blogs 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
Ben Johnston in Blogs Writing an Efficient Query SQL is easy to start writing. The basic syntax to start returning data is very simple. This low threshold for... 19 October 2024 20 min read
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
Blogs Dennes Torres in Blogs What’s new in T-SQL in SQL Server 2022 There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a few as well... 04 July 2022 8 min read
