Working on a recent SQL Server merge replication project we needed to update some of the servers in a merge replication scenario without upgrading all of them. Consider a merge replication setup with a publisher, a distributor and 2 or …

For merge publications, the version of the Subscriber must not exceed the version of the Publisher Read more »

Welcome to the DataBase Corruption Challenge, this is an about weekly blog challenge where I will post a corrupt SQL Server database with some details on what happened to it. If at this point you are already a bit irked …

Introducing the DataBase Corruption Challenge (DBCC) – Week 1 Challenge Read more »

This weeks training as part of the Free SQL Training for the 70-461 certification course is now available on YouTube. This week we covered Aggregating Data and Aggregation strategies.  For more information on sessions, take a look at the Free …

TSQL Aggregation Strategies and Aggregating Data Read more »

To start with for Transparent Data Encyrption (TDE) we will need to be using Enterprise (or Developer) edition of SQL Server 2014. I am using SQL Server 2014 Enterprise Edition CTP1, which is the early release of SQL Server 2014. …

Enabling Transparent Data Encryption on SQL Server 2014 Read more »

When you look at the installed programs with SQL Server 2014 CTP1 you see the following: There is no BIDS or Visual Studio installed with CTP1 of SQL Server 2014.  After some additional research, and discovering that I didn’t miss …

No more Business Intelligence Development Studio in SQL 2014 Read more »