.NET 2008

Q : How to auto start service after installing?

A :

Private Sub ServiceInstaller_AfterInstall(ByVal sender As System.Object, ByVal e As System.Configuration.Install.InstallEventArgs) Handles ServiceInstaller.AfterInstall

Dim controller = New ServiceController("SERVICE NAME")
controller.Start()

End Sub

Q: How to get Next Weekday date ?
A :
DateAdd("ww", 1, Now)

"yyyy" Year
"q" Quarter
"m" Month
"y" Day of year
"d" Day
"w" Weekday
"ww" Week
"h" Hour
"n" Minute
"s" Second

SQL Server Statement

Q: Reset the auto-increment identity value.

A: "DBCC CHECKIDENT (table_name, RESEED, 0)"

Ref : http://technet.microsoft.com/en-us/library/ms176057.aspx