When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio.  Read more...

RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions  Read more...

When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio.  Read more...

You need to provide data validation at the server level for complex strings like phone numbers, email addresses, etc. You may also need to do data cleanup / standardization before moving it from source to target. Although SQL Server provides a fair number of string functions, the code developed with these built-in functions can become complex and hard to maintain or reuse.  Read more...

So often, one sees developers doing repetitive coding in SQL Server Management Studio or Visual Studio that could be made much quicker and easier by using the Regular-Expression-based Find/Replace functionality. It is understandable, since the syntax is odd and some features are missing, but it is still worth knowing about.   Read more...

This Workbench is about using Regular expressions with SQL Server via TSQL. It doesn't even attempt to teach how regular expressions work or how to pull them together. There are plenty of such resources on the Web. The aim is to demonstrate a few possibilities and try to persuade you to experiment with them if you don't already use Regex with SQL Server.  Read more...