Transaction Log Files

Skunk Works

The idea of a skunk works is to build a project that works under the radar, by a small and loosely organized group of people. Used to fuel innovation, this is an idea that you might apply to SQL Server BI projects.

You Need Two SLAs for Disaster Recovery

Continuing on with my MCM prep, I was listening to the High Availability/DR prep module today and I was once...

Data Scientists

Would you want to be a data scientist? Are you one now? Steve Jones talks about this skill that we might appreciate in our daily work.

ETL Security Holes

The growth of ETL processes and secondary systems for reporting, decision support and other analysis creates an issue. Steve Jones points out that we ought to be remembering that security needs to be applied to data, not just systems.

Isolation Levels–MCM Prep

I was watching the Isolation Levels video for my MCM prep and learned something about the isolation levels. I knew...

The Spring Semester

SQL University is kicking off their spring semester, and Steve Jones is looking to motivate you to participate.

Restore

Multi-tenant Architecture

When you design a database, or at least when I do, I think it’s important to build a database schema...

Scaling Up

Would you want to manage a VLDB? Or write the code for an application that uses one? This Friday Steve Jones asks the question of you.