Posts

Showing posts from October, 2017

sp_QueryShortcuts - setup and how to use them

Image
Weather you're a DBA or Developer this set of shortcuts for SQL Server Management Studio will make your life hell of a lot easier. It will take you some time to get used to them but once you do it will be worth it, I can't imagine working without those anymore. Project was inspired years ago when i saw a similar usage of a stored procedure in SSMS query shortcuts. It was used for a specific database and wasn't very flexible, so i decided to pick it up and work on it, improve it and make it more accommodating and user friendly, so that anyone can use it anywhere. I would appreciate some feedback and constructive criticism that would help improving sp_QueryShortcuts. Download Latest version of the script always available  HERE Setup First thing that we have to do is go to our SQL Server Management Studio studio options and assign sp_QueryShortcuts stored procedure to each shortcut. Steps: Go to Tools // Options   Then Environment // Keyboard // Query Shortcut...