Monthly Archives: October 2008

SQL Server 2005 EE Hiccup

Patch night caused an ugly hard restart on the server. Things looked OK on startup, after a brief time of being in recovery mode. But for some reason it had some issues with RedGate Compare. Acting on this odd piece … Continue reading

Posted in SQL Server | Leave a comment

Production Security settings

Web.Config<configuration>   <system.web>        <trace enabled="false" localOnly="true"  />        <customErrors mode="RemoteOnly" />        <compilation debug="false" />        <httpCookies httpOnlyCookies="true" />    <system.web><configuration> References:customErrrors: http://msdn.microsoft.com/en-us/library/h0hfz6fc.aspxhttpCookies: http://www.codinghorror.com/blog/archives/001167.html Details of all: http://msdn.microsoft.com/en-us/library/ms998310.aspx http://h71028.www7.hp.com/ERC/cache/571914-0-0-0-121.html&ERL=truehttp://h71028.www7.hp.com/ERC/cache/571845-0-0-0-121.html&ERL=true SSL Settings: Best to keep client and server at the best security channel possible. Disable the … Continue reading

Posted in Uncategorized | Leave a comment

Powershell Basics

Before you start don’t forget: Get-ExecutionPolicySet-ExecutionPolicy RemoteSigned Get-ExecutionPolicy Update Dec 2009: * even if you run a batch job with powershell you need to log in with that user account and run these lines above otherwise your jobs will fail. … Continue reading

Posted in Uncategorized | Leave a comment

More on Hyper-V Import and Export

How to do it? Storing your Hyper-V files on a file server is pretty straightforward. There are, however, a few of things that you need to implement this properly with Hyper-V. First of all, remember to grant access to the … Continue reading

Posted in Uncategorized | Leave a comment

BGInfo and Hyper-V

Simple enough right? OK. Go to http://live.sysinternals.com and grab the latest bginfo.exe (yes, I pioneered that method of downloading software 😉 Now create a custom value that reads from the registry the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Virtual Machine\Guest\Parameters\PhysicalHostName It might throw an … Continue reading

Posted in Uncategorized | Leave a comment