Explicitly naming CL key columns in NC indexes – when and why
This morning, as I was prepping for my PASS Data Architecture Virtual Chapter presentation on “Why Physical Database Design Matters,” I went to tweet that
This morning, as I was prepping for my PASS Data Architecture Virtual Chapter presentation on “Why Physical Database Design Matters,” I went to tweet that
IMPORTANT NOTE: Be sure to read the ENTIRE post as there’s a workaround that QUERYTRACEON is ALLOWED inside of stored procedures… just NOT in an
There are so many exciting things going on this year and it’s just getting started! If I’m being honest, I haven’t been as excited for a new release
As we head into our 7th SQLintersection this April, I’m excited to say that it’s one of our most diverse, complete, and information-packed shows yet!
Well, I had a second post already planned and partially written but a comment on the first post (in what’s going to become a multi-part series)
Today I ran into a really interesting locking / blocking problem that I want to discuss… originally, a related discussion came up last week in our IEPTO1 course (Immersion Event
In Nov 2014, SQLskills made an offer to user group leaders to deliver remote user group sessions in 2015 and we’ve been having great fun delivering
I’m not sure about how to title this OR how to avoid the term “it depends” but I also don’t feel that “it depends” is
I can’t believe we’re already approaching our 5th co-located SQLintersection & DEVintersection events… if you’re interested in how we got here – check out some of my
I received a great question in email and it’s something I cover in our IEPTO1 (Immersion Event on Performance Tuning, Part 1) so I thought
It’s been a busy few weeks… and it all came together amazing well last week as we had our twice yearly SQLintersection
[NOTE: Update 12 Nov 2014. The most recent bug (KB article KB2965069) is THANKFULLY very unlikely for most environments (mentioned below). As a result, I’m glad
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.