Glenn Berry talks about the blazing speeds of the latest Intel Optane gear from Intel, and how they can improve your SQL Server workloads.
SentryOne Data Scientist Fred Frost shares some of the conceptual details of the development of SentryOne Storage Forecasting. Get a first-hand look at the work that went into making these models useful and trustworthy.
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 […]