SQL Supper with our hosts 7Digital
Nearest Tube : Old Street.
18:00 Registration, hello & welcome
18:15 David Williams :New Features of SQL Server 2014 DB Engine not including Hekaton
New Features of SQL Server 2014 DB Engine not including Hekaton
- Backup Enhancement (Azure, Encryption)
- Partition Switching and Indexing
- Managing the lock priority of online operations
- Columnstore indexes (updatable, Archival data compression)
- Incremental Statistics
- Security Enhancements
- AlwaysOn enhancements
- Buffer pool extension onto SSDs
- Resource Governor enhancements for physical IO
- Improved optimizer with new costings.
David is a cross product dba (SQL Server,DB2,Oracle,Informix,Sybase) who has worked for 20 years as a DBA for both private,local government and central government customers and now works at a leading investment bank. Certifications include MCSE 2012,MCITP SQL Server 2008 DBA and Developer, MCTS 2008 BI as well as certifcations in other products.
19:30 Chris Adkin : Column Store and Optimizer Mode : Deep dive
A deep dive into the scalability of queries using column store index and the optimizer batch mode. This will include how these features behave with different types of storage and along the way stack dumps will be used to provide insights into the database engine that other more standard tools cannot provide.
Chris is an independent SQL Server consultant with over thirteen years worth of SQL Server experience, Chris's particularly area of interest in SQL Server is performance and scalability.