Biases in naming database objects

Introduction Over my whole software engineering career, I have watched and learned the right way and the wrong way to style and format code. Especially when it comes to naming objects. There has been ...

RedGate SQL Compare – Index was out of range error

Problem This was a weird one because it is clearly a bug in the software. I am running version 13.6.1.7928 Professional of RedGate SQL Compare and I kept getting this error after performing an upgrade...

Straight to the Point: Query for Database and Table Sizes

I love how I have to search too much to find simple information, one liners, it is just like in College where my college course book would be about 100,000,000,000 pages long and really it says absolu...