Integrating Regular Expressions with SQL A number of people have responded with their take on the use of Regular Expressions in SQL. Many point out how valuable Regular Expressions have been to them using engines already supporting regular expressions. Others extend on this with links to CLR user defined Regular Expression extensions for SQL Server 2005 and later. Based on […]

Is Entity Framework the Next ODBC? What made ODBC a viable technology? It created a single interface for which drivers could be written allowing access to a data store. ODBC drivers were written for text files, Excel Documents, Microsoft Exchange, ISAM Files, Relational Databases, and much more. The key was, there was a common interface used by an ODBC consumer; […]

Should SQL Support Regular Expressions? One of my smaller goals for this year is to become more proficient using Regular Expressions. Spending a majority of the last two decades in pure SQL allowed me to miss this gem. As I use Regular Expressions more and more, I have come to appreciate the elegance of the utility, and wonder how it […]

Goals for the New Year 2012 is here. So, what’s going to make it any better than 2011? Or, was your 2011 so great that you don’t think it can get any better? I’m curious what you are doing to change your world this year. I’d like to collect ideas from our readers to see if I can find any […]

System Testing – What to test? You can’t test everything. That is a given. Even with some of the simplest software, the number of permutations for which tests could be written is astronomical. There is also a limited amount of time to execute your tests for them to be practical. Some engines perform faster than others. Still, if it takes […]