July Updates for SQL Server SQL Server 2012 Service Pack 1 Cumulative Update #5 is now available. KB Article: KB #2861107. Build Number is 11.0.3373. Applicable to @@VERSION 11.0.3000 through 11.0.3372. SQL Server 2008 SP3 Cumulative Update #12 is now available. KB Article: KB…

Recently I had to create an upgrade plan for a company with 50+ SQL Servers with replication, both transactional and merge, spider-webbed between most of them. In the past I’ve upgraded SQL Server with the replication feature and it was…

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…

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…

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.

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…

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…

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…