About Show #511
SQL Server 2016 SP1 has shipped - what's new? Richard chats with Bob Ward about the latest in SQL Server, some of which was announced at the Connect event in New York. Huge on the list was the addition of many more of what was once enterprise-only features on the Standard and Express editions of the database. Bob discusses architectural changes that have come to SQL Server 2016 to better reflect the latest hardware, which has resulted in the same workloads on the same hardware actually running faster just by upgrading the database to the latest version. Finally, there's a discussion of migration and the tools available today to help you test your workloads to see any variation in behaviour for your application from one version to the next. Check it out!
Bob Ward is a Principal Architect for the Microsoft Data Group (Tiger Team) which owns the development and servicing for all SQL Server versions. Bob has worked for Microsoft for 23 years supporting and speaking on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2016. He has worked in customer support as a principal escalation engineer and Chief Technology Officer (CTO) interacting with some of the largest SQL Server deployments in the world. Bob is a well-known speaker on SQL Server often presenting talks on internals and troubleshooting at events such as SQL PASS Summit, SQLBits, SQLIntersection, and Microsoft Ignite. You can find him on twitter at @bobwardms or read his blog at https://blogs.msdn.microsoft.com/bobsql