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

Archives: September 2010

Instant File Initialization – Is it Turned On?

I have posted a short note on instant file initialization previously, that post can be found here. The crux of enabling instant file initialisation is to give the service account running the SQL Service permission on the 'Perform Volume Maintenance Task' This is just a little follow up post to… Read more

1 comments, 1,710 reads

Posted in The SQL DBA in the UK on 21 September 2010

Policy Based Management - Disable Autoclose

I posted recently about my run-in with autoclose and my online friend Jorge Segarra (Blog|@SQLCHICKEN) left a great comment on my syndicated post on SSC where he said "Yeah Auto_Close came straight from the devil. One cool thing you could do on 2008 is use Policy-Based… Read more

0 comments, 1,585 reads

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

Mastering PowerShell – Free EBook

Someone who I follow on twitter posted a tweet recently with a link to a free eBook on PowerShell. I have forgotten  who posted the link, sorry. I followed the link and downloaded the book. I have been ‘learning’ PowerShell for a little while, from various sources and I thought… Read more

5 comments, 2,558 reads

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

SQL Server - Dedicated Administrator Connection (DAC)

This a short post looking at the Dedicated Administrator Connection or DAC for short. In extreme circumstances, when there is a complete lack of resources available, for example, it is possible for SQL Server to enter a state whereby no further connections can be made to the instance. In versions… Read more

0 comments, 8,115 reads

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

Auto Close – SQL Server

I ran into an issue recently where I had a third party supplied database set to auto close. I couldn't work out why they would use such a setting but I could think of a couple of reasons not to including:

  • Resources used to maintain the state of the open…

Read more

2 comments, 2,983 reads

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