DBCC CLONEDATABASE issue: Duplicate key row in sys.sysschobjs

I ran into this error recently while trying to clone a production database:
Msg 2601, Level 14, State 1, LineNumber

Cannot insert duplicate...

Create a slipstream installer for SQL Server on Windows

Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL...

Data Classification in SQL Server 2019

One of the areas that Redgate is working on is making data classification easier. Microsoft added some capabilities to SSMS...

Exceeding My Own Expectations in Life!

Wow! The last five years of my career have been amazing. I went from attending a SQLSaturday a couple of...

Keeping Large Table Statistics Current -TF2371

Statistics are the magic ingredient that helps the query optimizer create its best guess for generating an execution plan. Keeping...

I’m in a book! Data Professionals at Work

A while back a friend of mine, Malathi Mahadevan (b/t), asked me if I’d like to do an interview for...

Three ways a virtual Database Administrator (vDBA) could be just what your business needs

How often have you felt like you need an extra pair of hands? When you’re planning a party? Maybe. When...

Whirlwind Tour of Azure SQL Database

I have finally uploaded my Azure SQL Database presentation, apologies for the delay. I am already working on an improved...

Webinar: The end of support for SQL Server 2008

Coeo is a partner with Redgate Software. Tomorrow they are hosting a webinar on what your position will be if...

Better Keyboard Extensions in Azure Data Studio

I used to use ALT+X to execute queries in SSMS. I spent years with this shortcut, but as I started...