Jonathan Allen

The best piece of equipment you can take to a tech conference

If you have some spare time and want to meet me for a beer at a conference we can spend...

27 October 2014 3 min read

Jonathan Allen

Web page titles from URL

Nothing wholly SQL Server-related this time but this is something that I have been meaning to write for ages. While...

26 September 2014 2 min read

Jonathan Allen

Getting Windows power options under control

I work from a laptop, both at work and at home. In both cases the laptop is either plugged in...

11 September 2014 4 min read

Jonathan Allen

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

Every good DBA and Developer keeps their code under source control. What? You don’t? Well, read this and then go...

03 September 2014 3 min read

Jonathan Allen

Checking who is connected to your server, with PowerShell.

There are many occasions when, as a DBA, you want to see who is connected to your SQL Server, along...

14 August 2014 7 min read

Jonathan Allen

You go to the effort of writing a blog and then …

It’s hard work, some find it harder than others, but there are plenty of people making an effort to write...

28 June 2014 5 min read

Jonathan Allen

PowerShell and SMO – be careful how you iterate

I’ve yet to have a totally smooth experience with PowerShell and it was late on Friday when I crashed into...

27 May 2014 4 min read

Jonathan Allen

Jonathan Allen's Top 10 Favourite Simple Talk Articles

We asked several well-known readers of Simple-Talk to write about their all-time top ten favourite articles from Simple-Talk, and why...

06 May 2014 9 min read

Jonathan Allen

Learning by doing (or not)

I have spent a lot of today repeating steps that I followed months ago and it is hopefully through writing...

06 February 2014 2 min read

Jonathan Allen

Quick Tip: Windows directory file list

In a previous version of Windows (circa Windows95 or older) there was a button in the toolbar of it’s equivalent...

30 January 2014 2 min read

Jonathan Allen

Backup to the right location, by default.

How do you configure where your database backups are created? Do you have problems updating all of your backup jobs...

13 January 2014 8 min read

Jonathan Allen

Tribal SQL Awards

This is likely to be my last blog for 2013 and it is one that is going to give you...

23 December 2013 2 min read

Jonathan Allen

I Thought Everyone Did It Like That – SSMS Templates

One of an occasional series of blogs about things that I do that perhaps others don’t. SSMS – the default...

12 December 2013 10 min read

Jonathan Allen

SSRS Table Cells with Mixed Formatting

In this quick post I’ll show you how to create and format a report so that you can configure individual...

28 November 2013 4 min read

Jonathan Allen

I thought everyone did it like this – Training Session Code Management

One of an occasional series of blogs about things that I do that perhaps others don’t. From very early on...

04 November 2013 7 min read

Jonathan Allen

SQL Server Policy Based Management – Creating a custom condition

I have recently been looking at Policy Based Management with a view to using it to rapidly review servers in...

16 September 2013 5 min read

Jonathan Allen

Keeping an Eye on Your Storage

There are plenty of resources that advise you about looking for signs that your storage hardware is having problems. SQL...

15 July 2013 3 min read

Jonathan Allen

News From EAP Testing

There is a phrase that goes something like “Watch the pennies and the pounds/dollars will take care of themselves”, meaning...

08 July 2013 3 min read

Jonathan Allen

Working With Extended Events

SQL Server 2012 has made working with Extended Events (XE) pretty simple when it comes to what sessions you have...

18 June 2013 7 min read

Jonathan Allen

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...

12 June 2013 17 min read

Register for Simple Talk

Jonathan Allen

Jonathan Allen's content

The best piece of equipment you can take to a tech conference

Web page titles from URL

Getting Windows power options under control

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

Checking who is connected to your server, with PowerShell.

You go to the effort of writing a blog and then …

PowerShell and SMO – be careful how you iterate

Jonathan Allen's Top 10 Favourite Simple Talk Articles

Learning by doing (or not)

Quick Tip: Windows directory file list

Backup to the right location, by default.

Tribal SQL Awards

I Thought Everyone Did It Like That – SSMS Templates

SSRS Table Cells with Mixed Formatting

I thought everyone did it like this – Training Session Code Management

SQL Server Policy Based Management – Creating a custom condition

Keeping an Eye on Your Storage

News From EAP Testing

Working With Extended Events

Preparing to Upgrade your SQL Server