>I will spend the next couple of blog posts looking at performance tuning and troubleshooting in SQL Server 2005, although I may insert a few posts about SQL Server 2008 and probably SharePoint 2007. Having to work in an organization that provides enterprise hosting services, I regularly deal with customers who blame our infrastructure whenever […]
I was stuck with authorization issues with a web application trying to call COM+ applications in IIS. But when the security hops go beyond 2 levels of access, it becomes more difficult to find the root cause. Good thing I found this tool from Microsoft called AuthDiag 1.0. This tool is designed to aid customers […]
I was on my way home after dinner when I happen to bump into my former boss. He used to be a Microsoft MVP and a Director for Training and Technology for a Microsoft training partner. A great guy that he is, he joined Microsoft Singapore earlier this year as a Solutions Specialist for the […]
>I keep highlighting to developers that an account’s SID is more important than the other attributes. This is something that any IT professional or developer or DBA should take seriously. Take for instance a Windows account that was created for a user. The user manages to log in to a workstation and creates his or […]
>Being a lazy guy that I always am, I try to find ways to make my life easier. When we finished fixing all the issues in our test server, I recommended that we simply backup the MSDB database and restore it on the production server. This way, I don’t have to recreate the jobs on […]