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.
2013-04-19 (first published: 2011-10-11)
9,649 reads
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.
2011-03-03
15,100 reads
Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...
By Steve Jones
This is for me, not necessarily for you, but I decided to go with...
By Gerard
This is the fourth and final post in a series about modern Data Lake...
I recently noticed that DMVs, or at least sys.dm_db_partition_stats, does not respect snapshot isolation. ...
I have developed several stored procedures that will be utilized by developers on a...
Ask SSC