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… Read More »For merge publications, the version of the Subscriber must not exceed the version of the Publisher
The Service Pack 2 release of SQL Server 2014 introduces a new DBCC command called DBCC CloneDatabase. Books online states: “DBCC CLONEDATABASE should be used… Read More »DBCC CloneDatabase
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 by my use of capitalization in the DataBase Corruption Challenge, and the acronym of DBCC that I have used to describe it, then you are already ahead of many people reading about this challenge. Welcome to the challenge.
The challenge will be to download the corrupt database and attempt to recover it. If you can recover it, please send me the steps to recover it, along with some proof that the database has been recovered. The goal each week will be the following:
Read More »Introducing the DataBase Corruption Challenge (DBCC) – Week 1 Challenge
Using the GO commend in TSQL to run a batch of code multiple times is something that I commonly do in demo’s and training’s. What amazes… Read More »Executing a TSQL batch multiple times using GO
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… Read More »TSQL Aggregation Strategies and Aggregating Data
I have been asked to help a development team with training so that they can all take and pass the SQL Queries 70-461 Microsoft certification. After… Read More »Free SQL Server Training
With SQL Server 2014, there was a new compatibility level introduced, level 120 the new SQL Server 2014 Compatibility Level. SQL Server can run in a… Read More »SQL Server 2014 Compatibility Level
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… Read More »Enabling Transparent Data Encryption on SQL Server 2014
Hekaton is also known as SQL Server In-Memory database, touted to accelerate transaction throughput up to 30x performance increases on existing hardware. With a new latch-free… Read More »What is Hekaton
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… Read More »No more Business Intelligence Development Studio in SQL 2014