Month: June 2005

June 29, 2005

Wouldn’t it be nice if you have a mechanism to notify users that are connected to your SQL Server? Here’s a stored procedure that an help you do that task. CREATE PROC spSendNetworkNotification@Message VARCHAR(200)ASBEGIN SET NOCOUNT ONDECLARE @ShellCommand VARCHAR(350)DECLARE @MessageSource SYSNAMESELECT @MessageSource= min(RTRIM(@MessageSource))FROM master.dbo.sysprocesses (NOLOCK)WHERE @MessageSource <> ”WHILE @MessageSource is not nullBEGIN    SET @ShellCommand=‘EXEC master.dbo.xp_cmdshell “NET SEND […]

Continue Reading
June 26, 2005

“Welcome Zach to blogworld!…” Finally, Zachary Hunter , A senior programmer analyst in Sand Diego, CA has started his first blog! Zach is a friend(BOSS) of mine who has alot to say about tech stuff and best practices on developing applications. I hope to see more and more post from his blog since he has someone of the […]

Continue Reading
June 23, 2005

The guys from Gudu software has just released an application that generates well-formated sql statements for use on applications. This tool can format your sql statements to any language. The program supports C#, VB/VB.NET, ASP, Java and Delphi. It even utilizes the StringBuilder object if its available for the selected language. And best of all, IT’s FREE! […]

Continue Reading
June 23, 2005

This is an interesting piece of sql, the function accepts a string and removes HTML elements that is inside the string. This is genereally useful when you have data that has embedded HTML content on it. The function was written by Robert Davis. /****** Object: User Defined Function dbo.fnStripTagsScript Author: Robert Davis, robertd@realtechllc.com Purpose: Strip HTML tags […]

Continue Reading
June 9, 2005

SharpChess is an Open-Source game wholely developed using C#. This application was developed by Peter Hughes. I’m really impressed on how he implemented some stuff in the program. One thing that really captured my eyes is clarity of how he implemented the computation of the best possible move. the function he used is listed below: […]

Continue Reading