I’ve been using Red Gate products for years and I’ve turned into a bit of a cheerleader for them. I can’t help it. They have good products.
One of the tools that I’ve been using for a while (truth told since before it was owned by Red Gate) is SQL Prompt. A new version, 3.8, has recently been released. I’ve been using for a few days now. It really is an improvement over the previous version. I haven’t done system measurements or anything, but it feels faster. It’s picked up the schema’s from the systems I normally access quite well. It failed when I put it against the SCOM data mart, but so did the prior version. There are quite a few cosmetic enhancements. Some of the pop-ups look a bit more clean to my eye but I’m not sure what they’ve changed. I was looking through the options and noticed direct support for compound keys. That may not have been added to 3.8, but it’s relatively new. Most everything else is familiar. The functionality is sweet and goes well beyond what’s available in SQL Server 2008 (although, that’s pretty nice too). The startup time seems to be a bit faster.
The big new thing comes with the Pro version, Layout. It looks like they took the layout function straight out of SQL Refactor (as a side note, I loved Refactor, but this is most of what I used it for, it might fall off my machine). The options window is pretty different, so maybe this is new code. Either way, it’s great functionality. With Prompt catching most of the keywords and formatting them correctly, a lot of the time, only laying out the code is left. A quick couple of key strokes and it walks through getting everything into the right place. Having all your code formatted the same way makes it much easier to read for coding, troubleshooting and general maintenance. This ease increases your productivity, even if only a little bit.
Another cool thing I found was that you can hover over a table or a column and a menu appears. Clicking on the objects in the menu shows a definition for that table. Pretty slick stuff.
I’m sure there’s more to it (here are the release notes), but that’s what I’ve found so far. Another win from Red Gate.