Category Archives: Tips & Tricks

Creating test data using TSQL- 4 weeks of CPU stats

To Spoof the creation of SQL creating the CPU stats for the last 4 weeks I used some useful SQL routines, the full code is linked here but the relevant sections are explained in the blog post. These are a … Continue reading

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

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

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