One of my client has been fighting a very strange problem and there is not much literature on the topic, NUMA Node Imbalance. Server Configuration
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect - Engineering
Edmonton SQLPASS – Performance Troubleshooting
Edmonton SQLPASS Talk – Performance Troubleshooting
SQL Server 2016 CTP Released
Microsoft SQL Server 2016 CTP is released, you can download it form here. It looks like a promising release, there are lots of positives being
Smart Index Management
Smart Index Management is a new way to do index management, where the maintenance window constraints prevents managing all indexes every week. Goal of Project
Corruption occurs on the page of secondary replica when you change the secondary replica to unreadable
Corruption issue should be treated as critical, as if gone undetected they are difficult to recover from without data loss. The corruption can happen when
SQL Server Patches and Hotfix Notification
I often get asked, if there is an easy way to get notifications for Patches and Hotfixes for SQL Server. Generally I recommend people keep
SQL Canada (SQLCAN) 