Let us learn about Automating SQL Server Deployments Across Multiple Databases Using Python. We have complete script in this blog.
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 – 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.
SQL Server Ledger – Are You Really Using This Feature?
SQL Server Ledger – has taken data integrity to the next level, integrating blockchain-style data verification directly into the database.
BULK INSERT Batch Size and ROWS_PER_BATCH
Distinguish ROWS_PER_BATCH estimates from BULK INSERT commit batches, then review logging, locks, rejected rows, and atomic loading.