564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
|Write your queries more quickly with SQL Prompt from Redgate|
|The SQL Prompt utility from Redgate has an annual subscription cost, but on the plus side it will complete tedious joins for you (among many other things).|
This blog explains what the SQL Prompt add-in is and does, so that you can decide for yourself whether to install it.
Thanks to Nathan from ista Energy Solutions for bringing this to my attention (although when I excitedly told the other Andrew in the office about my discovery he pointed out that this tool has been around for many years!).
If (like me) you spend much of your working life writing SQL queries, you'll appreciate anything which can make the task quicker. Imagine a tool which suggested tables for you, and showed you their columns:
You can click on any table in the suggestion list to see the columns it contains.
Above all, imagine that it suggested possible joins for you:
I get so bored of typing joins - I love this idea!
At any time you can press Alt + S to bring up a list of possible commands (in alphabetical order):
Just one of the many extra commands that you can run.
You can install a free 28-day trial of SQL Toolbelt (of which SQL Prompt is a part) from the Redgate site:
There are many more tools in the toolbelt than just SQL Prompt, but this was the one I was interested in.
After downloading the software and choosing what you want to install, you can then activate your trial:
Refreshingly, you don't need to create an account or type in any credit card information to start a trial.
You then see this message:
When you start up SQL Server Management Studio you'll now be asked whether you want to invoke SQL Prompt.
At £894 per user per year SQL Toolkit is not cheap, but you can just take out a licence to use SQL Prompt:
Whether you think it's worth spending nearly £150 to save yourself some typing is up to you!
And with that, I will now uninstall SQL Prompt, since I need a clean copy of SSMS for displaying on training courses!
25 Aytoun Street