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

SQL Server Auto grow

I had a great response to my blog post and poll last week about how DBAs use auto grow. In the main it seems people use auto grow like I do. As a backup but it does not replace proper monitoring or capacity planning.

You can see the results below Read more

0 comments, 541 reads

Posted in The SQL DBA in the UK on 16 January 2013

SQL Server Consulting: Weekly Round-up

The first full week in 2013 has been a a busy week for me with lots of SQL Server consulting and SQL Server writing work on. I haven’t written many blog posts so we have eaten into the scheduled posts a little bit. I like to schedule my posts a…

Read more

0 comments, 564 reads

Posted in The SQL DBA in the UK on 12 January 2013

#SQLSaturdayExeter–Superb SQL Server Event

#SQLSaturday194 is coming to Exeter on the 8th – 9th March.

What is SQL Saturday?  The brain child of Steve Jones, Brain Knight and  Andy Warren, the founders of sqlservercentral.com  the first event took places in the US in back October 2007 and since then has grown… Read more

0 comments, 367 reads

Posted in The SQL DBA in the UK on 11 January 2013

SQL Server Virtualisation and Consolidation

Come and join me in London this March for a 3 day course on SQL Server virtualisation and consolidation.The course will start on Wednesday March 13th

Attending this SQL Server Virtualisation and Consolidation course you will learn how to:

  • Implement SQL Server in a virtual environment
  • Select the appropriate consolidation…

Read more

0 comments, 527 reads

Posted in The SQL DBA in the UK on 10 January 2013

Auto grow–On or Off Straw Poll

David Postlethwaite who contributes to this blog regularly sent me an email this morning asking about Database Auto grow.

This was his question

Do you set the database and logs to grow on demand.
Advantage:       Only using expensive shared disk space as required
Disadvantage:   Causes slow database response when the…
Read more

9 comments, 1,347 reads

Posted in The SQL DBA in the UK on 7 January 2013

SQL Server Contracting and Business Network Wales - LinkedIn Groups Updates

I have been doing some work on some LinkedIn groups that I manage and look after over the holidays. There have been two in particular that I have been working on.

SQL Server Contracts – I set this group up in 2009. Its purpose was connect SQL Server Professional and… Read more

0 comments, 470 reads

Posted in The SQL DBA in the UK on 4 January 2013

SQL Saturday #194 Exeter

I have read much about SQL Saturday’s but I have yet to attend one, that is about to change. I have read much about them but until recently these events were US based and my schedule just never allowed me to make one.

With SQL Saturday #194 taking place in… Read more

0 comments, 460 reads

Posted in The SQL DBA in the UK on 3 January 2013

SQL Server Consulting–New for 2013

Today is the first full work day for me in 2013 and I though I’d use it to write a short post about the consultancy and support offerings that you get from gethynellis.com in 2013.

We have a range of consultancy, training and and support services that you and your… Read more

0 comments, 471 reads

Posted in The SQL DBA in the UK on 2 January 2013

Happy New Year

I’m not working too hard today, so this is just a short post to wish all my readers a very happy and prosperous New Year


Learn more about SQL Server Virtualization on 2013 then enrol on one of these Learning Tree courses

London: SQL Server Virtualisation and Consolidation

Toronto: SQL…

Read more

0 comments, 580 reads

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

December Top 4 Popular Posts

It is Monday today but its no ordinary Monday. Today is New Years Eve, its the end of December and its the last day of the year. This post is looking back at the top 4 popular posts on the blog for December 2012

  1. SP_Change_Users_login
  2. Bulk Insert Permissions
  3. DB_Executor Role

Read more

0 comments, 565 reads

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

My RSS Reader…The Great Clean Up

If you blog and call yourself a blogger then you probably have a pretty full RSS reader. Mine has been added to considerably over the years. Well I signed into my Google reader account today and I realised that there is a lot of blogs that either I don’t read… Read more

0 comments, 528 reads

Posted in The SQL DBA in the UK on 28 December 2012

SQL Server Cumulative Update

Microsoft today announced the latest round of SQL Server Cumulative Updates

SQL Server 2012 CU 5 – You can get more information here

SQL Server 2008 SP2 CU 4 – You can get more information here

SQL Server 2008 SP1 CU10 – You can get more information here

This might… Read more

0 comments, 534 reads

Posted in The SQL DBA in the UK on 28 December 2012

Closing the Results Window in SSMS

This is a guest post by David Postlethwaite.

I’ve been wondering how to do this for years. At SQL Bits and SQL Saturday the presenters make the results window disappear with a keyboard click but I could never work it out.

Well today I was working on a query and…

Read more

0 comments, 514 reads

Posted in The SQL DBA in the UK on 28 December 2012

Merry Christmas from gethynellis.com

This is a very short post on Christmas Eve to wish all my readers a very Merry Christmas!

I’m going to be working very minimally over the Christmas period, I will be online from time to time but I have nothing strenuous that I need to achieve and I will… Read more

0 comments, 347 reads

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

SQL Server Training in 2013–SQL Server Virtualisation and Consolidation

As we approach a new year many of you will be looking at your SQL Server Training needs for 2013. During 2012 I was fortunate enough to author another course for Learning Tree – this course focuses on running SQL Server in a virtual environment. It is titled 2109 SQL…

Read more

0 comments, 402 reads

Posted in The SQL DBA in the UK on 19 December 2012

SQL Server Training in 2013–SQL Server 2012 New Features

As we approach the end of 2012 – The release year for SQL Server 2012 many of you as we approach 2013 will have version upgrades, hardware refreshed and the real possibility of SQL Server 2012 being run in your production environment. So you might be after some SQL Server…

Read more

0 comments, 576 reads

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

SQL Server Training–New York New York!

For those that read my blog regularly you will know that I over the last couple of years I have been able travel quite extensively delivering  SQL Server Training with Learning Tree. At the start of December I travelled to New York to deliver more SQL Server Training the course… Read more

0 comments, 638 reads

Posted in The SQL DBA in the UK on 13 December 2012

SQL Server Disaster Recovery

I was reading a blog post by Steve Jones on Monday and I started to write a comment on his blog, as it turned out it that comment turned into this post. Now this week is SQL Server disaster recovery week over on sqlservercentral.com so I thought I’d get involved… Read more

0 comments, 706 reads

Posted in The SQL DBA in the UK on 11 December 2012

SQL Server Books–Query Tuning

Last week I was delivering a SQL Server Training course for learning tree. The course was 2109 SQL Server Virtualization and Consolidation: Hands-On. As part of the course the class discussion moved onto the importance tuning your queries ensuring they make efficient use of the servers resources. One of… Read more

0 comments, 636 reads

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

SQL Server Consulting Blog–Sunday Stats

I’m going to continue with my series of posts on analysing how well my SQL Server Consulting blog has done in terms of traffic this week, I’m doing this just as a way of document how well or not so well the blog is doing in terms of performance, traffic… Read more

0 comments, 576 reads

Posted in The SQL DBA in the UK on 9 December 2012

Newer posts

Older posts