Wednesday, May 28, 2014

Win7 forcing sync folders offline

Maximum PC Guides article on forcing your Win7 Sync'd folder to work offline while connected to the network. This is a great way to boost performance if, for example, you're connected to VPN on the other side of the country just so you can get to a NAS down the street from your house.

Disable AutoRecover in Microsoft SQL Server Management Studio

Found here, disabling AutoRecover in SSMS: Just geeks: Disable AutoRecover in Microsoft SQL Server Management Studio. This is the path for SQL Server 2005 Management Studio. I confirmed just a slight tweak is necessary for 2k8 and also show how to do it in Powershell:
PS C:\> cd hkcu:
PS HKCU:\> cd '.\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover'
PS HKCU:\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover> Set-ItemProperty . -name 'AutoRecover Enabled' -Value 0
PS HKCU:\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover> Set-ItemProperty . -name 'AutoRecover Always Enabled' -Value 0
PS HKCU:\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover> Get-ItemProperty .