A while back I wrote a post on the five database design mistakes you don’t want to make. I always meant to build slides for the post but never seemed to have the time. I finally found a few odd moments here and there over the past few weeks and got a deck uploaded to … Read more
Rogue data is data that is either maintained outside of, or has simply left, the control and security measures used by your company. I have yet to meet any data professional that is comfortable with the idea that their data may have gone rogue. This is especially true whenever the subject of Cloud architecture is … Read more
It’s no secret that I hate NULL values. Well, to be clear, I hate working with NULL values. I’ve written before about why I dislike NULLs. I’ve even had public debates (which I won) about the topic. What I’ve gradually come to realize over time is that it is not the NULL values themselves I … Read more
Just a quick post today to tell you about a webinar I am doing on the 27th of August, 2014. The title is “The Real SQL Server 2014 Power Feature (It May Not Be Hekaton)”, and it is me talking about the new cardinality estimator (CE) in SQL Server 2014. You might recall that earlier … Read more
I’m on my way to the PASS Business Analytics conference today. If you are attending, and you are reading this blog post, come find me and Rob Collie (blog | @powerpivotpro) during the welcome reception on Wednesday night; we’d love to talk data. Speaking of data…I was finishing up a session at the Colorado Springs SQL Saturday recently … Read more
Having standards is important. If you don’t believe me, just ask your spouse or significant other. Knowing that such things are important I am willing to wager that your company has spent time putting together a set of standards to be followed with regards to application development, including database standards. I’m here today to tell … Read more
