Archive for June, 2010

Using Web Services in SQL Server CLR assemblies

SQL Server 2005 introduced a nifty new feature called CLR Integration, which essentially allows you to write triggers, procedures and functions in managed code. So why would you want to do this? To answer that question, I’ll quote from the MSDN documentation:
Managed code is better suited than Transact-SQL for calculations and complicated execution logic, and [...]

Read more

Creating Trac tickets remotely with XML-RPC

Trac is a simple but powerful open source issue tracking and wiki system for software projects. We have used it successfully in our own internal projects and in projects for clients. Trac runs on a web server and is accessed via any browser, which means minimal deployment hassle and relatively painless upgrades. It is written in [...]

Read more