StevenWhite

Microsoft recommendations on SQL Server service accounts.....

StevenWhite — Sun, 27 Aug 2006 13:21:00 GMT

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

Run away framework.log file (eating up the space on the c drive)

StevenWhite — Thu, 29 Jun 2006 14:22:00 GMT

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

TheRegister interview with Jim Gray

StevenWhite — Tue, 30 May 2006 13:48:00 GMT

The register have just posted an interview with Jim Gray

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

SQL Server 2005 SP1

StevenWhite — Thu, 20 Apr 2006 10:18:00 GMT

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 :)

SQL Server 2005 Report Pack for Microsoft SharePoint Portal Server 2003 - Error

StevenWhite — Tue, 28 Mar 2006 07:15:00 GMT

For those of you thinking of using the new 'SQL Server 2005 Report Pack for Microsoft SharePoint Portal Server 2003 ' to report on your own sharepoint sites, there in a minor script error in the dbSPSReporting.sql script which is used to create a empty database.

Basically there is a comma missing after WSSDoc field in the stored procedure usp_Insert_FactWSS
which causes the stored procedure not to be created.

The fix is to add a comma at the end of the line.
ie.

WSSDoc nvarchar(255),

Memory manangement on 64bit version of SQL Server 2005

StevenWhite — Tue, 21 Feb 2006 09:46:00 GMT

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?

Interesting SQL security article

StevenWhite — Tue, 14 Feb 2006 08:54:00 GMT

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