new features

Why Python and how to use it in SQL Server 2017

Microsoft has integrated Python in SQL Server 2017 which can be used for in-database analysis purpose. In this post, we are going to explore “Why Python and how to use it in SQL Server 2017”, and then we will explore that how we can use it in SQL Server 2017. Why Python Python is a […]

Why Python and how to use it in SQL Server 2017 Read More »

STRING_SPLIT function – SQL Server 2016

Finally, STRING_SPLIT function, one of the most awaiting feature for a long time, has been introduced by Microsoft. In SQL Server 2016, now, we have a built-in system function to split a string with a specified separator. Earlier, whenever we had to map a denormalized string (e.g. comma separated string values) with the values stored in a table column (normalized

STRING_SPLIT function – SQL Server 2016 Read More »

DATEDIFF and DATEDIFF_BIG – SQL Server 2016

We are already familiar with DATEDIFF function introduced in the very initial version of SQL Server. But, in SQL Server 2016, Microsoft has introduced DATEDIFF_BIG function which can be used to compute the difference between two given dates in terms of the given date part. In this post, we are going to explore the use of

DATEDIFF and DATEDIFF_BIG – SQL Server 2016 Read More »

New features in SQL Server 2014 (In Database Engine)

New features added in SQL 2014 (Headings only) Below are the enhancement points list : Database Engine Feature Enhancements o    Memory-Optimized Tables o    SQL Server Data Files in Windows Azure o    Host a SQL Server Database in a Windows Azure Virtual Machine o    Backup and Restore Enhancements o    New Design for Cardinality Estimation o    Delayed Durability

New features in SQL Server 2014 (In Database Engine) Read More »