Next Meeting: Fri, Jul 25 2014
July UG meeting
Event Type: In-Person
Online Meeting URL: None
July user group meeting.
UTC : Fri, Jul 25 2014 16:30 - 18:00
Event Time : Fri, Jul 25 2014 11:30 - 13:00 Central Daylight Time
Your Local Time: Fri, Jul 25 2014 16:30 - 18:00
15 Lindsley Avenue
How In-Memory Database Objects Affect Database Design
Louis Davidson, Data Architect drsql.org
With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn't that simple, internally everything that uses this new feature is completely new. While the internals of this feature may be foreign to you, accessing the data that uses the structures very much resembles T-SQL as you already know it. As such, the first important question for the average developer will be how to adapt an existing application to make use of the technology to achieve enhanced performance. In this session, I will introduce the concepts of In-Memory Database objects, discussing how the design is affected by the new technology. As a basis for the presentation, I will start with a normalized database, and adapt the logical and physical database model/implementation in several manners, performance testing the tables and code changes along the way.
Louis Davidson has worked in the IT industry for over 15 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 10 years and has written five books on database design. He has a bachelor's degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.