Tag Archives: SQL Prompt

A New Command Palette in SQL Prompt

I’ve gotten used to using the Command Palette in VS Code/ADS/Sublime Text regularly to find some setting or change something. What felt strange at first has become a habit for me. I actually like having this one place to search … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Summarizing a Script with SQL Prompt

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

Quick NoLock with SQL Prompt

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

Color Coding a Database on All Servers with SQL Prompt

SQL Prompt has some nice color coding features, but sometimes I want a database to keep the same color, regardless of instance. I don’t know that I’d recommend this, but since I work in demo environments across versions, this is … Continue reading

Posted in Blog | Tagged , , | Comments Off on Color Coding a Database on All Servers with SQL Prompt