Monthly Archives: December 2014

Moving Windows’ Offline File Cache away from C:\

Got a small SSD as your C drive? So do I. Storing your documents on a network drive? Yep. Want to index that network drive, to include it in libraries, searches, etc? You bet. You’ll want to move your offline cache. Create a folder for your offline file cache. Something like D:\Cache From an elevated […]

Handler “PageHandlerFactory-Integrated” has a bad module “ManagedPipelineHandler” in its module list

This error seems to pop up every now and again when I configure a new IIS server, even if I do remember to check the ASP option during the initial role selection. Here’s how to resolve it (run as admin) on a 64-bit system: %windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i ..and on a 32-bit system: %windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i

Enabling read_committed_snapshot on an existing MSSQL database

In short, for the database named “internal”: SELECT is_read_committed_snapshot_on, snapshot_isolation_state_desc,snapshot_isolation_state FROM sys.databases WHERE name=’internal’ ALTER DATABASE [internal] SET allow_snapshot_isolation ON ALTER DATABASE [internal] SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE [internal] SET read_committed_snapshot ON ALTER DATABASE [internal] SET MULTI_USER SELECT is_read_committed_snapshot_on, snapshot_isolation_state_desc,snapshot_isolation_state FROM sys.databases WHERE name=’internal’