Category Archives: Productivity

Data Scotland Presentation

It’s now (well) over a week since I presented at Data Scotland in Glasgow and had an amazing time, definitely one to add to the calendar for next year and Glasgow is such a vibrant city I presented a talk called … Continue reading

Posted in PowerShell, Productivity, SQL Notebooks, Tips & Tricks | Leave a comment

5 things in 5 minutes presentation- Data & Gravy

It was 2nd year attending the great data event hosted in Leeds (for those who don’t know its near Manchester and not far from Lancashire), last year I did a full hour presentation. This year I wasn’t as organised submitting … Continue reading

Posted in PowerShell, Productivity, SQL Notebooks, Tips & Tricks, TSQL | Tagged , , , , , , , , , , | 2 Comments

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