What is all this random crap?

I've decided to start posting all the fun issues and topics I've had with Microsoft SQL hoping that it could help some poor soul (or my future forgetful self) that has to figure this stuff out. Do note that the solutions I find might only pertain to my environment and it may not fix others. Cheers.