Category Archives: Tips & Tricks

Kerberos -The annoyance that is

This is more about how to find something than finding something if that makes sense or doesn’t. Anyway a bit of back story is probably worthwhile at this point In the beginning  There was once a server that wasn’t working … Continue reading

Posted in PowerShell, Tips & Tricks, Uncategorized | Leave a comment

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

One for the Man united fans (or not)

Always being a security conscious professional I lock my machine all the time, Yep I haven’t in the past ( and learn’t from that) as no one wants to email the infrastructure team proclaim you love them or ask one of … Continue reading

Posted in Bit of fun, Tips & Tricks | Leave a 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

Using Output

The OUTPUT command can be a very useful tool to use at times. The following scripts show a couple of ways it can be used. The code from these scripts can be found here on my shared dropbox. First off … Continue reading

Posted in Tips & Tricks, TSQL | Tagged , | Leave a comment