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.

02 June 2010
02 June 2010

Watching the oil slick

0
Having dominated the news for the last month or more BP’s problems with one of their oil exploration endeavours is a problem that will affect the whole planet. Now I dont know the whole story, either how it all happened or what is being done to restore some sort of control (I have heard about … Read more
0
02 June 2010
02 June 2010

Using LogParser – part 2

1
PersonAddress.csv SalesOrderDetail.tsv In part 1 of this series we downloaded and installed LogParser and used it to list data from a csv file. That was a good start and in this article we are going to see the different ways we can stream data and choose whether a whole file is selected. We are also … Read more
1
24 May 2010
24 May 2010

Using LogParser – part 1

0
I have mentioned LogParser before on my blog and have decided to create a series of walk-through style articles to show someone new to LogParser what it can do and how to use it. It is appropriate to all sorts of job roles in IT, whether you are a System Administrator or a SQL DBA. … Read more
0
20 May 2010
20 May 2010

How do you use blog content?

0
Do you write a blog, have you ever thought about it? I think people fall into one of a few categories when it comes to blogs, especially blogs with technical content. Writing articles furiously – daily, twice daily and reading dozens of others. Writing the odd piece of content and read plenty of others’ output. … Read more
0
17 May 2010
17 May 2010

Is this table replicated?

1
Another in the potentially quite sporadic series of I need to do … but I cant find it on the internet. I have a table that I think might be involved in replication but I don’t know which publication its in… We know the table name – ‘MyTable’ We have replication running on our server … Read more
1
12 May 2010
12 May 2010

Welcome to Jackstown

0
I live in a small town, the population count isn’t that great but let me introduce you to some of the population.  We’ll start with Martin the Doc, he fixes up anything that gets poorly, so much so that he could be classed as the doctor, the vet and even the garage mechanic. He’s got … Read more
0