It’s Christmas: 3 Ways To Be Wise About Your Rowsize

Empty space. That’s what you have inside your database, I’m certain of it. I am also certain that you can take steps to avoid having large amounts of empty space inside of your database. The first step, as always, is admitting you have a problem. In this case that means you need to know how … Read more

Data Modeling Is Dead; Long Live Data Modeling!

Data modeling is dead. It is a product of an era that has passed; that of corporate silos that created their own versions of software to suit their own needs. That is no longer the world in which we live. That era was one that had high costs associated with building and maintaining a database … Read more

Does This Datatype Make My Column Look Fat?

Last Wednesday I delivered a webinar for Confio titled “Database Design: Size DOES Matter”. I had a piece of code at the end that evaluated defined datatypes to the current data values in those columns. The idea being that if a column is defined as BIGINT but contains values that are best defined as a … Read more

Database Design: Size DOES Matter Recording Available

The recording of my recent webinar for Confio has been made available and you can go here to register to watch (registration required, but it is FREE). Here is the abstract: “Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do … Read more