Attention users running SQL Server 2008 and 2008 R2!

This is a bit of a piggy back post but I find the information very important and should be publicized far and wide. Complete credit for finding this information goes to Aaron Bertrand. His blog post is located here. The…

SQL Server 2014 CTP1 Product Guide

SQL Server 2014 CTP1 Product Guide

SQL Server 2014 CTP1 Product Guide has been released. List of Inclusions White papers SQL Server 2014 Mission Critical Performance SQL Server 2014 Faster Insights from Any Data SQL Server 2014 Platform for Hybrid Cloud SQL Server 2014 In-Memory OLTP…

Misleading Merge Replication Error – Msg 14052

Recently I blogged about two methods to repair transactional replication. Transactional Replication – Fixed in Minutes Today I was attempting to apply the same concept as method #2 (which is from Edward Polley’s – Super Fast Transactional Replication Repair – article) when…

Cumulative Update #4 for SQL Server 2012 SP1

May Updates for SQL Server Cumulative Update #4 for SQL Server 2012 SP1 is now available. KB Article: KB #2833645. Build Number is 11.0.3368. Applicable to @@VERSION 11.0.3000 through 11.0.3367. Release announcement from blogs.msdn.com.

Querying Central Management Servers

SQL Server Central Management Servers have a number of great features such as, policy enforcement, spawning group connection query windows, and organizing your list of servers. The server list is what I wanted to talk about today. I find this…

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…