I don't doubt that.  I remember my first data warehouse.  But I got my grounding by reading the Kimball books.  While I'm happy to teach my colleagues, I'm able to...

If any part of the dimension is a type 2, it's probably a 2, and only a two.  An SCD7 would be difficult to implement (it didn't even exist until...

No, I do not agree.

Regarding the fact, if it can change, it is probably an accumulating snapshot.  You should update the changes.

Regarding the dimension, you need to determine if tracking...

• This reply was modified 2 years, 10 months ago by RonKyle.

You seem to be confusing fact and dimension tables.  A fact table cannot be 2SCD.  The "D" is 2SCD stands for dimension.

That you do this as a snapshot does NOT...

That is not enough information to suggest a design, and coming up with a design takes many hours of analysis and usually interviews to some degree.  I would suggest you...

You are asking if this approach is a good design, and I would have to say, based on what you present here (which isn't much) it is not a good...

non-sequential keyed indexes (such as Random GUIDs) are the worst thing you can do

Not sure where you are going with this one.  I've seen GUIDs used TOO many times where...

No.  I mean that as I cannot get the environmental parameters to work, I have to actually change the server names in the BIDS environment to either the dev server...

I was imprecise with flip.  I should have said "change" the server.  As there are two choices for me, it's like "flipping" a switch.

"Runtime values for package parameters and connections can be assigned from SSISDB 'environments'. These environments allow the encryption of 'sensitive' values (eg, passwords)."

I have not been able to make this...

One big con depending on what version you are doing is that in Project mode deployment of individual packages isn't possible.  You have to deploy the entire project.  This was...

Completely agree with the consistency argument.  I've seen inconsistency within even the same stored procedure written by a single person.  I also like the single letter table.  I've rarely run...

No doubt.  But the EOMONTH function could have been introduced with the presented one as an alternative.

You would be in the best position to make the justification by learning what are the new features and then seeing if you can make a business case for why...

There is an EOMONTH function to get you the end of the month.