SQL is a lot like HTML, I'm sure they don't want to get too far ahead of the ANSI standards and end up with a lot of proprietary extensions in...

Careful challenging the wisdom of the gods.

This should basically be it.

ALTER Function [dbo].[RemoveNumericCharacters](@Temp VarChar(1000))
Returns VarChar(1000)
AS
Begin

Declare @NumRange as varchar(1000);

SET @NumRange = '%[^0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9][^0-9]%';
While PatIndex(@NumRange, @Temp)...

You'll need to post T-SQL for RemoveNumericCharacters() function, that's where the coding will go.

You can leverage the PATINDEX and SUBSTRING functions for this.

DECLARE @s-2 VARCHAR(500)= 'The quick brown foxes ssn is 111111111 or 111-11-1111 for your info';
DECLARE...

What's interesting is how these misguided policies actually encourage bad SQL programming practices.

Hey, boss-man, when...

Typical programming books like "Database Programming with C#" may cover data modeling to come extent, but it's more of an afterthought and rather sparse.

Ralph Kimball has some excellent...

Perhaps the best way to proliferate a process is to make tools for the process ubiquitous. There is a rudimentary Database Diagram tool in SSMS, but it hasn't changed in...

I do believe that predictive analytics (non domain specific) can be leveraged to improve the optimization of databases and data storage systems, and do some extent that's been around for...

JavaScript and LINQ are just window dressing for SQL, just like in the construction industry stucco is dressing for (not a replacement for) solid brick.