2025-07-18
6,144 reads
Articles
When INCLUDE Columns Quietly Inflate Your Transaction Logs
In this article, I wanted to test a common assumption we DBAs make – that adding INCLUDE columns to indexes is harmless. I created a FULL recovery test database with a realistic wide Orders table containing extra large VARCHAR columns to simulate an ERP workload. I ran updates and measured transaction log backup sizes before and after adding INCLUDE columns to a nonclustered index. The results shocked me. The update without INCLUDE columns generated a 10 MB log backup, while the same update with INCLUDE columns produced over 170 MB – a 17x increase in log volume. I explain why this happens: INCLUDE columns are physically stored in index leaf rows, so updates affecting them write bigger log records. I also clarify that updating key columns generates even more log than INCLUDE updates because it involves row movement (delete + insert), but INCLUDE updates still cost more log than if those columns weren’t indexed at all. The takeaway is clear – INCLUDE columns are powerful, but they silently increase transaction log generation, impacting backup sizes, replication lag, and DR readiness. Always measure their real cost before deploying to production.
2025-07-18
729 reads
Getting In: Running External Code in a Locked-Down PaaS
In Part 1, I explored how to bend SQL Server Agent to our will and peek under the hood of Azure SQL Managed Instance (SQL MI), gaining full OS access to the container (all without relying on xp_cmdshell). But once I realized what kind of door I'd opened, curiosity pushed us further, tempting us to […]
2025-07-17 (first published: 2025-07-16)
484 reads
Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration Dimension
In this next article, we look at creating balanced dimensions on demand.
2025-07-16
724 reads
Cassandra Springboot Integration With Redis
Article Overview In this article we will learn how to integrate a Spring boot application with Apache Cassandra database and Redis cache. This is an extension to one of our previous articles which demonstrates the steps to set up Apache Cassandra and how to integrate is with Springboot, link shared below. https://www.sqlservercentral.com/articles/cassandra-springboot-integration In this tutorial […]
2025-07-14 (first published: 2024-07-18)
68 reads
SQL Server 2022 Clusterless Distributed Availability Group
This article shows the final step of an availability group creation, specifically for a distributed clusterless one.
2025-07-14
5,041 reads
Revolutionizing Efficiency: The Power of Custom Automation Software Development
With the ever-increasing pace of the digital era, companies are continuously looking for opportunities to enhance efficiency, cut costs, and optimize operations. The most viable way to accomplish these is through Custom Automation Software Development.
2025-07-11
480 reads
SQL Server and AI: Integrating Machine Learning Services
Get a quick glimpse of using AI in SQL Server by implementing a machine learning system.
2025-07-11
3,048 reads
Cloning Master Admin User Permissions in Amazon RDS for SQL Server with Fine-Grained Control
This article explores how to securely clone the master user permissions in Amazon RDS for SQL Server using a custom stored procedure, usp_rds_clone_login. It outlines a step-by-step process to generate, review, and apply a script that replicates server- and database-level access from the master user to a new login without directly exposing elevated credentials. The guide emphasizes the principle of least privilege, supports named account management, and enables transparent, auditable permission handling for DBAs and applications. Designed for secure and scalable environments, this solution enhances operational security while maintaining administrative flexibility in Amazon RDS.
2025-07-09
1,016 reads
PostgreSQL Aggregate Functions
Overview In this article we will go through the various in built aggregate functions available in PostgreSQL. Aggregate functions perform a calculation on a set of rows and return a single value. COUNT Function The COUNT function is a simple and very useful function in counting the number of records, which are expected to be […]
2025-07-09
470 reads
Blogs
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Changing the Owner Removes Permissions: #SQLNewBlogger
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
T-SQL Tuesday #200 - I Bet It's Bad if I See...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Developer edition cannot connect from other computers
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Comments posted to this topic are about the item How Clustering can be Used...
Moving the Error Log
Comments posted to this topic are about the item Moving the Error Log
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers