Monthly Archives: March 2012

Spring SQL Server Connections / DevConnections

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

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

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

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?

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

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

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

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

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

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 ,