It’s late but I need to say some words about our local tech event, it is the only one that...

Afterthoughts: SharePoint Saturday Tampa 2011

This past Saturday June 11th, 2011 I had the opportunity to co-present at SharePoint Saturday Tampa thanks to a special invitation...

Database Documentation with a Data Dictionary Part 2

A continuation of the data dictionary discussion with information about how the documentation is done.
Today I’m going to continue discussing...

Moving On To New Challenges

After nearly five and half years, I left NewsGator Technologies for a new position as a Database Architect at Avalara,...

Non use of persisted data

Working at a client site, that in itself is good to say, I ran into a set of circumstances that...

PASS Update #56-SQLRally 2012 Site Selection

Note: This is a good, bad, and ugly post. We took some chances, got some things right, got more than...

Speaking at SALSSA June 15th 2011:Understanding Storage Systems and SQL Server

I am very exicted to be speaking at the San Antonio PASS chapter SALSSA! It’s been way to long and...

SQL Server Instant File Initialization (PQW)

Bluntly put, this is something that you always want to be taking advantage of.
As a Database Administrator I’m always on...

SSAS - Understanding KeyColumns Dimension Property

For many Analysis Services developers building dimensions with many attributes and hierarchies is something that comes as second nature to...

SSAS Maestro - Day 1 - Redux

Well it’s been an exciting couple of weeks leading up to this course. We have tweaked what we could in...