(Itzik Ben-Gan) Like any programming language, T-SQL has its share of common bugs and pitfalls, some of which cause incorrect results and others cause performance problems.

(Steve Endow) I recently had a call with my friend Windi Epperson to troubleshoot an odd SQL error that was occurring when posting a Dynamics GP batch.

(Pinal Dave) Having a scattered Microsoft SQL Server database platform is cumbersome to maintain, as you continue to accumulate waste capacity to your database servers.

(Kenneth Fisher) Dem queries, dem queries, dem slow queries, Dem queries, dem queries, dem fast queries, Dem queries, dem queries, dem big queries, Now write dem crazy queries!

Microsoft first introduced backup compression in SQL Server 2008. With backup compression you can speed up our backups, while making your backups smaller.

(Pinal Dave) I like to say that I am SQL Server Performance Tuning expert but often during the conversation, I end up discussing security as well.

(blobeater) Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know about what your transaction log is doing in the cloud.

(Grant Fritchey) The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management that is 2008 or greater. Things are not the same in Azure though.

(Pinal Dave) SQL Server Performance Tuning is a much simpler job if you know exactly where to look for and how to tune the configurations.

(Denny Cherry) I was recently cleaning the house when I got a phone call from a client that I hadn’t heard from in a while. Their SAN had decided that it was going to corrupt one of the LUNs. This LUN happened to be the Log drive on one of their SQL Servers.