Doing a lot of Power BI work lately. Too expensive RAM? Sure, that's a thing. Too much RAM? Not a thing.

Great topic!

In our Data warehouse projects we use schemas for two purposes:

First (as already mentioned by others) to separate logical areas and at the same time simplify security administration (STAGE,...

I am using ErWin to design, forward engineer the database code and produce DB documents using the Crystal Reports edition embedded in ErWin.

Hardly ever do I need to customize the...

"field of dreams" stuff: applies to features or even systems built because IT thought it was a good idea, without previous requirements or user validation, under the expectation that "build...

We recently ran into this problem too.

We reviewed some posts suggesting you can develop SSIS packages and run them in a 32 bit instance of the SSIS engine in the...