Moving forward, I predict that cloud based database-as-a-service (DBaaS) and software-as-a-service (SaaS) solutions will become more prevalent. Implementing e-Commerce, data warehousing, or Big Data projects on-premises is complicated and too...

... Any number of other companies also use data to power their BI systems and dashboards that help their employees make better choices. That seems in contrast...

If we're talking about DML auditing, then Change Tracking can potentially give you what you need with less overhead and storage than insert / delete triggers.

Many data audit systems are created in reaction to an event, like a security breach or while troubleshooting an issue that requires detailed diagnostics. Therefore, audit processes are put in...

I doubt this was the intention of the authors, though I do hope that this doesn't prevent the use of newer tools and technologies. What I'd like to see...

The way it should work is that the users indicate what level of access they need functionally, and then you decide which role(s) to put them in. The user shouldn't...

Also, check out the website.
http://www.kimballgroup.com

All of Ralph Kimball's books are good, but I'd suggest the following as a first read, because it covers concepts of star-schema modeling, slowly changing dimensions, types of fact tables,...

I'm using Chrome. Whenever I right click within this site's post editor window, I have the menu open 'Paste as plain text'. I've found that works better than regular 'Paste'...