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.

31 January 2011
31 January 2011

My wife has left me . . .

0
0
LiveJournal Tags: Leaving,Colleagues She announced it before Christmas, in a letter, giving the exact day she intended to leave and what she had planned for her future. We met 8 years ago. We were looking for a data administrator for a CRM system in the company and she was the stand out candidate. She got … Read more
0
0
03 November 2010
03 November 2010

SQL Monitor – behind the scenes

0
0
“Hi Jonathan, my name is Adam, I work for Red Gate, on the SQL Response team. I am wondering if it would be possible to arrange a user experience session with you please? It should only take about 10 or 15 minutes, if you could help us out we’d really appreciate it.” That’s how it … Read more
0
0
28 October 2010
28 October 2010

Looking for long term friendship

0
1
No, this isn’t some cheesy Singles column advert posted in the wrong place. I am seriously looking for some friends. People that, like me, share my interests and want to have conversations about hard drive partition alignment, index fragmentation, query optimisation SARGability, memory allocation and more without the person we are talking to glazing over, … Read more
0
1
02 September 2010
02 September 2010

The hidden benefits of SSMS

0
0
Every good DBA/developer writes their code with some comments/instructions at the top. Now in many cases this is important to have visible when running the code as it may give advice on the results or what certain column values will mean. Now you can split the code window, like you can in Excel but to … Read more
0
0
18 August 2010
18 August 2010

Encouraging Comments

0
0
Do you hate it when you open a piece of script and there are no comments? There is something comforting about seeing some lines of green text when you are up to your neck in a problem. Knowing that someone, probably the person that wrote the script was thinking about you and your predicament, even … Read more
0
0
21 July 2010
21 July 2010

If you are reading this blog . . .

0
0
Or, more accurately, if you have read this blog and especially the series about using LogParser and asked a question last week. It was a good question that I wanted to publish and then answer. Sadly I am not entirely competent with the CommunityServer control panel and having ticked your comment and published it I … Read more
0
0
14 July 2010
14 July 2010

Keeping a track of database changes

0
0
If you are anything like me you work as part of a small team managing databases, doing a bit of web development, handling calls for technical support, attending countless meetings and about a hundred other things. Its long been a constant concern of mine that there are changes being made to databases that I manage … Read more
0
0
02 June 2010
02 June 2010

Watching the oil slick

0
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
0
02 June 2010
02 June 2010

Using LogParser – part 2

0
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
0
1
24 May 2010
24 May 2010

Using LogParser – part 1

0
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
0
20 May 2010
20 May 2010

How do you use blog content?

0
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
0
17 May 2010
17 May 2010

Is this table replicated?

0
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
0
1