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

I'm constantly learning out of necessity, but unless I'm stuck in a waiting room or airplane, I do practically no technology related reading outside work; it's part of my day...

For classic fiction, I'd recommend "It Can't Happen Here" by Sinclair Lewis.
For fantasy / scifi, I'd recommend "The Liveship Traders Trilogy" by Robin Hobb.
For self improvement, I'd recommend...

It's worth noting how many top SQL Server experts thrived over the past 20 years while knowing next to nothing about MDX, NDX, and BIML. Should R and Python be...

Regarding the ATM hack cited, it seems to me that the vulnerability has more to do with a machine design that allows someone to patch in a laptop, and also...

We typically implement mixed authentication, having an 'SA' account that is never used except in an unusual situation, like when there is an issue with the domain controller or the...