For the last part in my series on using a calendar table, and with some help from Itzik Ben-Gan, I describe how you can solve complex scheduling problems.
While I previously promoted a way to stop storing database name in your Extended Events sessions, there's an upside to collecting it: the ability to filter. Read on for more info.
We had a case where we increased a varchar column's size, ONLINE, but it caused significant downstream effects. See why.