How to: Configure SQL Server 2012 AlwaysOn – Part 3 of 7

How to: Configure SQL Server 2012 AlwaysOn – Part 3 of 7

How to: Configure SQL Server 2012 AlwaysOn Enabling the AlwaysOn Feature Quick post on how to enable the AlwaysOn feature at the database instance level. This needs to be accomplished for each instance involved in the architecture. In our target…

sp_Blitz v18 – Lots of Bug Fixes

Brent Ozar’s sp_Blitz v18 has been released. For those of you unfamiliar with sp_blitz I highly recommend not only downloading it but also watching Brent’s video explanation and reading all of his documentation on it. sp_Blitz is a great way…

How to: Configure SQL Server 2012 AlwaysOn – Part 2 of 7

How to: Configure SQL Server 2012 AlwaysOn – Part 2 of 7

How to: Configure SQL Server 2012 AlwaysOn Building the Environment When building our environment there is an assumption of basic familiarity with Windows Failover Clustering. The following will begin with a Windows Failover Cluster configured with 2 nodes, a shared…

Set Windows Failover Cluster Timeout Thresholds

Purpose: When dealing with a single site the default Windows Failover Cluster timeout settings have always done a good job for me but, once you branch out into multiple geographic sites, maintaining clusters across those sites often requires tweaking these…

How to: Configure SQL Server 2012 AlwaysOn – Part 1 of 7

How to: Configure SQL Server 2012 AlwaysOn – Part 1 of 7

How to: Configure SQL Server 2012 AlwaysOn Scope and Architecture This is the first post in a series to provide step-by-step instructions on how to setup and configure a SQL Server 2012 AlwaysOn in a dual data-center Windows clustered environment…

Tell Microsoft we want UPN

It is commonly known that when using SQL Server with Active Directory you need to utilize the DOMAIN\UserName format and that the UserName cannot be more than 20 characters. If you do use a name with more than 20 characters…

February 2013 Cumulative Updates for SQL Server 2008 R2 / 2012

SQL Server 2008 R2 Service Pack 1 Cumulative Update # 11 KB Article: KB #2812683 Build number is 10.50.2869 Applicable to @@VERSION 10.50.2500 through 10.50.2868 SQL Server 2008 R2 Service Pack 2 Cumulative Update # 5 KB Article: KB #2797460 Build number…

Ten Free SQL Server Tools that you Need to Know About

Hello, I’m happy to see that the buzz word “Free” did not fail to attract readers. NEVER FEAR! You will not leave this post disappointed. I’m not going to try and do a better job than John Sansom has already…

Deadlocks – Querying Extended Events

Background The days of restarting SQL Service with trace flags 1204 or 1222 (MSDN Detecting and Ending Deadlocks) or being forced to start up a profiler trace are no more. Let’s face it. There are times when someone comes up…