The Great Giveaway continues...

Ever tried to get unique items out of the events table in SQL Notification Services?

Use the greatest EventBatchId with EventCount greater than 0 from the EventBatches table, to identify the latest set of events written to the Events table.

The Current Events table will have the events trapped by the events query at runtime, however the records are temporary and get dumped to the events table. The above method is the best way to locate the latest events.

Ciao for Niao

Ever tried updating a solution from Source Safe and get a dialog box asking to redeploy a website/virtural directory to another location? (usally the same name suffixed with an underscore and a number)

Well, to redeploy the website to the same URL, go to the directory and delete the project file (*.csproj or *.vbproj...). You may then go back to the dialog box and fix the URL to publish back to the original path. The project will deploy successfully.