Jonathan Allen

Speaking, Listening and Speaking again

It seems a very brief two weeks ago that I was in the middle of the team running SQL Saturday...

25 March 2013 3 min read

Jonathan Allen

SQL Saturday Exeter is next weekend

There is still time to register for the Friday and/or Saturday, follow the links below and join us for...

03 March 2013 1 min read

Jonathan Allen

Keeping sysinternals up to date

Pretty much anyone in the IT business should know about sysinternals tools. They are a set of tools written by...

05 January 2013 2 min read

Jonathan Allen

48hrs in Cambridge.

In just over 2 weeks something pretty big in the SQL Server Community in the UK is taking place. We...

20 August 2012 1 min read

Jonathan Allen

Customising your monitoring

If you are anything like me you’ve always been the sort of person that likes to take things apart and...

13 August 2012 3 min read

Jonathan Allen

A quick look at: dm_db_index_usage_stats

I recently wrote a post with a similar title, reviewing the dm_db_index_physical_stats so it seemed logical to pick a closely...

08 August 2012 5 min read

Jonathan Allen

Keeping the Scary DBA from your door.

Have you seen the video from Grant Fritchey regarding database backups for the impatient people that are as yet to...

03 August 2012 5 min read

Jonathan Allen

SQL In the City – What an event!

A guest blog from @Mrs_Fatherjack Well to repeat Mr Fritchey – WOW, what an event. They went. . . They...

25 July 2012 3 min read

Jonathan Allen

SQL in the City 2012 – London

Redgate software first ran their SQL in the City event in 2011 in London and I was highly honoured to...

17 July 2012 7 min read

Jonathan Allen

SQL Server Query Time Out when referencing data on a Linked Server

I recently had an issue where an overnight job that had a history of working successfully on a reliable basis...

16 July 2012 6 min read

Jonathan Allen

It’s time that you ought to know what you don’t know

There is a famous quote about unknown unknowns and known knowns and so on but I’ll let you review that...

09 July 2012 3 min read

Jonathan Allen

A quick look at: dm_db_index_physical_stats

A quick look at the key data from this dmv that can help a DBA keep databases performing well and...

03 July 2012 11 min read

Jonathan Allen

Database IDs

Just a quick post, mainly to test out the new blog format but related to a question on the #sqlhelp...

27 June 2012 1 min read

Jonathan Allen

A quick look at: sys.dm_os_buffer_descriptors

SQL Server places data into cache as it reads it from disk so as to speed up future queries. This...

12 June 2012 4 min read

Jonathan Allen

PASS UK Regional Mentor

I have just had an email from Mark Ginnebaugh welcoming me to the role of PASS UK Regional Mentor. This...

26 September 2011 1 min read

Jonathan Allen

SQL in the City in retrospect – part 1

The journey, the build-up and the day The Journey We left Devon early on the Tuesday. Very early. We had...

19 July 2011 5 min read

Jonathan Allen

It’s good to be a little bit scared

How many times have you read or heard that phrase from someone about to embark on some endeavour? A stand-up...

08 July 2011 3 min read

Jonathan Allen

11 word story meme

Attend SQL Bits, Hope to come back smarter, Prove it to your Boss. I hope a haiku fits in with...

04 April 2011 1 min read

Jonathan Allen

Comments – What’s that?!!

LiveJournal Tags: tsql,comments,tips and tricks,how to This blog entry is not one of mine. I have the pleasure of sitting...

31 March 2011 3 min read

Jonathan Allen

How to make sure you see the truth with Management Studio

LiveJournal Tags: TSQL,How To,SSMS,Tips and Tricks Did you know that SQL Server Management Studio can mislead you with how your...

23 February 2011 4 min read

Register for Simple Talk

Jonathan Allen

Jonathan Allen's content

Speaking, Listening and Speaking again

SQL Saturday Exeter is next weekend

Keeping sysinternals up to date

48hrs in Cambridge.

Customising your monitoring

A quick look at: dm_db_index_usage_stats

Keeping the Scary DBA from your door.

SQL In the City – What an event!

SQL in the City 2012 – London

SQL Server Query Time Out when referencing data on a Linked Server

It’s time that you ought to know what you don’t know

A quick look at: dm_db_index_physical_stats

Database IDs

A quick look at: sys.dm_os_buffer_descriptors

PASS UK Regional Mentor

SQL in the City in retrospect – part 1

It’s good to be a little bit scared

11 word story meme

Comments – What’s that?!!

How to make sure you see the truth with Management Studio