Kevin Kline Updates us on SQL Server

.NET Rocks!

• Episode: Kevin Kline Updates us on SQL Server
• Website: .NET Rocks!
• Feed URL: http://www.pwop.com/feed.aspx?show=dotnetrocks&filetype=master
• Duration: 00:58:00
• Published: 2013-05-30 06:00

Carl and Richard talk to Kevin Kline about the latest features in SQL Server 2012. The conversation starts out talking about the new features that developers will love, like windowing - no need for cursors anymore, you can request a window of records from a set and move easily window-to-window. Kevin also talks about the new column store index that is especially useful with repeating data. There's also a discussion on the role of SQL Server in an increasingly NoSQL world, along with cool new technologies like Hadoop, Cassandra and Hekaton. Kevin closes with an offer of some free tools at SQL Sentry, including Plan Explorer, a tool to help you understand the query plans that SQL Server makes from your queries. Check it out!