Tag Archives: sql server

The Gambler

In April of this year, the SQL Intersection conference is coming to Las Vegas. I’m speaking, along with Grant Fritchey and many others. It’s a fun event, in a city with a huge variety of things to do in the evenings after a … Continue reading

Posted in Editorial | Tagged , , , , , | Comments Off on The Gambler

Self Describing Databases

When contained databases were introduced in SQL Server 2012, I thought they were a very nice enhancement to the platform. The idea of having security managed inside the database, thereby removing the problem of orphaned users, was something I looked forward … Continue reading

Posted in Editorial | Tagged , | 1 Comment

Who Built This Thing?

This editorial was originally published on May 20, 2008. It is being re-run as Steve is on vacation. I came across a humorous Tweet (since removed for some reason) on David Reed’s blog. It said: Was Microsoft SQL Server designed by … Continue reading

Posted in Editorial | Tagged | Comments Off on Who Built This Thing?

Dropping Indexes

While working on some demos recently, I needed to drop an index for a test. I executed this generic statement for an index I’d just created. 1: DROP INDEX ix_IndexName Needless to say I was surprised when I got this … Continue reading

Posted in Blog | Tagged , , , | 3 Comments