Friday, October 23, 2015

Windows 7 Update consumed high memory usage [FIXED]

Recently I received lots of complaints from end-user regarding their windows performance was very slow for an hour just after they logged into windows.

I found that the svchost.exe in the Task Manager consumed high resources, later I right click it, select "Go to Service(s)" and found that it's "wuauserv - Windows Update".

I have tried to download 3rd party apps to always set this process to the lowest resources priority. Unluckily it doesn't work well though.

After several months of search, I finally found a fix to this issue - Microsoft KB3065987. This hot fix requires a reboot to take effects. However, if you have WSUS - Windows Server Update Services, you need to perform another patch at the WSUS server - Microsoft KB2938066.

I hope this could saves you months of search :)

Wednesday, February 25, 2015

[Architecture]: Gang of Four (GoF) Design Patterns




The Gang of Four (GoF) patterns are generally considered the foundation for all other patterns. They are categorized in three groups: Creational, Structural, and Behavioral. Here you will find information on these important patterns.

Creational Patterns
· Abstract Factory Creates an instance of several families of classes
· Builder Separates object construction from its representation
· Factory Method Creates an instance of several derived classes
· Prototype A fully initialized instance to be copied or cloned
· Singleton A class of which only a single instance can exist

Structural Patterns
· Adapter Match interfaces of different classes
· Bridge Separates an object’s interface from its implementation
· Composite A tree structure of simple and composite objects
· Decorator Add responsibilities to objects dynamically
· Facade A single class that represents an entire subsystem
· Flyweight A fine-grained instance used for efficient sharing
· Proxy An object representing another object

Behavioral Patterns
· Chain of Resp. A way of passing a request between a chain of objects
· Command Encapsulate a command request as an object
· Interpreter A way to include language elements in a program
· Iterator Sequentially access the elements of a collection
· Mediator Defines simplified communication between classes
· Memento Capture and restore an object's internal state
· Observer A way of notifying change to a number of classes
· State Alter an object's behavior when its state changes
· Strategy Encapsulates an algorithm inside a class
· Template Method Defer the exact steps of an algorithm to a subclass
· Visitor Defines a new operation to a class without change

Thursday, December 12, 2013

[SharePoint 2010]: Managing People & Group at Site Collection Level


Important If you remove the user from the All People group, all the user's permissions to this Site Collection are removed. Before you remove the user's permissions and re-add them, note the user's permissions. To do this, on the Site Actions menu, click Site Permissions, and then click Check Permissions.

The All People group is hidden in SharePoint 2010. However, to access this group, you can modify the following URL in the browser:

<Site URL>/_layouts/people.aspx?MembershipGroupId=0

For example, the URL will resemble the following:

https://contoso.com/sites/<SpecificSiteName>/_layouts/people.aspx?MembershipGroupId=0

If you remove the user from this group, this also removes the user from the userInfo table in the Microsoft SQL Server database. When you re-add the user, the user's information is updated in this table.

For instructions about how to grant users access to a Site, visit the following website:

Roadmap: Grant permissions for a site

Friday, July 1, 2011

Quick Export/Import Table Data

NOTE: Type commands below under Command Prompt
Export:
bcp db_name.dbo.table_name out "c:\data\table_name.txt" -c -T
Import:
bcp db_name.dbo.table_name in "c:\data\table_name.txt" -c -T