I ran into this problem recently when trying to export and import SSIS packages on a SQL Server 2008 R2 Cluster and it seemed like such a common problem, but I didn’t really find much documentation about how to resolve this.

I don’t consider myself a SQL Server expert so here’s a SQL Server Administrator Cheatsheet of queries for managing SQL Server. Query all Database Files List all the Data and Log files for your database with the file sizes.

Historically application developers have had two choices when it came to authentication for their applications. Implement their own login processing, or rely on a SSO system like CA Siteminder or Oracle Access Manager. Both approaches have their downsides. Even when using one of the ASP.NET Providers, its a lot of work to build your own...

I was recently working on an upgrade to a website that involved changing the Application Pools from 32-bit to 64-bit. The servers hosted several websites and they all ran in 32-bit mode. Several days later I noticed the System log was full of the following errors for one of the websites that I didn’t update.