SQL Server Infernals – Circle 6: Environment Pollutors

Don’t tell me that you didn’t see it coming: at some point, Developers end up being put to hell by a DBA! I don’t want to enter the DBA/Developer wars, but some sins committed by Developers really deserve a ticket to the SQL Server hell. In particular, some of those sins are perpetrated when not even a single line of code is written yet and they have to do with the way the development environment is set up. [Read More]

Error upgrading MDW from 2008R2 to 2012

Some months ago I posted a method to overcome some quirks in the MDW database in a clustered environment. Today I tried to upgrade that clustered instance (in a test environment, fortunately) and I got some really annoying errors. Actually, I got what I deserved for messing with the system databases and I wouldn’t even dare posting my experience if it wasn’t cause by something I suggested on this blog. [Read More]