Editorial: Automation

Often I find myself thinking to myself, “if only I had one more DBA.” I’m sure we’ve all said this often enough and probably not just to ourselves, I’m sure the boss gets an ear full every now and again. But,…

Running SSIS Packages in 32-bit

Explanation of the issue Many of our servers run the 64-bit version of SQL Server and Integration Services and use components and /or providers that require 32-bit execution. There are several articles and blog / forum posts that address the…

September Updates – SQL Server 2008 SP3 CU #13 and 2012 SP1 CU #6

SQL Server 2012 SP1 Cumulative Update #6 is now available. KB Article: KB #2874879. Build Number is 11.0.3381. Applicable to @@VERSION 11.0.3000 through 11.0.3380. SQL Server 2008 SP3 Cumulative Update #13 is now available. KB Article: KB #2880350. Build Number is 10.00.5846….

Creating Logins and Users – Why I can’t connect

If you have ever used database projects with SSDT I’m sure you’ve experienced a situation where that user you just created yesterday is suddenly complaining to you that they can no longer access the database. Often this is because SSDT…

SQL Server 2012 RTM Cumulative Update 9

SQL Server 2012 RTM Cumulative Update 9

SQL Server 2012 RTM Cumulative Update #9 is now available. KB Article: KB #2867319. Build Number is 11.0.2419. Applicable to @@VERSION 11.0.2100 through 11.0.2410.

July SQL Server Updates

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…

Upgrading SQL Server with Replication

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…

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…