I've around 7.5 years of experience as a SQL/BI developer.I gave a session on New Analytic Functions in SQL server 2012 during SQLBits XI.I worked in SQL server 2005/ 2008/ 2008R2, 2012 and SQL Server 2014. Currently Working for QSI Healthcare (NextGen). Active Member of SQLBangalore and BDotNet user groups.
Sandip Pani has submitted 4 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions
Microsoft Microsoft Query processor team has made changes to the CE . This is one of the major change in SQL Server 2014. Even though some query may show performance issue with New CE compared to legacy CE.
Profiler is very much popular among DBA's and Developers but we have a very powerful tool that is XEvents, Which is not yet very much popular. This tool is the new Hero. I will demonstrate How to tune query using XEvents.
Hekaton is also known as In-Memory database for OLTP. This the new type of database construct designed in MS Sql Server 2014.
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.
There are new functions introduces with the release of MS-SQL Server 2012. To perform analytic operation in T-SQL , this time Microsoft has added couple of very handy functions.