What started as a simple recommendation turned into a comprehensive benchmarking exercise. Let us see blog post about JSON vs XML.
SQL SERVER Performance: When MAXDOP = 1 Slowed Down the Entire Business
Slow reports, slow transactions, and the internal team could not find why. In this case study, MAXDOP = 1 was quietly slowing down the entire business.
First Look at Apache Airflow 3.0: A Game-Changer in Workflow Orchestration
If you’ve spent any time wrangling data pipelines, you know that Apache Airflow is a staple in the orchestration world. Let us learn.
Automating SQL Server Deployments Across Multiple Databases Using Python
Let us learn about Automating SQL Server Deployments Across Multiple Databases Using Python. We have complete script in this blog.
SQL SERVER – Catching Non-SARGable Queries in Action
If you ever wondered why a query that looks harmless is performing poorly despite having indexes in place, the answer could non-SARGable queries.
SQL SERVER Performance Tuning: Catching Key Lookup in Action
In this blog post, we’ll explore what a Key Lookup is, how to spot it, and most importantly, how to eliminate it using a covering index.
ANSI PADDING and Storage – SQL in Sixty Seconds 210
ANSI PADDING is an often-overlooked yet impactful setting in SQL Server that determines how trailing spaces are handled in CHAR and VARCHAR.