When SQL Server executes a query in parallel, CPU threads often share the workload unevenly. Some handle a significant portion of the rows, while others manage much less.
Warm Holiday Wishes and Learning Opportunities! 🎄✨
I want to take a moment to extend my heartfelt wishes for a wonderful season and an even better year ahead. I have some learning opportunities for everyone in this blog post.Â
Apache Spark and Airflow in Action : My Experience
Recently, I’ve been working with a large client where we’re diving deep into Apache Spark and Apache Airflow. Let us learn!
SQL Server Performance Tuning in the Age of AI: An Expert’s Tale
My job? To figure out what went wrong and fix it. Let us talk about SQL Server Performance Tuning in the Age of AI.
SQL SERVER – Understanding WITH RECOMPILE in Stored Procedures
The culprit? Parameter sniffing. The solution? You guessed it: WITH RECOMPILE. Comprehensive Database Performance Health Check
SQL SERVER – Implementing Row-Level Security (RLS)
Row-Level Security (RLS) in SQL Server enables fine-grained control over data access, ensuring users can only view or modify rows pertinent to their roles or responsibilities.
SQL SERVER – Dynamic Data Masking (DDM) Introduction
Dynamic Data Masking (DDM) in SQL Server is a feature that helps protect sensitive data by masking it from unauthorized users.