Query Optimization: Tuning Indexes for better performance.
· ☕ 23 min read
Digging into Database indexing and how to tune them for better performance.
db
Definitive guide to TSQL Error Handling
· ☕ 14 min read
I talk about handling errors effectively in T-SQL
Transaction Processing and Concurrency control in T-SQL
· ☕ 15 min read
I talk about transactions in general and in T-SQL along with concurrency control
Trigger in T-SQL - Part 1: Introduction
· ☕ 14 min read
In this part I talk about DML and DDL Triggers in T-SQL.
Triggers in T-SQL - Part 2: Limitations and Use Cases
· ☕ 9 min read
In this part, I talk about the limitation of triggers and use cases.
Triggers in T-SQL - Part 3: Managing And Optimization
· ☕ 7 min read
In this part I talk about management options of triggers and how to optimize them.