Tag Archives: Redgate

Quick NoLock with SQL Prompt

Posted on March 10, 2021 by way0utwest

First, please, please, please, avoid NoLock. You can lose data, or get strange results, as Jason Strate demonstrates (blog | video). Before you read further or try this, read his post and look at Kendra’s video. I had a customer … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Quick NoLock with SQL Prompt

Using Data Compare with Recent Data Only

Posted on February 8, 2021 by way0utwest

This is a post that looks at how to compare data changes in recent data. A customer recently asked me about looking at a table, and choosing specific data to compare. In this case, the data they were looking to … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Continuously Classify and Protect Your Senstive Data

Posted on February 8, 2021 by way0utwest

Abstract: Many data breaches come about from less secured development and test databases. Redgate has integrated SQL Data Catalog and Data Masker to allow you to continuously improve your classification and protection process for those environments. In this session Steve … Continue reading →

Posted in Presentations | Tagged , | Comments Off on Continuously Classify and Protect Your Senstive Data

Recovering Data from a Backup with SQL Data Compare

Posted on January 25, 2021 by way0utwest

I had a customer recently ask about how to recover data from a backup file. I believe the request was for SQL Backup, but I knew there was another way, and I suggested SQL Data Compare. We used to have … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Recovering Data from a Backup with SQL Data Compare