Tag: sql 2016

DBCC Clonedatabase and Very Large Databases

Post author By jdanton1
Post date January 18, 2017
No Comments on DBCC Clonedatabase and Very Large Databases

One of the recent feature introductions to SQL Server is dbcc clonedatabase, a feature that lets you create a “data-less” clone of you database. All of the statistics and objects come into your cloned database, however none of the data does. This is perfect for development or performance tuning exercises, where you want all the […]

Does In-Memory OLTP Work with Always Encrypted? (AKA That time Bob Ward asked us a question)

Post author By jdanton1
Post date October 31, 2016
No Comments on Does In-Memory OLTP Work with Always Encrypted? (AKA That time Bob Ward asked us a question)

Last week was the PASS Summit, which is the biggest confab of SQL Server professionals on the planet (and educational as ever), Denny Cherry (b|t) and I ran into Bob Ward (b|t) of Microsoft and of 500 level internals presentations. And for the first time ever, Bob asked us a question about SQL Server—of course […]