Monthly Archives: January 2011

Isolation Levels–MCM Prep

Posted on January 17, 2011 by way0utwest

I was watching the Isolation Levels video for my MCM prep and learned something about the isolation levels. I knew there were four levels, but I hadn’t realized that SQL Server used the default of level 1, out of the … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Isolation Levels–MCM Prep

ETL Security Holes

Posted on January 17, 2011 by way0utwest

The addition of DTS to SQL Server meant that more and more of us could grab data from a variety of sources, easily, and move it to SQL Server systems. SSIS enhanced our capabilities and made it fairly simple for … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on ETL Security Holes

Multi-tenant Architecture

Posted on January 14, 2011 by way0utwest

When you design a database, or at least when I do, I think it’s important to build a database schema that is flexible, and anticipates change. You can’t foresee every change required, but you can consider the types of changes … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Multi-tenant Architecture

Scaling Up

Posted on January 14, 2011 by way0utwest

For most of my production DBA career, I worked with databases whose size was measured in MB. A few got into the GB range, with the largest dataset I ever managed being 800GB. That was in the days of 35GB … Continue reading →

Posted in Editorial | Tagged | Comments Off on Scaling Up