Tag Archives: Redgate

Summarizing a Script with SQL Prompt

Posted on March 17, 2021 by way0utwest

I have never used this feature, but someone was asking for feedback on Prompt, and I noticed  this in the menu: Summarize script. I had guessed that it might look at the code and give me some outline, which is … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Summarizing a Script with SQL Prompt

Rebuilding SQL Saturday–Picking a Board of Directors

Posted on March 15, 2021 by way0utwest

With Redgate planning to donating the SQL Saturday brand, trademarks, and domain to a non-profit foundation, there is a need to build a group of individuals to voluntarily manage the organization. Redgate has tasked me with the initial work, and as … Continue reading →

Posted in Blog | Tagged , , , | 18 Comments

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