Once you start thinking of a table as singular, your mind shifts to RBAR instead of set thinking.

Totally disagree.

If you have the skillset in house, I highly recommend using SSIS.  If the skillset is not in house, scripts are probably preferred.  But in ETLs of any complexity, they...

I use SSMS.  My complaints are minor and I've been using it in some form for more than 20 years.  I don't want to get used to a new GUI...

They’re also a delight to the scientific and other communities because the range of dates (although I believe it uses the wrong calendar prior to the year 1753) has been...

I recently added audit triggers that had some degree of complexity.  To test the performance one of the developers issued a million inserts in a little over an hour--far beyond...

I prefer to use triggers.  They do have to be written carefully, but if done properly capture changes well.  Nulls are trickier to handle when updating data as they are...

I started with Kimballs 2nd edition The Data Warehouse Toolkit.  Taught me all I needed to know.

I've been doing this a long time and I haven't found anything "terrible" about it.  When I'm working with other naming conventions it can sometimes be hard to otherwise avoid...

I would not prefix a view with tbl.  In any case I rarely use views in an OLTP environment.  I do make extensive use of them in my OLAP designs...

The use of the prefixed "TBL_" is a design error so bad it has a name; it's called the tibble.

This is not a design error.  It does not violate the...

KpiId        (This is a foreign Key to another Dimension Table which explains the name of KPI in question

This is probably not right.  Each metric should have its own...

That worked.  Thanks.

Still shows I'm wrong, but no worries.  Not a big deal.

Can you fix my wrong answer? 🙂

I'm not sure about this.  It's a pretty common trigger to update the last updated date.  By default, that trigger does not cause the trigger to fire again.  Otherwise it...