design

Size Matters: Table Rows and Database Data Pages

Size Matters: Table Rows and Database Data Pages

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(…)

Slides From Reno SQL Server User Group Available

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: I’m going to see about pushing many of my presentations to Slideshare in the coming months. I like the idea of Slideshare, just not sure(…)

The Accidental Architect

The Accidental Architect

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 time). I even wrote a book(…)

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

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(…)

Load More