Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

SQL Clone and Encryption

I’ve been testing and working with SQL Clone for the last few months, trying to help the devs at Redgate ensure this product is ready to go when it’s released. I’ve written a few pieces on this blog, and I’ve got a new one up on the Redgate blog that looks at Clone and TDE.

When I started looking at this, I assumed SQL Clone would work. After all, the product tries to ensure that a clone looks just like any other database to SQL Server. It does, and TDE just works.

I’m still looking at other features, but so far, everything works great. The clone databases are indistinguishable from normal databases, except that I can blow one away and recreate it from the image in seconds. That’s pretty cool, especially when you’ve messed up a bunch of data while writing code that wasn’t quite production ready.

I’m looking forward to seeing how others use SQL Clone and how this will help ensure developers work with larger, known data sets, in their own sandboxes. Perhaps we’ll finally get rid of the shared database and developers’ work unnecessarily impacting their teammates.


Filed under: Blog Tagged: Redgate, SQL Clone, syndicated

Comments

Leave a comment on the original post [voiceofthedba.com, opens in a new window]

Loading comments...