how to convert WQL to SQL for a SCCM or sms query

smsprov.log - records WMI provider access to the site database

this is a server log and can be found from the site server:

open smsprov.log
excute your query
you should be able to see the query execution logged in the smsprov.log. Once this has happened, pause the log file so it does not scroll away on you.
look for the two lines starting with execute wql= and execute sql=,
copy the text out of the bottom pane of the log viewer and paste it into your web report.


Installing ESX 4.0 and vCenter 4.0 best practices


How to relocate the SQL database that is used by VirtualCenter.

How to relocate the SQL database that is used by VirtualCenter.

To move SQL Server databases which are used by VirtualCenter, to a new location.

1.Stop the VMware VirtualCenter Server and VMware Update Manager Service.
2.Migrate the databases according to Microsoft's How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server.
3.Verify the Datasource (DSN) in the ODBC Administrator to reflect any changes made.
4.Update the login credentials that VirtualCenter uses to connect to the database.
See Modifying the username and password VirtualCenter uses to connect to the database server in "Troubleshooting the database data source used by VirtualCenter Server (1003928)".
5.Recreate SQL Agent rollup jobs. Detaching, attaching, importing and restoring a database to a newer version of SQL Server does not automatically recreate these jobs.
6.Start the VMware VirtualCenter Server and VMware Update Manager Service.

Migrating vCenter Server to a different host machine

Migrating vCenter Server to a different host machine

Summarized steps:
1.Shutdown the vCenter Server service.
2.Take a backup of the SQL database.
3.If the SQL database is also being moved, create a second instance of your database and use the vendor's tools to migrate the data.
4.Create the appropriate System DSN connections on the new vCenter Server host.
5.Begin the installation of the vCenter Server software on the new server. If you are installing vCenter Server in a virtual machine, see the Technical Resource Center for guidelines for deploying vCenter in a virtual machine, including sizing, installation, functionality, and configuration of VMware High Availability (HA).
6.When prompted, select Use existing database, and provide the correct credentials to that database.
7.When prompted, select to not re-initialize the data, as this erases all your inventory data.
8.Reboot the machine once the installation is finished.
9.When you first start the vCenter Server Client, it may ask for licenses. Configure the licenses as you had previously in your environment. For more information about licensing for ESX hosts, see the Installation Guide for your version of ESX. For more information about licensing for ESXi hosts, see the Setup Guide for your version of ESXi. You are now able to see the same settings and configuration details.
10.If the IP address of the new vCenter Server has changed, your ESX hosts must be made aware of that change, otherwise the ESX hosts will continue to send their heartbeats to the original IP address of vCenter Server and appear as Not Responding or Disconnected.
11.Confirm that your SQL Agent rollup jobs are present. Detaching/attaching, importing, or restoring a database to a newer SQL server does not recreate these jobs. If these jobs are not present, there are problems viewing performance data and the database begins increasing in size.
12.If vCenter Server is moved to another server with a fresh installation, the SSL certificates change and the ESX hosts show as disconnected within vSphere Client connected to vCenter Server. Right-click on the disconnected hosts and choose Connect, then provide the root login credentials and follow the prompts.

Install VMware virtual center 2.5 on windows 2008 server

Officially virtual center 2.5 doesn't support win2008, but people have managed to do it. Check this link out:

How to install VirtualCenter on Windows Server 2008?


asp.net resources -Microsoft official video, ebook and articles

What is ASP.NET?
Getting start with ASP.NET
How to Install ASP.NET and Tools


Fundamentals of ASP.NET Web Forms (135 video clips)
There are several topics with free download clips in WMV format and WMA format for iphone/ipod. Details as below:
Topic: Getting Started with ASP.NET 3.5 and Visual Web Developer 2008 Express
Number of video clips: 16
Topic: TailSpin SpyWorks Sample Application

Number of video clips: 5

Topic: Master Pages
Number of video clips: 10

Topic: ASP.NET 3.5
Number of video clips: 26

Topic: How Do I?
Number of video clips: 88

Related downloading:
If you are interested in ASP.NET MVC, here are the videos:
ASP.NET MVC: Total Control and Standards Friendly

800+ hours video download:
ADO.NET video:

Data Access with ADO.NET - Part 1

Visual studio express 2005 guided tour:

Working with Data in ASP.NET 2.0

【翻译】Scott Mitchell的ASP.NET2.0数据教程中文版索引


protect your vbscript

Encode vbscript to VNE file:

convert vbscript to exe:

Decode all files encoded (original version) with screnc.exe


Setup group policy for outlook 2007

Establishing Group Policies for Outlook 2007


By default, the group policy does not contain any Outlook 2007 specific settings that you can use to lock down Outlook’s configuration settings. Microsoft does however offer a set of administrative templates for Office 2007 (of which Outlook is a part) that you can download for free from Microsoft's site. You can then use these administrative templates to add Outlook specific settings to the group policy.

Download outlook 2007 administrative templates: