Database DevOps with Redgate Data Tools

Sign in to queue

Description

In this episode, Robert is joined by Steve Jones and special guest host Scott Klein to discuss database DevOps. Steve shows how you can use the Redgate Data Tools (ReadyRoll Core, SQL Prompt Core and SQL Search) that are included in Visual Studio Enterprise 2017 to extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development. 

Steve also compares the migrations-driven approach of the RedGate tools compared to the state-based approach of the SQL Server Data Tools, which were featured in last week's episode

Resources:

Embed

Download

The Discussion

  • User profile image
    Jayn

    Hello,

     

    I am taking a CSIS 209 class right now and it's based on Visual Studio so my teacher told me that I can find help here to comprehend Visual Studio.

     

    Thank you

  • User profile image
    SheldonS

    I think that clone database is neat but it also raises some concerns about potentially having real PII or PCI data in a dev environment.

  • User profile image
    Richard​Macaskill

    @SheldonS: good point - you certainly need to take care. [I work for Redgate on SQL Clone].

    Some of our customers are currently delivering clone databases using PowerShell batches which also 'mask' or overwrite sensitive data at time of database delivery (not appropriate for fully protecting data; the .mdf/.ldf files could still be hacked).

    Alternatively TDE still works if you control the certificate backup/restore, or you could curate some images for provisioning by replacing sensitive data with generated. Details on both on the Redgate blog.

    Meanwhile, we're actively researching masking needs with a prototype product - search for SQL Data Mask.

    We're hoping to make masking 'ingeniously simple' with an offering in our product line very soon!

    Richard

Add Your 2 Cents