Archives

Great Links

Upcoming Presentation and Blog Events

I mentioned in the last article that I am taking a temporary break from the T-SQL Basics Series of articles. I’ll return to it in a few weeks, but in the meantime I’ve been working other stuff for your amusement.

Do you have a Zombie Database? Does your database suffer from roaming hordes of problems like the lack of primary and foreign keys, poor normalization, in place updates and deletes, and an insatiable drive to eat your braaaaaaaaaaaaaains (CPU cycles).

Fear not fellow survivor, for I’ll show you how to control the zombie apocalypse and prepare your data for use with PowerPivot, a free add on for Excel 2010. I’ll show you how to use PowerPivot to slice and dice your data and keep your users safe from the zombie databases which threaten their very way of life.

A great time will be had by all.

SQL University

My good friend Jorge Segarra (Blog/Twitter) aka SQLChicken has asked me to become a professor at SQL University. Next week I’ll present a series of articles on Dimensional Modeling Fundamentals.

Tune in and you learn the following:

Why your database sucks, and what you can do about it.

The reasons you actually have to listen to business folks.

What’s with all the dimensional modeling techno-babble? What does it really mean?

How to break a Data Warehouse project into digestible chunks so you don’t get overwhelmed from the start.

[…] This post was mentioned on Twitter by Stray__Cat, David Stein. David Stein said: Come see me present on Zombie Databases and presenting Dimensional Modeling at #SQLUniversity. http://j.mp/f108uC #sqlpass […]