How to find the current profile required to send an email in SQL Server

Problem You are trying to send an email using “msdb..sp_send_dbmail” but you keep getting one of the following errors: Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 107 [Bat...

A very simplistic explanation of events in C#

Introduction If you just want to see the code involved, go to the end of this article. I am really writing this for myself because on the rare occasion that I have to rely on events for something, I a...

Working example of how to fix ID3v1 and ID3v2 tags with TagLib#

Introduction I bought a bunch of albums from Japan recently for an excellent band named Maximum The Hormone – (マキシマム ザ ホルモン) aka MTH. If you have watched Season 2 of Death No...

WCF Security: Requiring Authorization to lock down your Exposed Services

Introduction WCF Security is definitely not something that can be picked up easily. It isn’t plug and play or something that can simply be turned on or off; and it most definitely is not easy to...

Query SQL Server using PowerShell

I don’t understand why it was so difficult for me to find an example on this, so I compiled one from three posts so I could put it here: [crayon-5f94129688cb6412992706/] Enjoy...

Extension Methods: Straight to the Point!

I kept looking at many articles on extension methods and for some reason I couldn’t get mine to work. It then dawned on me that the class where you declare you extension methods MUST BE STATIC. ...

UPDATE SELECT FROM JOIN

This is something that I don’t do often, but it pops up every now and again. I always forget how to do it, so I have to look it up each time. Here is an example: [crayon-5f941296892f3224577282/]...