Tweak your Windows 2008 VM

Some tricks for my Windows 2008 VM

1. Disable Shutdown Event Tracker - Windows 2008

- Gpedit.msc

- Local Computer Policy > Computer Configuration > Administrative templates > System > Display Shutdown Event tracker --> set to Disabled

- gpupdate /force

2. Adjust for best Performance of Programs

Computer  > Properties > System Properties::Advanced

Performance > Settings > Advanced

Visual Effect > Adjust for best performance> Adjust for best Performance of Programs

3. Enable SuperFetch 

It will give your operating system a little bit more responsive

Steps:

1- Registry Editor browse to the location HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management\PrefetchParameters.

2- Create DWORD (32bit) Value in the menu New. Type as Name: EnablePrefetcher

3- Edit the value of value EnablePrefetcher by doubleclicking on it. Change the Value data field into "3" (without quotes)

4- Next create a second DWORD (32bit) Value, name it EnableSuperfetch and also give it as Value data "3" (without quotes)

5- services.msc > Right click on the SuperFetch service --> Set Startup type = Automatic

4. Disable Antivirus Scan for my source code folder

McAfee > On-Access Scanner > Detection > What not to scan > Add the [source code folder]

Bluetooth mouse - no more connection lost

I've been using a Bluetooth mouse with my Win7 laptop. However it intermittent looses connection. I tried different ways but it does not seem to fix the issue. Change battery, update my laptop wifi / bluetooth driver. One nice day, I ran through this post and it is fixed.  

Steps: Device Manager > Bluetooth Radios > Thinkpad Bluetooth > Power Management > Uncheck "Allow The computer to turn off this device to save power"

SharePoint 2010 & Keyboard Shortcuts

Some handly shortcuts for use on SharePoint 2010 Home page
How to use the shortcut? use ALT + [key] + ENTER (for the click action)


Key | Shortcut

• / - Site Actions Menu
• S - Jump to Search Box
• W - Login dropdown, Shared Documents,... Press ALT-W to move between those items
• 1 - Home link
• 3 - View All Site Content

I personally like Alt-3-Enter --> go to "All Site Content". Very useful for me.

SQL SharePoint Cheap tricks

The following stuff to set max Memory that my local SQL on SharePoint Dev VM box can consume

----------SetSqlMemory.sql-----------------

USE master

EXEC sp_configure 'show advanced options', 1

RECONFIGURE WITH OVERRIDE

USE master

EXEC sp_configure 'max server memory (MB)', 600

RECONFIGURE WITH OVERRIDE

USE master

EXEC sp_configure 'show advanced options', 0

RECONFIGURE WITH OVERRIDE

-- osql -E -S .\SharePoint -i Path\SetSqlMemory.sql

---------------------------------------

Use the following to put a particular SharePoint Content DB into Read Only mode

---------------------------------------------------
USE master;
GO
ALTER DATABASE SharePoint_Content_80
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO

ALTER DATABASE  SharePoint_Content_80
SET READ_ONLY; 

-- SET READ_WRITE

GO
ALTER DATABASE  SharePoint_Content_80
SET MULTI_USER;
GO

-----------------------------------------------------------