I always just ask management if they'd eat a 2 year old egg. 😀

Maybe the native Dynamic Data Masking feature first made available in 2016 would be a good enough reason to update 2012 to 2019 sooner than later?

Welcome back, Steve!  Everything was very good and very well covered but it just wasn't the same without you.

OK, bit of a vent here, feel free to ignore me...

WHY can you not use DTUTIL to import a password-protected SSIS package?  Honestly, why?  Today I had to migrate...

Cheers Grant

Testing appears to be working, so I'm going for it. Just wondered if anyone else had tried.

I may ask a loaded question at one your SQL Bits...

Instead of using WITH (NOLOCK) on every system table, use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED for the session.  That way you don't have to worry about missing one and,...

There are a lot of disadvantages to GUIDs as key columns in indexes, especially Clustered Indexes.  They basically violate a good number of what most people consider to be desirable...

I've not studied Python but took a guess at it according to what other programs do.  Of course, that was incorrect because Python does it based on a different paradigm. ...

Security improvements and the fact that 2012 is now 7 years old.  The biggest advantage is that there are a fair number of features that were formally only available in...

Let me know how it works out for you.

I cribbed the example code given in the original post and added some line breaks.  It looks like the following...

Select LastName, EmpNumber, Granted, Denied, ID_Picture 
FROM EmployeeCards...

This is a great introduction to Indexed Views, Archana.   It's well written, the order of revelation in the article is perfect, the example code is nice and simple and very...

This is an awesome idea!  Thanks for taking the time to both suggest it and provide code for it.  I'll check out the code but, at first blush, it looks...

Nope.  I'm not saying that industry standards are bad.  Just make sure that they're not going to cause damage because, like anything else, even an industry standard can be bad/incorrect...

To bring the discussion back to topic, what I take from the examples is this: Industry standards are there for a reason. Find out what they are and follow...