Category: Uncategorized

The blog was down a bit today – sorry for all who got to see CLR stack traces pushed through HTTP (I *will* do a

I’ve been playing with the new grouping sets feature now that it’s in a CTP, partially because I had a small hand in them before

So there’s all sorts of legacy behaviors in SQL Server that will keep me employable for years and years because it didn’t make sense when

I previously blogged about the sequence project operator, which I helped architect/develop while working on the SQL Server QP (here).  In that same post, I

I received a comment asking about this, so I’ll write a short note on the subject. The QP will take and expand all *’s early

Had I known the number of responses I would have gotten about running SQL Server in virtual environments, I would have spent more time writing

I’d like to do a post or two on running SQL Server 2005 within a virtual machine.  Before I get into all sorts of fun

In my previous post, I talked about the basics of partition elimination and mentioned some of the challenges.  SQL 2005 does contain logic to do

Horizontal Table and Index Partitioning, where different rows in the same logical table are split into different physical tables, is an essential data warehousing tool. 

So one of the features I had a hand in building in SQL Server 2005 is really useful for helping SQL Server work well in

One of the reasons I’m posting up content like this is to help all of you learn a bit of what I have bouncing around

For a number of years, the marketing for SQL Server’s competitors made a large number of claims that SQL Server couldn’t handle “Enterprise”-scale deployments.  Over