Changing the Past

This Friday Steve Jones explores archived data. Can you restate past results or change old data? This week Steve Jones asks how data professionals feel about this and what guidance they give to their customers.

Disk Partition Alignment–MCM Prep

Does disk partition alignment matter to SQL Server? Without a doubt. When new disk partitions are created, there could be...

The Face of BI for SQL Server

Donald Farmer recently left Microsoft, and he will be missed, but Steve Jones knows that there will be new faces to get to know.

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.