How To Restore/Backup SQL Database From/To Remote Server Did you ever need to restore a SQL database from a backup (.bak) file which is located on another remote server? Or let's be more gener...

How To Create SQL Custom User-Defined Aggregate Functions Code samples on this post can be downloaded from here Sometimes you need to perform some complex SQL queries depending on some agg...

How To Call WCF Web Service With Authentication Credentials When you deal with WCF web services, sometimes you need to call a web service with certain authentication credentials -username (with/witho...

How To Apply Recursive SQL Selections On Hierarchical Data Sometimes we work on systems where a hierarchical data structure exists on some entities like employees and their managers. Both employ...