What you've just described sounds like a classic example of an Accumulating Snapshot fact table as described by Kimball. This would be a fact table modeling a multi-step process having...

I'm not sure if this would apply to your specific scenario, but the application can switch out the database name in the connection string.

So, it looks like perhaps v.Next just a re-branding of the Community Technology Preview (CTP) program?

I'd rather work in an organization where the DBA is expected to be a part time developer than I would work with developers who are part time database administrators.

Windows itself doesn't really need that 150 GB, does it?
The data space previously allocated by the dropped index will simply be re-allocated as the remaining tables and indexes grow...

For a performance reasons, if you're going to code a query with multiple conditional predicated in the WHERE clause, then understand it probably would not be 'sargable', so make the...

Your background sounds typical of most BI professionals. Don't forget to read Kimball's data warehouse toolkit book, and also try to focus less on database administration and more on ETL...

My periods of unemployment have been brief and far between, but what it has taught me is the following:

- If you're not interviewing, eating, or sleeping, then you...

Assuming you're using a version control system, a visual difference comparison across commits helps tremendously. Also, it helps when each commit has a descriptive comment, because (at least in TFS...

I've dealt with BigInt identifiers a lot when I worked in the healthcare industry, and I've seen Entity-Attribute-Value modeled tables accumulate several billion rows within the first couple years of...