Show 12 – The Other One Mode




SQL Server Radio show

Summary: <a href="http://traffic.libsyn.com/madeirasqlserverradio/SQLServerRadio_Show012.mp3">Download Episode (mp3)</a> Show 12 is here, and yet again we have a mix of various SQL Server topics. Among them are High Availability, development, performance, Columnstore Indexes, Azure, and general news and events. More specifically, we talk about: * How log backup and Log Shipping really work * What parts of SQL Server Memory does the Max Server Memory option controls * Performance differences between Row_Number and CROSS APPLY * A disturbing bug with the SYSDATETIME function * Clustered Columnstore Indexes, and how Rebuild and Reorganize work on them * Azure Storage * SQLRally and SQLBits conferences * And more.. Items mentioned in the show: * <a href="http://www.madeirasql.com/developer-tips-that-can-save-your-xxx/" target="_blank">Guy Glantser - SQL Server Developer Tips that Can Save Your XXX</a> * <a href="http://www.madeirasql.com/rebuilding-reorganizing-clustered-columnstore-indexes/" target="_blank">Matan Yungman - Rebuilding and Reorganizing Clustered Columnstore Indexes</a> * <a href="http://www.brentozar.com/archive/2014/12/sql-server-2012-standard-edition-max-server-memory-mb/" target="_blank">Kendra Little - Did You Give SQL Server 2012 Standard Edition Enough Memory?</a> * <a href="http://sqlperformance.com/2014/12/io-subsystem/sql-2014-on-azure" target="_blank">Glenn Berry - Running SQL Server 2014 on an Azure Virtual Machine</a> * <a href="http://www.zdnet.com/article/microsoft-says-storage-service-performance-update-brought-azure-down/" target="_blank">Mary Jo Foley - Microsoft says Storage service performance update brought Azure down</a> * <a href="http://azure.microsoft.com/blog/2014/12/11/introducing-premium-storage-high-performance-storage-for-azure-virtual-machine-workloads/" target="_blank">Azure Premium Storage</a>