January 2006 - Posts

Configuring a secure domain account for ASP.NET on Windows 2000

My blog has moved to: http://sqlblogcasts.com/blogs/acalvett/
The full version of this post can be found here.

I recently had to enable the ASP.NET account on a Windows 2000 machine to use a domain account so we could use NT Authentication to the SQL backend and the implementation of the domain account had to be secure. The hardest bit was securing the account, I wanted to give the account as few privileges as possible and make sure the account details could not be easily compromised.........

To read the complete version of this post go to here.

posted Thursday, January 26, 2006 5:40 PM by ACALVETT with 0 Comments

A performance analysis example

My blog has moved to: http://sqlblogcasts.com/blogs/acalvett/
The full version of this post can be found here.

Last week i was dragged kicking and screaming away from my allocated SQL 2005 days to spend 2 days diagnosing performance problems on one of the firms Systems and write a report.

Due to the sensitive nature of the data on the system it has been managed by another team and this was the first time i had looked at it. I thought i'd share my thought process to identifying the problem on the server and reference tools i used. Its the first iteration of the review and once my recommendations are implemented there will be another review to see what else may need dealing with. Please note however i have not included every single step i took otherwise i'd be writing a novel..................

To read the complete version of this post go to here.

posted Sunday, January 15, 2006 4:13 PM by ACALVETT with 1 Comments

SQL 2005 - Maintenance Plans

My blog has moved to: http://sqlblogcasts.com/blogs/acalvett/
The full version of this post can be found here.

I made a decision that to really get things going and identify "trouble spots" that i would continue my quick win approach.

So basically i`m working through installing and configuring our test SQL 2005 box following our SQL 2000 install instructions. Through out this approach i`m documenting and making necessary changes so i can have first drafts of install docs which i`m sure will evolve into excellent documents by the end of the project :D

So, having done the basic install which i talked about previously i decided lets tackle maintenance plans as there should not be to many surprises here.........

To read the complete version of this post go to here.

posted Tuesday, January 03, 2006 6:24 PM by ACALVETT with 6 Comments