One of the great things about SQL Prompt is that it quickly removes the need to use so many keystrokes. That’s helpful and handy, but to become a really efficient T-SQL coder, you’ll want to practice incorporating a few tricks into your routine. Here’s a good one. Often I run into tables and can’t... Read more
We’ve just released SQL Prompt 7.2 with new SSMS 2016 support, features and fixes. If you’re new to SQL Prompt try it for free. If you already use it, just ‘check for updates’ in SQL Prompt to upgrade to the new version. For more detail on what’s new, read on. SQL Server Management Studio... Read more
During the development of SQL Prompt 7, we overhauled the snippet manager to make it more powerful and customizable. The snippet manager documentation lives here but there are some subtleties that I wanted to cover in in this post. Everyone writes SQL differently and we want SQL Prompt to work with your current workflow... Read more
I’ve been experimenting with Extended Properties, and I found myself slightly annoyed by the syntax of adding and updating Extended Properties. I decided to take advantage of SQL Prompt to store the commonly used code for adding and updating properties. Adding Properties I’m a big fan of naming the snippets the first thing that comes to... Read more
