Technology Musings
In: SQL Server
18 Aug 2009How to create a .NET user-defined function that exposes RegEx functionality to Microsoft SQL Server.
Use a CTE to recursively roll up all descendant records into separate groups, regardless of level. Example data and Common Table Expression code included.
In: SQL Server
25 Feb 2009An illustrated, step-by-step guide for connecting MySQL and SQL Server via Linked Servers utilizing the MySQL ODBC Connector driver.
In: SQL Server| SSIS
24 Nov 2008SSIS does not allow an FTP password to be set through Expressions. Fortunately, we can manually set the value stored in a variable through a Script Component.
In: SQL Server
2 Oct 2008I stumbled upon a few little gems that SQL Server 2008 includes that I hadn’t yet heard about. Although, very few are deploying SQL 2008 to production currently, these enhancements might make life programming in 2008 much easier.