Setting TimeZone value from Command Prompt

If you'd like to change timezone information by using command prompt you can use control.exe to do that.

First of all you have to find out Time Zone name you wish to set, you can use the list in

HKLM\Software\Microsoft\Windows NT\CurrentVersion\Time Zones

For example :control TIMEDATE.cpl,,/Z Romance Standard Time
sets Time Zone value to (GMT+01:00) Brussels, Copenhagen, Madrid, Paris

or

you can write Time Zone information that you can see in Date and Time Properties>Time Zone Window


















For example :control TIMEDATE.cpl,,/Z (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London

WSUS Configuring BITS Performance

You can optimize the performance of downloads by configuring BITS through Group Policy.

You can use to use Group Policy to configure network bandwidth that BITS uses.

Note : If you are going to change BITS bandwidth settings don't forget these settings are system wide, they are not application specific, so every application uses BITS will be affected. the BITS settings will affect BITS in any application.

To configure BITS bandwidth settings.

1.Run Group Policy Object Editor (Start>Run>gpedit.msc).
2.Browse Computer Configuration>Administrative Templates>Network>Background Intelligent Transfer Service.
3.Open the "Maximum network bandwidth that BITS uses (BITS 2.0)" or "Maximum network bandwidth for BITS background transfers (BITS 3.0)" setting.
4.Set the transfer rate in kbps that you want BITS to use (the default is 10).
5.Set the times at which you want to limit the bandwidth (the default is 8:00 A.M. to 5:00 P.M.).
6.Set the limitations to be used outside of the designated time (the default is Use all available unused bandwidth, but you may select another limitation).
7.Click OK.

Client side targeting in WSUS

You can use AD Group policies to assign computers to a group used by WSUS. This will provide you more flexibility and configurability with your WSUS infrastructure by targeting.

To do this, open browse to Computer Configuration\Administrative Templates\Windows Components\Windows Update in your policy, and open Enable Client-side targeting, select Enabled and define a name for the Target group, for computers apply this policy.

Installing SQL Tools on Windows Web Server

If you tried to install SQL Client tools on your Windows 2003 Web Server edition you would have get an error says "Windows cannot open the program since it has been disabled". Because install SQL 2000 Server is not supported on Web Server edition of Windows Server. Even if you just want to install Client Tools, when you run sqlcli.bat from command prompt windows will say you the specified file is not exist or it couldn't find for the setup.sql exe.



But you can install and use SQL 2005's or 2008's Express Editions Management Tool Studio. Because as you can install MSDE on a Windows Server 2003 Web Edition , new Express Edition family can be installed.

You can download just management tool installation file from this link http://go.microsoft.com/fwlink/?linkid=65110

This setup will install SQL 2005 Express Edition Management Tool Studio which will allow you to administer old MSDE databases as well.

You can find more detail about SQL 2005 Express at : http://www.microsoft.com/express/2005/sql/download/default.aspx