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
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect
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
Edmonton SQLPASS Chapter – SQL Presentation on SQL Server 2014: In-Memory OLTP Engine –
Edmonton SQLPASS – Talk – SQL 2012 In-Memory OLTP Engine (HEKATON)
SQL Server Failover Cluster, Agent Services Failed to come online, Error 435.
This was a troublesome error, because there is not much information available on what is going wrong. I looked the application log, SQL Agent Error
Calgary SQLPASS Chapter – SQL Presentation on SQL Server 2014: In-Memory OLTP Engine –
Will be speaking about SQL Server 2014 In-Memory OLTP Engine @ The Calgary SQLPASS Chapter @ Microsoft Office Calgary. If your in town please register