Category: Past Events

All past events

100 Times Faster: Experiences Making SQL Server Fly

Download the presentation: 100-times-faster-experiences-making-sql-server-fly-sql-saturday-prov-2015-12-12 How do you go about making a program run a lot faster!  Like 100 times faster?   It’s difficult.  Microsoft tried in the Hekaton project, its in-memory tables feature of SQL 2014, and they got close.  Inspired by that effort, this presentation… Continue reading

Entity-Attribute-Value (EAV): The Antipattern to Great to Give Up

Download the presentation: entity-attribute-value-eav-the-antipattern-too-great-to-give-up-andy-novick The Entity-Attribute-Value (EAV) is a design pattern for relational databases that uses an extreme form of normalization to achieve flexibility and the ability to efficiently store temporal data that changes frequently.  EAV has its critics and the flexibility it provides creates… Continue reading

SQL Server In-Memory Tables

SQL Server In-Memory Tables(Hekaton) Andy Novick April 2015 SQL Server 2014 aimed to improve OLTP performance by adding In-Memory tables and native compilation of the stored procedures that use them.  In-Memory tables bring incredible speed for the right workload so long as a series of… Continue reading

SQL Server 2014 In-Memory Database (Hekaton)

Join me as I discuss SQL Server 2014’s new In-Memory option for tables with the natively compiled stored procedures. This features allows up to 25 times the performance of traditional disk based tables for OLTP workloads. Presentation at the New England Microsoft Developers SQL Server… Continue reading