Database DevOps with Redgate Data Tools

Download this episode

Download Video

Download captions

Download Captions

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

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    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