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'...

Jobs are something that tends to get modified in production without going through the normal change control process. For example, at 2:00am the DBA might disable the job or alter...