SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2010

The week that was Friday 23 July 2010

Its been a busy week this week. From troubleshooting several production issues to writing some incremental load SSIS scripts, the week has flown by. I Still haven’t managed to get my replication post out the door, and after re-reading and re-working again I think it will be a few weeks… Read more

0 comments, 508 reads

Posted in The SQL DBA in the UK on 23 July 2010

Raining Tuesday – Cricket Cancelled – Replication Stinks - SQL BITS VOTE NOW!

Well this was going to be replication post, but I have read it, re-written it, read it, re-written and it still stinks. When I got fed-up of reading and re-reading my stinky replication post I turned on twitter and read a few tweets by active SQL Server community members in… Read more

0 comments, 660 reads

Posted in The SQL DBA in the UK on 20 July 2010

The week that was: Friday 15th July 2010

This is just a short post for a Friday, I have no technical content ready to publish today but lots and lots of ideas and a couple of drafts. This week I have looked a little at replication, I have a few posts lined up next week on that.  I… Read more

0 comments, 633 reads

Posted in The SQL DBA in the UK on 16 July 2010

TSQL2sday #008 – Gettin’ Schooled

This months TSQL2sday is being hosted by Robert Davies of MCM and Microsoft fame, you can find his post here. This month’s topic is titled ‘Gettin’ Schooled’ and for those participating in the blog party this month we will be looking at how we learn and how we teach. Read more

3 comments, 788 reads

Posted in The SQL DBA in the UK on 13 July 2010

SSIS - Enabling Logging

Have you ever had a scheduled run of one of your SSIS packages fail? Have you ever wished you had a little more information available to you when troubleshooting? SSIS has a neat little feature that you can enable called 'Logging' and it does pretty much what it says on… Read more

1 comments, 1,970 reads

Posted in The SQL DBA in the UK on 12 July 2010

SQL Server Agent – Proxy error

I was setting up some SQL Server agent jobs in a test environment. I needed one of our testers to be able to run the job on demand. I made the testers account the job owner and I created a proxy for the the job to run under. I granted … Read more

0 comments, 13,988 reads

Posted in The SQL DBA in the UK on 9 July 2010

SQL Bits 7 – The 7 wonders of SQL

I have been procrastinating this evening, I have several blog posts that I want to write but the football is on TV and my wife is writing up an assignment for her Master’s degree  and she wants me to proof read her work. So while I’m waiting for the next… Read more

0 comments, 572 reads

Posted in The SQL DBA in the UK on 8 July 2010