Category Archives: Productivity

SQL Solutions – Part 2 bookmarks

Bookmarks combined with SQL solutions can start to give some serious power to a script library. In the previous blog post I covered creating a script library, he’s a copy of one that i created / use daily. SO i … Continue reading

Posted in Configuration, Management Studio, Productivity, Tips & Tricks | Leave a comment

Horizontal Whitespace & Vertical Select

Another demo from the June SQL Pass / SSUG presentation. Some of the lesser known features of management studio is the ability to vertically select data (see below) and also delete white space the following is an example of using these. … Continue reading

Posted in Management Studio, Productivity, Tips & Tricks | Leave a comment

SQL Solutions – Reusable script Library

SQL Server easy to build T-SQL Script library using tools that everyone already has. Continue reading

Posted in Configuration, Management Studio, Productivity, Tips & Tricks | 1 Comment

DBA / Developer Tool Set

#DBA #SQLDeveloper customisable toolset that was shown in a presentation as part of #SQLPASS Manchester / Leeds in June Continue reading

Posted in Management Studio, Productivity, Tips & Tricks, Uncategorized | Leave a comment

Excel formatting SQL results

Sometimes its the little things that get annoying like requesting some information from a DBA or a system admin at a remote site where you can’t run scripts but need someone to do it for you. Quick example you want … Continue reading

Posted in Productivity, TSQL | Leave a comment

Management Studio Solutions

I have found several times creating the same set of scripts for the same thing, trying to locate where I saved it, when did I last run it. I end up spending ages looking for some code I ran previously … Continue reading

Posted in Management Studio, Productivity | Leave a comment

Hot Key of the Week (Ctrl-ALT – down arrow)

I send around a weekly newsletter at work and one of the features is hotkey of the week which I will start posting here as well Display a popup listing all open windows, you can then use the cursor key … Continue reading

Posted in Productivity | Leave a comment