Where I work now, we use a SCRUM based project management and team model for developers and something more like Kanban for DBAs. I know that a couple of the...

Does then PTO policy apply to everyone in the company or only executive management?

I actually rather see a system where additional PTO is earned. For example, if a team meet their deliverable, then everyone on the team gets an extra three days of...

Andy, just to confirm you're talking about "PTO" which is Paid Time Off and not something like un-paid leave of absence?

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...