SQL Server Denali High Availability Preview

Speaker: Prakash Heda, Senior DBA at Intuit

We’re starting the new year with our first look at Denali, the next version of SQL Server. Denali is now available as a Community Technology Preview, and I'm sure a few of you have started digging into the new features.

Under the hood of Denali, you can expect to find several new features, including new column-store database technology meant to enhance query performance and a new high-availability feature called SQL Server AlwaysOn.

At this month’s meeting, Prakash Heda of Intuit will talk about key High Availability and Disaster Recovery features, and give us a demo.

• Introduction to SQL Server AlwaysOn
• Overview of AlwaysOn Availability Group
• AlwaysOn Failover Cluster Instance
• Multi-Database Failover
• Multiple Secondaries
• Active Secondaries
• Fast Client Connection Redirection

Prakash Heda leads SQL DBA team at Intuit. His expertise includes Performance Tuning and troubleshooting, high availability, SAN configuration and windows administration. He has 10+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA and MCTIP. His background includes development in VB and ASP; SSIS; data warehouse development using SQL Server 2000, 2005 and 2008 R2.

The CTP1 for Microsoft SQL Server “Denali” is available here (https://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9&displaylang=en)

You can download Denali (https://www.microsoft.com/sqlserver/en/us/product-info/future-editions.aspx) and give feedback here.