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

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