What Are You Waiting For?

I know what I am waiting for. I know exactly what every SQL Server instance in my care is waiting...

An Update To My Previous Post

I have picked Row compression and moved it out of [Primary] and into its own FileGroup and .NDF file.  I’ve...

Notes from SQLRally Orlando–Part 2

Everything went well on Thursday. No major delays at check-in was a good start, and everything going according to plan....

Project Management: Dedicated vs. Shared Resources

As an infrastructure type person, I typically represent a "shared" resource. What that means is I'm not dedicated to just...

Re-blog – May 6-12

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts...

SQLRally is A Smashing Success!

Yesterday I presented Understanding Storage Systems and SQL Server and had a fantastic time! The crowd was great and was...

SSAS error when processing the cube

Every couple of weeks I see this SSAS error when processing one of my cubes:
Internal error: Invalid enumeration value. Please call...

A curious case of a missing configuration group.

G’day,
I recently received a brand new windows 7 virtual machine for my every day work use and one of the first things...

Clean Code is Easier to Read – SQL Prompt

I saw a post recently that had query that looked like this:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b

where permission_name...

Locking While Dropping or Altering an Index

Yesterday I was trying to drop some hypothetical indexes in production against a fairly active table. I started causing blocking...