SQL Sentry's Aaron Bertrand (@AaronBertrand) shows DDL commands in Azure SQL Database that can now run as online operations instead of blocking, size-of-data operations.
Paul White (@SQL_Kiwi) explains various ways SQL Server makes runtime decisions about whether to use the b-tree structure or perform allocation order scans.
Glenn Berry (@GlennAlanBerry) of SQLskills.com runs down why sequential I/O throughput is critical for many SQL Server tasks, and explains how to avoid artificial bottlenecks by choosing hardware components wisely.
Glenn Berry (@GlennAlanBerry), of SQLskills, shows how to get the most bang for your buck if you plan to run SQL Server 2014 on an Azure virtual machine.
Continuing his knee-jerk series, this time Paul Randal (@PaulRandal) of SQLskills talks about SSDs, and some of the false impressions people get about them.
Paul Randal (@PaulRandal talks about Page Life Expectancy – what it is, why fixed thresholds are meaningless, when it matters, and what you can do about it – in this latest installment of his "knee-jerk troubleshooting" series.
Aaron Bertrand (@AaronBertrand) demonstrates an affordable approach to readable secondaries, without the need for Availability Groups and all the licensing costs involved with Enterprise Edition and Software Assurance.
Aaron Bertrand (@AaronBertrand) discusses examples where people expect SQL Server to perform tasks that really should be performed outside the scope of the database.
