What is Microsoft Business Intelligence? I’m not asked this question very often because it’s typically an assumption. As we know, assumptions can lead to misguidance or misrepresentation of a topic. This topic has been defined in so many different way…

Remember this article, “Comparing the Chicago Highway System to your Disaster/Recovery”? Well, today, as with most days that I drive to the office or a client, the drive was lengthy and I started to compare the complete system of driving to a topic. …

Database design is the foundation on which we can build a successful initiative for maintenance and scalability.  Administrators have the ability to maintain indexing, statistics, integrity checks and so on, but if a database is designed extremely poorl…

We got a question today from a user who wanted to display counts of zero where dates were missing. For example if you had the following data OrderDate SomeCount 2013-01-01 2 2013-01-02 2 2013-01-03 1 2013-01-05 2 2013-01-07 1 2013-01-08 1 2013…

This is day sixteen of the SQL Advent 2012 series of blog posts. Today we are going to look at the lack of database design and normalization. Normalize untill it hurts, denormalize until it works