4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Sandip_Pani.JPG

Sandip Pani

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).  Member of SQLBangalore and BDotNet user groups. 
http://sqlcommitted.com http://sqlcommitted.com/feed/
Sandip Pani has submitted 4 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending 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.

Previous Sessions

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.

Blog posts RSS

SQL Server – Index Hint 01 Jan 2014
SQL Server query optimizer decides which index to use, when a query is requested. SQL Server optimizer is a cost based optimizer so it picks the index which has low cost based on performance. When we design an index for a query, optimizer will utilize the defined index to generate the plan for ...

SQLCommitted 2013 in review 31 Dec 2013
SQLCommitted 2013 annual report prepared by wordpress. Here’s an excerpt: The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 11,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 4 sold-out performances for that many ...

SQL Server – Identity Property Part – 3 06 Dec 2013
This is third part of this blog series. You can read the 2nd part here (SQL Server: Identity Property Part – 2). In this blog post we’ll learn how to retrieve last generated identity value. There are scenarios where we need to fetch the last inserted identity value, for example in a transaction we ...

SQL Server: Identity Property Part – 2 03 Dec 2013
In this blog series, I’m covering all about Identity property. This is the second part of this series. You can read the first part here (SQL Server: Identity Property Part – 1). After reading this post you will know 5 facts about Identity column. Fact 1- By default both Identity seed and increment ...

SQL Server: Identity Property Part-1 08 Aug 2013
Identity property is one of the most frequently used properties to generate auto increment value. I’ve seen sometime developer get confused with it. So this blog series will help developers to know everything about Identity property. Syntax: IDENTITY [(seed, increment)] You must specify both the ...