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.

15 July 2013
15 July 2013

Keeping an Eye on Your Storage

0
There are plenty of resources that advise you about looking for signs that your storage hardware is having problems. SQL Server Alerts for 823, 824 and 825 are covered here by Paul Randall of SQL Skills: http://www.sqlskills.com/blogs/paul/a-little-known-sign-of-impending-doom-error-825/ and here by me: https://www.simple-talk.com/blogs/2011/06/27/alerts-are-good-arent-they/. Now until very recently I wasn’t aware that there was a different way … Read more
0
08 July 2013
08 July 2013

News From EAP Testing

0
There is a phrase that goes something like “Watch the pennies and the pounds/dollars will take care of themselves”, meaning that if you pay attention to the small things then the larger things are going to fare well too. I am lucky enough to be a Friend of Red Gate and once in a while … Read more
0
18 June 2013
18 June 2013

Working With Extended Events

0
SQL Server 2012 has made working with Extended Events (XE) pretty simple when it comes to what sessions you have on your servers and what options you have selected and so forth but if you are like me then you still have some SQL Server instances that are 2008 or 2008 R2. For those servers … Read more
0
12 June 2013
12 June 2013

Preparing to Upgrade your SQL Server

It isn't a problem to use deprecated TSQL features until it comes to the time to move the database to a server with a newer version of SQL Server, because The Upgrade Adviser tool will tell you what needs to be changed. An alternative is to flush out the use of archaic features via scripting during the development process so there are no surprises later. Jonathan Allen shows how… Read more
03 March 2013
03 March 2013

SQL Saturday Exeter is next weekend

0
  There is still time to register for the Friday and/or Saturday, follow the links below and join us for 2 days of great SQL Server training (8th and 9th March). If you are already registered then you you may be interested in this brand new Windows Phone app for organising your SQL Saturday schedule … Read more
0
28 January 2013
28 January 2013

Looking for some women

0
A guest blog from Annette Allen UK based female speakers – Where are you? You may be aware but I’m helping to organise SQL Saturday Exeter, the second SQL Saturday to be held in the UK, following the success of SQL Saturday Cambridge last year. Recently we put together the schedule of sessions. We had … Read more
0
08 January 2013
08 January 2013

Two days of the best SQL Server training that money doesn’t need to buy.

0
Date:8th and 9th March 2013 Location: Exeter, UK Event: SQL Saturday Exeter (http://sqlsouthwest.co.uk/) Description: A mini-conference featuring the elite of SQL Server trainers and volunteer speakers providing advice and guidance on working with SQL Server. SQL Saturday is a long running series of similar events that take place all over the world. They are organised … Read more
0
05 January 2013
05 January 2013

Keeping sysinternals up to date

0
Pretty much anyone in the IT business should know about sysinternals tools. They are a set of tools written by Microsoft staff that give administrators and support staff an inside edge on system management and diagnostics. You can get the full details at sysinternals.com, there are over 80 tools that help in so many ways … Read more
0
19 November 2012
19 November 2012

Coping with infrastructure upgrades

0
A common topic for questions on SQL Server forums is how to plan and implement upgrades to SQL Server. Moving from old to new hardware or moving from one version of SQL Server to another. There are other circumstances where upgrades of other systems affect SQL Server DBAs. For example, where I work at the … Read more
0
27 August 2012
27 August 2012

Write TSQL, win a Kindle.

0
So recently Red Gate launched sqlmonitormetrics.red-gate.com and showed the world how to embed your own scripts harmoniously in a third party tool to get the details that you want about your SQL Server performance. The site has a way to submit your own metrics and take a copy of the ones that other people have … Read more
0
20 August 2012
20 August 2012

48hrs in Cambridge.

0
In just over 2 weeks something pretty big in the SQL Server Community in the UK is taking place. We are going to witness the first SQL Saturday on these shores. The event is running in Cambridge, the home of the SQL Cambs user group and the chapter leader there (Mark Broadbent) is the lead … Read more
0
13 August 2012
13 August 2012

Customising your monitoring

0
If you are anything like me you’ve always been the sort of person that likes to take things apart and see how they work. For me it started with my first toys and then my bikes and then my cars. Customising these things made them better and also just a little bit more ‘mine’. I … Read more
0