MORE ABOUT ME

design Tag

Over the years I've been able to compile a list of issues that I would consider to be common with SQL Server (and other database platforms like Oracle, no platform is immune to such issues). These are the issues that are often avoidable but not always easy to fix once...

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

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

Well, I finally joined Slideshare.Here are the slides from my most recent presentation (Database Design, Size DOES Matter!) to the SQL Server User Group in Reno, Nevada last week:[slideshare id=17373029&doc=sizedoesmatter-130319122611-phpapp02]I'm going to see about pushing many of my presentations to Slideshare in the coming months. I like the idea of...

Most readers of this blog are likely to be familiar with the term accidental DBA. It is meant to describe someone that ended up in the role of database administration by pure chance. They simply happened to be in the right place at the right time (or right place at the wrong...

Your database design is awful.The reason nobody has told you this yet is for one of two reasons: ignorance or apathy. They either don't know it's bad, or they don't care.Well *I* care about bad designs, as I typically bear the burden of having to make queries run fast and...