Jonathan Allen

Jonathan Allen has been a SQL Server DBA since 1999, most enjoying performance tuning and development but also working with SSIS, SSRS to provide suitable business solutions. He is SQLSouthWest PASS Chapter Leader, blogs for Simple Talk, is a forum moderator at ask.sqlservercentral.com and is on Twitter. If you would like to find your nearest user group or just want to say hello then he would love to get an email from you.

26 September 2014
26 September 2014

Web page titles from URL

0
0
Nothing wholly SQL Server-related this time but this is something that I have been meaning to write for ages. While searching on the internet for content I gather loads of URLs that might be useful to me and not long after this I lose track of what content is to be found at each location. … Read more
0
0
03 September 2014
03 September 2014

How to set PowerShell_ISE as your default PowerShell editor when working with files in tfs projects

0
0
Every good DBA and Developer keeps their code under source control. What? You don’t? Well, read this and then go and investigate it, there are plenty of options, some free, some you need to pay for. Getting that all sorted is content for another blog (or two!) so let’s get back to editing PowerShell files … Read more
0
0
06 February 2014
06 February 2014

Learning by doing (or not)

0
0
I have spent a lot of today repeating steps that I followed months ago and it is hopefully through writing it down here that I will remember the steps needed if it happens again. I was building a VM environment on my laptop (using VMWare but that is irrelevant) and it went like: Create VM … Read more
0
0
30 January 2014
30 January 2014

Quick Tip: Windows directory file list

0
0
In a previous version of Windows (circa Windows95 or older) there was a button in the toolbar of it’s equivalent of Windows Explorer that generated a list of files in the open directory, in a text file. Despite searching through http://toastytech.com/guis/indexwindows.html I cant locate an image of it or find a demo of it in … Read more
0
0
23 December 2013
23 December 2013

Tribal SQL Awards

0
0
This is likely to be my last blog for 2013 and it is one that is going to give you something to do. Yep, you actually HAVE to click a link and do some thinking. Don’t Panic though, it will take maybe 1 minute and a load of people that have given waaaay more than … Read more
0
0
14 November 2013
14 November 2013

It’s all a numbers game

0
0
Just recently I have been using this small amount of code an awful lot so I thought I would share it here. A lot has been written about using a tally or numbers table and I ‘m not about to re-write any of that. This is simply how to create one really quickly. Lets start … Read more
0
0