Jonathan Kehayias (@SQLPoolBoy) of SQLskills uses practical examples to show multiple ways to monitor Availability Group replica synchronization in your environment.
Continue Reading »Aug 312015
Aug 262015
Paul Randal (@PaulRandal) explains how to tell when CXPACKET waits are actually a problem (because, usually, they are just an indication of parallelism).
Continue Reading »Aug 182015
Tim Radney (@tradney) walks through the configuration of a new SQL Server 2016 feature, Stretch Database, and discusses some of its limitations.
Continue Reading »Aug 172015
Aaron Bertrand (@AaronBertrand) follows up on his Always Encrypted posts from T-SQL Tuesday with improved code and more information on performance and space usage.
Continue Reading »Aug 112015
Aaron Bertrand (@AaronBertrand) investigates the observable overhead involved with using a new SQL Server 2016 security feature, Always Encrypted.
Continue Reading »Aug 062015
Back in January 2015, my good friend and fellow SQL Server MVP Rob Farley wrote about a novel solution to the problem of finding the median in SQL Server versions prior to 2012. As well as being an interesting read by itself, it turns out to be a great example to use to demonstrate some
Continue Reading »Aug 042015
Glenn Berry (@GlennAlanBerry) gives a thorough guide on using DiskSpd, a command-line tool that measures the performance characteristics of your storage subsystem.
Continue Reading »