Service Principal Names (SPN) get used for Kerberos authentication. SQL Server require that all instances have SPNs configured, if not Kerberos authentication fails. By default
Online Index Rebuild can Cause Fragmentation
As Microsoft SQL Server PFE, I am always playing with SQL Server. I generally spend most of my time on the engine side of world;
Using SQL Server 2012 BPA in Windows 8.1
How to use SQL Server 2012 BPA in Windows 8.1
Cross-Domain Authentication for SQL Server
How to setup and configure cross domain service principal names.
Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ with SQL Server Reporting Services
How to setup Kerberos delegation to avoid anonymous logon failure messages.
AlwaysOn Availability Groups Troubleshooting Guide
“This guide helps you get started on troubleshooting some of the common issues in AlwaysOn Availability Groups and monitoring AlwaysOn Availability Groups. It is intended
SQL Canada (SQLCAN) 