Essential for developments of all shapes & sizes

  • SQL Server 2008 MCM Readiness Videos

    The other day I was doing some research on the Transaction Log of SQL Server and stumbled upon the MS SQL Server MCM Readiness videos, many of which are made by Paul Randal. After watching just one of these videos I quickly found out how useful they can be for general knowledge, even if you […]

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

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

    How to: Configure SQL Server 2012 AlwaysOn Setting up an Availability Group The AlwaysOn Availability Group is a logical group of databases that you want to fail-over to your secondary site together. It is also a Windows Cluster Resource and should always be manipulated via the AlwaysOn wizards in SSMS or via T-SQL. Microsoft explicitly states […]

  • April 2013 – Updates for SQL Server 2008 R2 / 2012

    SQL Server 2012 RTM Cumulative Update # 7 KB Article: KB #2823247 Build number is 11.0.2405 Applicable to @@VERSION 11.0.2100 through 11.0.2401 SQL Server 2008 R2 Service Pack 2 Cumulative Update # 6 KB Article: KB #2830140 Build number is 10.50.4279 Applicable to @@VERSION 10.50.4000 through 10.50.4276 SQL Server 2008 R2 Service Pack 1 Cumulative Update # […]

  • 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 architecture this will need to be accomplished once per node for the SQL Server Failover Cluster […]

  • 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 to get a fairly complete overview of a server that you might be unfamiliar with […]

  • 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 disk added to the cluster, and 1 SQL Server Failover Cluster Instance already installed in […]

  • 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 settings. NOTE: These changes are generic to any cluster but they are most notably used […]

  • 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 using shared storage in multiple subnets. When I say, step-by-step, what I mean is that […]

  • 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 then the name gets truncated and you are left with only a partial name. Just […]

  • 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 is 10.50.4276 Applicable to @@VERSION 10.50.4000 through 10.50.4275 SQL Server 2012 Cumulative Update #6 KB […]