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...

Notes from SQLRally Orlando

Tuesday afternoon started with me being an unexpected behind schedule, and then another interruption or two, but by 4:30 pm...

Please vote for my SQLPASS precon and sessions

A few days ago, SQLPASS opened the voting for the precon’s and sessions for the annual
SQLPASS community summit. I’ve also...

SQL Rally Day 1 PreCon

Yesterday was the first day of the SQL Rally conference in Orlando, FL.It was a great first day because I...

You Are Responsible for You

Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...