Monthly Archives: June 2017

Overview of Resumable Indexes in SQL Server 2017

Posted on June 26, 2017 by Prashanth Jayaram

Managing indexes is a critical component of database maintenance but we often don’t think about the indicators behind the index maintenance operations. SQL Server 2017 (CTP 2.0) introduces a very useful index feature, to mitigate the administration overhead of index maintenance which … Continue reading →

How to use Python in SQL Server 2017 to obtain advanced data analytics

Posted on June 20, 2017 by Prashanth Jayaram

On the 19th of April 2017, Microsoft held an online conference called Microsoft Data Amp to showcase how Microsoft’s latest innovations put data, analytics and artificial intelligence at the heart of business transformation. Microsoft has, over the last few years, … Continue reading →

Posted in Python, SQL Server 2017 | Leave a comment

Top string functions in SQL Server 2017

Posted on June 8, 2017 by Prashanth Jayaram

SQL Server 2017 has been in the talk for its many features that simplify a developer’s life. With the previous versions, developers had to write T-SQL, or user-defined functions using temporary tables, and build complex logic, just for string manipulation. … Continue reading →