Add Date Time stamp to the Windows Backup File Name

1. Use the Windows Backup GUI interface to create a backup job. Make sure to
specify that it should not run now but later.

2. Open the Task Scheduler, then open the backup job that you just created.

3. Mark & copy the whole command line.

4. Create the new batch file "MyBackup.bat"

5. Paste the backup command line into it.

6. Create some blank lines at the top of the file, then paste the following
code into the empty space.

@echo off
set MyDate=%date:/=_%_%time::=_%
ntbackup /.. /.. /.. /F d:\Backups\%MyDate%_File_Backup.bkf

7. Adjust the last line of the above code so that it matches your own
switches, then remove the original Windows Backup command line.

8. Use the Task Scheduler to create a task that will invoke
"MyBackup.bat" instead of your previous Windows Backup command

SQL 2005 : Database Mail Setup

1. Enable Database Mail feature via Surface Area Configuration for Features.
2. In SSMS, Use Database Mail Configuratin Wizard to create account and profile.
3. Select a default profile.
4. Create Operator.
5. If you would use Alert to notifiy operator, enable Mail Profile in Alert system option of SQL Server Agent.
6. Restart the SQL Server Agent.
7. You are ready to use Database Mail to notify the operator now.

ASP.NET Page Events Lifecycle

This is for my own reference purpose. The The original info comes from : http://weblogs.asp.net/ricardoperes/archive/2009/03/08/asp-net-page-events-lifecycle.aspx

When using master pages, the normal page event lifecycle is a little different. Here is the actual order:

1. Page.OnPreInit
2. MasterPageControl.OnInit (for each control on the master page)
3. Control.OnInit (for each contol on the page)
4. MasterPage.OnInit
5. Page.OnInit
6. Page.OnInitComplete
7. Page.LoadPageStateFromPersistenceMedium
8. Page.LoadViewState
9. MasterPage.LoadViewState
10. Page.OnPreLoad
11. Page.OnLoad
12. MasterPage.OnLoad
13. MasterPageControl.OnLoad (for each control on the master page)
14. Control.OnLoad (for each control on the page)
15. OnXXX (control event)
16. MasterPage.OnBubbleEvent
17. Page.OnBubbleEvent
18. Page.OnLoadComplete
19. Page.OnPreRender
20. MasterPage.OnPreRender
21. MasterPageControl.OnPreRender (for each control on the master page)
22. Control.OnPreRender (for each control on the page)
23. Page.OnPreRenderComplete
24. MasterPageControl.SaveControlState (for each control on the master page)
25. Control.SaveControlState (for each control on the page)
26. Page.SaveViewState
27. MasterPage.SaveViewState
28. Page.SavePageStateToPersistenceMedium
29. Page.OnSaveStateComplete
30. MasterPageControl.OnUnload (for each control on the master page)
31. Control.OnUnload (for each control on the page)
32. MasterPage.OnUnload
33. Page.OnUnload

Steps to install dotProject

Add "dp_user" user to the MySQL.
1) Install Apache web server.

2) Install PHP to your web server.

PHP should support GD and MySQL

3) Install MySQL.

4) Add "dp_user" user to the MySQL.

5) Create a schema (Database) "dotproject" and assign user "dp_user" has full permission of this DB.

6) Copy all dotProject files to the htdocs folder.

- Open browser to access http://Your Domain/dotProject/install/index.php

- follow the step to complete the installation.

7) The default admin login is :

User Id : admin
Password : passwd

Prepare SQL 2005 to use CLR

1) Turn on the 'clr enabled" feature of your server.

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

2) Turn on the Trustworthy property of your database if your clr assembly require access external resources.

ALTER DATABASE [DB Name]
SET TRUSTWORTHY ON

Use Diskpart to Remove EISA Partition

1. Open a command prompt as administrator.
2. Run Diskpart application by typing Diskpart in the command prompt.
3. In the “Diskpart” prompt, enter rescan command and press Enter key to re-scan all partitions, volumes and drives available.
4. Then type in list disk and press Enter key to show all hard disk drive available.
5. Select the disk that contains the partition you want to remove. So the command will be:

   select disk y
   

   Finish by Enter key.

6. Type list partition and press Enter key to show all available and created partition in the disk selected.
7. Select the partition that wanted to be deleted by using the following command, followed by Enter key:

   select partition x

   where x is the number of the EISA based recovery partition to be removed and unlocked its space. Be careful with the number of this partition, as wrong number may get data wipes off.

8. Finally, type in delete partition override and press Enter key.

Caution when upgrade WinService from .NET 1.1 To .NET 2.0

When you try to upgrade a WinService from .NET 1.1 to .NET 2.0, Please pay attention at the thread mode. In .NET 1.1, the default value of the thread mode is background. However, the default value of the thread mode is changed in .NET 2.0.

In .NET 2.0, You need to explicitly set the thread mode to background.