DBCC CLONEDATABASE Cannot insert duplicate key Error

If you’ve been using DBCC CLONEDATABASE at all, you might have run into a cannot insert duplicate key error (or something similar) when trying to clone a database: Database cloning for ‘YourDatabase’ has started with target as ‘COPY_YourDatabase’. Msg 2601, Level 14, State 1, Line 1 Cannot insert duplicate key row in object ‘sys.sysschobjs’ with […]

PASS Summit Pre-Con on Query Store

PASS has announced the pre-cons for this year’s Summit and I am *thrilled* to have the opportunity to present one centered around Query Store! This is a topic I’ve been presenting on since before SQL Server 2016 was released in June last year.  I’m ridiculously excited about it.  I’m already developing new content and demos […]