We have MSDN article [Tutorial: Listener Configuration for AlwaysOn Availability Groups ( http://msdn.microsoft.com/en-us/library/dn425027.aspx ) which provides detailed steps to configure AlwaysOn listener on Azure VM cluster. This article provides steps ...read more

When working with SQL Server Analysis Services, it is not uncommon to see this error message "An unexpected exception occurred". This is the most misunderstood message in SSAS. If you try to search this particular error message, you can get ...read more

There are numerous articles outlining how spinlocks work so I won’t cover the details in this post.   Instead, I want to focus on the spinlockbackoffs value recorded in the sp_server_diagnostics output. Component = System <system spinlockBackoffs ...read more

  When you are auditing successful logins attempts using SUCCESSFUL_LOGIN_GROUP action group through SQL Audit, you will see that there will be too many entries in the audit file. You may see this behavior for successful logins when connections are ...read more