SQL server 2014 is one of their measure releases. Where Microsoft has done a superb job. There are so many enhancement we have in SQL Server 2014. In my session I will show you my top 5 features.
This session will show you how the query optimizer has been updated to work with the new SQL Server 2014 features and to provide better performance to existing ones. Topics include Hekaton, the new cardinality estimator and incremental statistics.
Hekaton is the Greek word for 100 - the goal of In-Memory OLTP in SQL Server 2014 is to
improve query performance up to 100 times. In this session we will look under
the cover of Hekaton and the Multi Version Concurrency Control (MVCC)
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.
Still not sure of which is faster? Let us put this matter to rest once and for all. We will measure every single aspect of the execution of a stored procedure vs. its Ad-Hoc query counterpart, and only one will prevail!
This session will take a look at how parallel select into can be scaled to the nth degree in SQL Server such that all available hardware resources are utilised as fully as possible.
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
What is In-Memory OLTP? How is it architected? Where can I use in-memory technology in my solutions? Learn this and more from the Microsoft team
Learn how flash storage accelerates In-Memory OLTP performance. We will also cover limitations with SQL Server In-Memory OLTP.
In this session, you will learn the internals of SSIS and why having a deep understanding is important to solve performance problems, and how the control flow and data flow engine work.