Aaron Bertrand breathes some new life into his long-running SQL Server series on bad habits and best practices. The latest installment discusses the various impacts of choosing GUIDs over numeric types for keys.
Don't take SQL Server Missing Index recommendations at face value. They have numerous limitations. In this blog post, Andy Yun explores one of these: Index Key Order.
Get an overview of HIPAA regulations along with compliance tips and best practices from a healthcare legal specialist from the point of view of the DBA.
Aaron Bertrand treats a common scenario: behavior differs between two SQL Server databases that may be the same version, but different compatibility levels.