Does TDE really work on MDF files?

Yes, it does. However, let’s prove it. First let’s create a database, a table, and enter some data:
-- create a...

The Vacation Dilemma

Does vacation cause extra stress at your job before or after you leave? Steve Jones asks a poll question this Friday to see how you feel. This editorial was originally published on June 12, 2008. It is being re-run as Steve is traveling.

Adding Data to Filestream with T-SQL

I’ve written on how to enable Filestream and how to add a filegroup, but I haven’t touched the Filestream impact...

Flight Data

Travel can be stressful and complicated. As much as computer systems have made things easier, when they fail, your trip can turn awful in a hurry.

Natural Data

Can you own data itself or patent it? There's a Supreme Court case dealing with this right now. Steve Jones notes that the outcome could affect our jobs as we deal with more and more data and laws to control data are enacted.

A Billion Transactions

A billion transactions is a lot of activity on your database, however Steve Jones thinks more and more of us might see this on a regular basis. Microsoft's facilities group shows this to be the case.

Doing Your Job

I wish this were the mantra of all people, but certainly those in technology:

Filed under: Blog Tagged: career, syndicated

Upgrading to 2012

Are many people upgrading to SQL Server 2012? Is it worth the cost for your company for any existing instances? Steve Jones asks the question this week.

Asking for Interview Questions

When someone asks for interview questions on the web, it seems many people are upset. But should they be? Steve Jones points out there are different sides to this.

SQL Saturday #175–Fargo

One of the goals early on with SQL Saturday was to spread them far and wide. Andy Warren and I...