SQL Server Memory-Optimized Tables: Speed Up Slow Queries and Stop Disk Bottlenecks
Rakesh Kishore
Command Palette
Search for a command to run...
Archive
53 posts published so far
Optimizing AlwaysOn Availability Groups: Diagnosing Data Synchronization Lag and REDO Bottlenecks
Rakesh Kishore
Managing Parameter Sniffing: Overcoming the Silent Execution Plan Saboteur
Rakesh Kishore
Navigating Memory Architecture: Buffer Pool Tracking, Clerks, and Plan Cache Eviction
Rakesh Kishore
Cracking Deadlocks: Isolation Levels and Concurrency Architecture
Rakesh Kishore
Scaling Large Datasets: Table Partitioning Architecture and Sliding Window Purges
Rakesh Kishore
Designing High-Performance Indexes: Composite Keys, Included Columns, and Mitigating Key Lookups
Rakesh Kishore
Optimizing Transaction Log Architecture: Mitigating Runaway LDF Files and VLF Fragmentation
Rakesh Kishore
Migrating On-Premises SQL to Azure: Choosing Between VM, MI, and SQL Database
Rakesh Kishore
Query Store Architecture: The Flight Data Recorder for SQL Server
Rakesh Kishore
Maintaining Engine Health: Triage Index Fragmentation and Outdated Statistics
Rakesh Kishore
Mastering Execution Plans: How to Read a Query Map
Rakesh Kishore
Catching the Slowdowns: Capturing Workloads with Extended Events
Rakesh Kishore
Eliminating TempDB Allocation Contention: A Deep Dive into GAM, SGAM, and PFS Page Wars
Rakesh Kishore
Diagnosing SQL Server Always On Failovers: Error 1135 and VM Stuns
Rakesh Kishore
The AI-Native Engine: Vector Databases and DiskANN in SQL Server 2025
Rakesh Kishore
The Autonomous DBA: Building a "Self-Healing" Availability Group
Rakesh Kishore
Cloud Governance: How to Hunt Database Waste and Build Automation Frameworks
Rakesh Kishore
Azure SQL MI Architecture: Triaging Cloud Synchronization and Redo Lag
Rakesh Kishore
High Availability Blueprints: Crack the Code on AlwaysOn AGs, FCIs, and Log Shipping
Rakesh Kishore
Identity Architecture: Demystifying SQL Server Logins vs. Database Users
Rakesh Kishore
The Recovery Chain: Deep-Diving SQL Server Recovery Models and Backup Types
Rakesh Kishore
The Backup Sentinel: Implementing Exception-Driven Fault Tolerance in SQL Server
Rakesh Kishore
Inside the B-Tree: How Page Splits and Fragmentation Melt Storage I/O
Rakesh Kishore
Demystifying SQL Server Concurrency: Locks, Latches, and the Shift to RCSI
Rakesh Kishore