Alerts or Spam – Which do you receive?

As a database administrator it is our jobs to maintain healthy database servers. So what does that really mean? Well, unfortunately, everything. We must respond to and fix existing issues. We must notice issues, usually in the form of alert…

Transactional Replication – Fixed in Minutes

Any of us who have been responsible for managing transactional replication knows that bad commands are possible and do happen. So, we have a less than perfect solution which requires DBA intervention to correct certain problems. So what do we…

sp_Blitz the APP!

I find myself a little wrapped up with Brent Ozar’s sp_Blitz. I’m not sure if I’ve hit the point of infatuation yet but I this will be my fourth post regarding this one stored procedure. Temporary Stored Procedures Ten Free…

Cumulative Update #11 for SQL Server 2008 SP3

May Updates for SQL Server Cumulative Update #11 for SQL Server 2008 SP3 is now available. KB Article: KB #2834048. Build Number is 10.00.5840. Applicable to @@VERSION 10.00.5500 through 10.00.5435. Release announcement from blogs.msdn.com.

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

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

How to: Configure SQL Server 2012 AlwaysOn Using the Availability Group Listener In this, final, section of the AlwaysOn blog series I will be explaining the Availability Group (AG) listener and how it can be used to off-load some server…

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

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

How to: Configure SQL Server 2012 AlwaysOn How to: Fail-over In this part of the blog series we will go over the various methods of manually failing over an Availability Group. Naturally if you are using automatic fail-over then there…

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

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

How to: Configure SQL Server 2012 AlwaysOn Explanation of Components Now that we have our AlwaysOn configuration setup I’d like to go over some of the components. Some are very self explanatory such as the Availability Replicas, Databases, and Group…

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…

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…

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…