I've been spending some time reading up on the SQL 2005 Papers.
If you haven't taken a look, there is lots of interesting things to read. Well worth a browse espically the operations section. http://www.microsoft.com/technet/prodtechnol/sql/2005/library/default.mspx)
Anyway it would be nice to see consistant advice from MS about sql service accounts....

In the  'Setting Up Windows Service Accounts'  document is states

Microsoft recommends that you do not use the Network Service account for the SQL Server or SQL Server Agent services. Local User or Domain User accounts are more appropriate for these SQL services.
(http://msdn2.microsoft.com/en-us/library/ms143504.aspx)

Whereas in the 'Physical Database Storage Design' paper  it recommends 'Use the Windows Network Service Account for security.'
(http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx)

Happy Reading
Steven

Today I noticed that the space on the c drive on one of my sql 2005 servers was going down. After investigation I found that the c:\windows\system32\wbem\log\Framework.log file was growing above the 64k limit.

Afterway after a quick search I found the fix http://support.microsoft.com/?kbid=836605

Steven

The register have just posted an interview with Jim Gray

http://www.regdeveloper.co.uk/2006/05/30/jim_gray/

Well I've installed this on my desktop (Core DB, tools and reporting services), and all seems well.

I see that MS have improved the delivery of the service pack, no more expanding the files into a directory.

Just waiting  for the updated BOL and MOM packs :)

I noticed that in the x64 version of Management Studio we have the 'Enable AWE' memory. Why?

In Books online it states that '64-bit applications do not require AWE because access to memory is not limited to 4 GB'

If that is the case why have the option available on the 64bit version of the product?
What does it do?

On one of my regular visits to http://www.sqlsecurity.com I noticed a link plugging an interesting article called ‘Article on 10 tricks attackers use to access SQL Server’. Anyway the article can be found here

Steven