Expert Roundtable: The ROI on SQL Server 2016
1. On a scale of 1-10, how vital is upgrading to 2016 in your opinion? Denny: 9-10. This release is probably the biggest release we’ve seen since SQL Server 2005. Every system upgraded will benefit; from the improvements in Clustered ColumnStore, to increased throughput in Always On Availability Groups, to the enhancements of In Memory […]
SQL Server 2016 Database Mail Not Working
One of the nice things about SQL Server 2016 is that .NET 3.5 is no longer required for installation. The .NET requirement wouldn’t have been problematic, but in order to add the .NET feature access to the Windows media was required (this was particularly painful in Azure VMs). Fortunately the product team eliminated the requirement […]
Stopping Azure Services Automatically
Like most speakers who give presentations using Microsoft Azure, I’ve managed to leave services running for days (or weeks) without realizing it. To help solve this I put together a run book that runs in our Azure account and which runs every night. It turns off VMs, scales SQL DBs down to the basic size,…
The post Stopping Azure Services Automatically appeared first on SQL Server with Mr. Denny.