devxlogo

January 22, 2000

Create a System Tray icon

Sometimes is useful to add an icon in the Window taskbar’s status area (a.k.a. System Tray), to gain a better interaction between the user and your application. The only API

PlayWAV – Play a WAV file

Const SND_ASYNC = &H1Private Declare Function PlaySound Lib “winmm.dll” Alias “PlaySoundA” (ByVal _ lpszName As String, ByVal hModule As Long, ByVal dwFlags As Long) As Long’ Play a WAV file.”

PlayAVIPictureBox – Play an AVI file in a PictureBox

Const WS_CHILD = &H40000000Private Declare Function mciSendString Lib “winmm” Alias “mciSendStringA” _ (ByVal lpstrCommand As String, ByVal lpstrReturnString As String, _ ByVal uReturnLength As Long, ByVal hwndCallback As Long) As

See Who Is Blocking Your SQL Server

If you have ever monitored any blocking problems in SQL Server, you know that sp_who only shows you the spid (SQL Server’s internal Process ID) that is causing the blocking