Monthly Archives: March 2012

Spring SQL Server Connections / DevConnections

Posted on March 30, 2012 by

I returned late last night from the Spring DevConnections event, delivering three sessions in the SQL Server Connections conference. I talked about Encryption, Filestream/Filetable, and Contained Databases. Always cool to see your name in print It was a nice event, … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Backup and Restore

Posted on March 30, 2012 by

Today’s editorial was originally published on May 13, 2007. It is being re-run as Steve is at SQL Server Connections. I think that it’s important to practice restoring and rebuilding your systems. You never know when you’ll encounter problems and … Continue reading →

Posted in Editorial | Tagged ,

The Mechanical Turk

Posted on March 29, 2012 by

Today’s editorial was originally published on Apr 17, 2007. It is being re-run as Steve is at SQL Server Connections. I stumbled across Amazon’sMechanical Turk while helping search for Jim Gray. As a side note, Jim is still missing and presumed … Continue reading →

Posted in Editorial | Tagged

Contained Databases in SQL Server 2012

Posted on March 29, 2012 by

Abstract: One of the problems with databases in SQL Server is the dependency of the database on various parts of the host instance. In SQL Server 2012 there is an enhancement to the database format that allows for partial containment … Continue reading →

Posted in Presentations | Tagged , , , | 3 Comments

Is Computer Science Dead?

Posted on March 28, 2012 by

Today’s editorial was originally published on Apr 27, 2007. It is being re-run as Steve is at SQL Server Connections. There are less people entering Computer Science in colleges and less people interested in traditional computer science practices. There’s concern … Continue reading →

Posted in Editorial | Tagged | 4 Comments

The Encryption Primer

Posted on March 28, 2012 by

This talk deals with SQL Server encryption options. I have given a few variations, and you can get the different decks below. SQL Server has a number of encryption features that allow you to better secure your data. This session … Continue reading →

Posted in Presentations | Tagged , , ,

Unstructured Data in SQL Server

Posted on March 28, 2012 by

Abstract: More and more of our data does not fit neatly into a structured, relational model of rows and columns of data. In this session, you will learn about how SQL Server stores unstructured data, with a special emphasis on … Continue reading →

Posted in Presentations | Tagged , , , , | 3 Comments

Vendor Selection

Posted on March 27, 2012 by

Today’s editorial was originally published on Apr 29, 2007. It is being re-run as Steve is at SQL Server Connections. How you you pick a vendor for a product? Here’s how I’ve seen it work at some companies. A contract … Continue reading →

Posted in Editorial

Off to Vegas for DevConnections

Posted on March 26, 2012 by

A few last minute prep items for DevConnections and I leave in a few hours for Las Vegas. My first trip since last November, and it’s been a welcome break from being on the road. I suspect that won’t last … Continue reading →

Posted in Blog | Tagged , , ,

Google Research

Posted on March 23, 2012 by

Interesting to see someone talking about all the research Google is spending money on, which aren’t directly related to their core business. The piece is a bit of a complaint, and it’s a valid one for shareholders. Personally I like … Continue reading →

Posted in Blog | Tagged ,