Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: December 2010

Happy New Year

Well it’s Friday again and another big day.

Hopefully you all had a great Christmas and as we move to a New Year, the end of 2010 and start 2011 I’d like to wish everyone Happy and prosperous New Year.


Read more

0 comments, 528 reads

Posted in The SQL DBA in the UK on 31 December 2010

SELECT * FROM SQLBLOGGERS WHERE LOCATION = ‘UK’

I published a post yesterday where I listed my top 5 bloggers from the worldwide SQL community for 2010. The long and short of it, these were the people whose blog’s I had read the most throughout the year. There are many other great blogs and bloggers out there that… Read more

2 comments, 650 reads

Posted in The SQL DBA in the UK on 30 December 2010

SELECT TOP 5 * FROM BLOGGERS

Hopefully my title gives away what this post is about. This my list of the top five people or more precisely their blogs that have made most use out in the year gone, I am not going to put them in any specific order they all add to my knowledge… Read more

1 comments, 178 reads

Posted in The SQL DBA in the UK on 29 December 2010

Merry Christmas

This is just a short post for a Friday and not just any old Friday either, Santa is on his way :-)

 

 

I would just like to wish everybody a very Merry Christmas.


Read more

2 comments, 162 reads

Posted in The SQL DBA in the UK on 24 December 2010

SQL Bits 8

It seems the dates for the next SQLBITS have been released will take between April the 7th and April 9th 2011.

Location: The Grand Hotel, Brighton


Read more

2 comments, 142 reads

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

Turn Off AutoShrink!

This is kind of a follow up to a post I published last week regarding autogrowth. A forum poster said they had turned on AutoGrow and they were using autogrow as way of managing the growth of their databases – No! This post titled “Should I have AutoGrowth enabled… Read more

0 comments, 254 reads

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

SQL Server 2005 SP4 Released

Steve Jones mentioned recently that SP4 for SQL Server 2005 is on its way because Microsoft closed his connect item.

Well looks like it was released yesterday, you can download it here:

 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b953e84f-9307-405e-bceb-47bd345baece&displaylang=en


Read more

1 comments, 191 reads

Posted in The SQL DBA in the UK on 18 December 2010

Let it Snow, Let it Snow, Let it Snow!

I don’t usually post on my blog on the weekend, but this weekend, the weekend before a Christmas is a little different. Where I live in South Wales in the UK we don’t usually get a lot of snow, but since Thursday this week we have had the best part… Read more

2 comments, 140 reads

Posted in The SQL DBA in the UK on 18 December 2010

INSERT INTO Reading2011 VALUES…

Last Friday I posted a short note on what books I have read this year past, so this Friday keeping up with the same theme and the fact we are quickly approaching the end of the year I thought I would write a post  on what books I want to… Read more

0 comments, 168 reads

Posted in The SQL DBA in the UK on 17 December 2010

Should I have AutoGrowth enabled on my SQL Server Database

I was reading a few forum posts yesterday where a few people were complaining that the transaction log had grown during index maintenance and they were asking:

  1. If they should have autogrowth enabled?
  2. If they should restrict the size of the file?

I think autogrowth should be enabled on all… Read more

13 comments, 929 reads

Posted in The SQL DBA in the UK on 15 December 2010

T-SQL Tuesday #13 - What the Business Says Is Not What the Business Wants

So this month’s blog party is being held by non-other than Steve Jones (blog|@Way0utwest) of SQL Server Central fame. This month’s topic is all about the business, your customers, clients etc asking for something but not really knowing what they are asking for. Or  in my… Read more

0 comments, 167 reads

Posted in The SQL DBA in the UK on 14 December 2010

SELECT TOP 3 SQLBOOKS FROM 2010

This is just a short post for a Friday. This is my list of the Top 3 SQL Server books from the year[ish]:

Granted some of these book were published… Read more

2 comments, 310 reads

Posted in The SQL DBA in the UK on 10 December 2010

British Heart Foundation – Christmas Event

CHRISTMAS AT THE MUSICALS

Originally posted on Senghenydd Cricket Club website.

Join The Romilly Singers as they entertain you through a selection of musicals through the ages on Sunday December 12th at St Peter's Hall, Roath, 6.30pm. Tickets are £20 and include a two course dinner plus entertainment. To purchase… Read more

0 comments, 184 reads

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

Blog – Domain Changes Update

As I mentioned in an earlier post I have recently moved my blog to a new domain name. This is something I have been thinking about for while but in truth and with hindsight I did not manage the transition all that well. I let the old domain and hosting… Read more

0 comments, 247 reads

Posted in The SQL DBA in the UK on 7 December 2010

My Weekend

We are now well into December and Christmas is fast approaching, I have most, but not all of my shopping done, so a few more things to get before the Party season starts in earnest. Which for me is this Friday :-)  It was a busy week for me last… Read more

0 comments, 148 reads

Posted in The SQL DBA in the UK on 6 December 2010

Digg

I’m currently doing some experiments with ,y blog and trying out digg.com. In order to do that I need to paste this key <!--261640fe8cc94a1194161809571dac4c—> into a post to verify that it is, in fact, my blog.


Read more

0 comments, 174 reads

Posted in The SQL DBA in the UK on 5 December 2010

MCM – Useful Resources

This is just a short post for a Friday. There has been a lot written over the past few weeks since the PASS summit about changes to the Microsoft Certified Master (MCM) programme. As part of that announcement several very useful resources were made available, an series of MCM readiness… Read more

0 comments, 222 reads

Posted in The SQL DBA in the UK on 3 December 2010