Upgrading SQL Server: How much technological debt do you owe?

Many organisations avoid or delay upgrading their SQL Servers, as they often consider the task a challenging and potentially risky proposition. It is important to understand that upgrading is almost certainly the less risky option in the long run!

Technology is always improving; it stops for no-one. The longer we wait to upgrade to new technology, the more “technological debt” we incur, making upgrading even more challenging and risky.

Continue reading

An ACID Trip: How SQL Server Transactions Work

In a recent consulting engagement a system administrator asked me “what’s the point of the transaction log? ” followed by “do we need it?” and “can’t we delete it?”

Continue reading