Monica Rathburn (@SQLEspresso) talks about a few of the more common elements she always checks for when troubleshooting I/O problems.
Glenn Berry (@GlennAlanBerry) provides the SQL Server DBA some insight into the ever-changing world of hardware and infrastructure.
Erin Stellato (@erinstellato) looks into sparse columns in SQL Server – the changes to space requirements and the impact on the write portion of your workload.
Kevin Kline (@kekline) answers several questions from his recent webinar on I/O latency with Tegile's Sumeet Bansal.
Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader, and Microsoft, the innovation leader. Amazon has carved out a niche as the value leader in cloud-based database management, supporting not only its own implementations of
Glenn Berry gives a thorough guide on using DiskSpd, a command-line tool that measures the performance characteristics of your storage subsystem.
Originally appearing in my monthly column at Database Trends & Applications magazine. Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging. Why turn off the transaction log? It is the main guarantor of transactional consistency