SQLBits 2013

New Analytic Functions in SQL server 2012

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.

In this session I'll be exploring all of the below new analytical functions of SQL server 2012.

CUME_DIST

LEAD LAG FIRST_VALUE LAST_VALUE PERCENTILE_CONT PERCENTILE_DISC PERCENT_RANK

I'll be explaining how this functions works , where we can use these functions. How we were achieving the same in earlier version and now how simple it is to achieve the same.

Sandip Pani's previous sessions

Art of Feature Engineering- For Machine Learning

The most challenging area of machine learning are Data acquisition, Feature extraction, Feature Selection. Almost in all data science project, 80% of time people spend in Data acquisition and Feature engineering.

My top 5 new features in 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.

New Analytic Functions in SQL server 2012

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.