My PASS Summit 2017 Experience

All the excitement and countdown for attending PASS Summit is finally over, and I must say I had a great time attending my first PASS Summit this year. Three cheers to everyone in #SQLFamily who directly/indirectly contributed towards the success of this event. It was a 4 days marathon with events starting as early as […]

PASS Summit Day 1 Microsoft Keynote – Recap

The Keynote from Microsoft Team was something which I was looking forward to with an expectation to learn more about Microsoft investment in SQL Server, the latest innovations and see the latest & greatest feature set in SQL Server 2017. There were some nice takeaways for me from this session and I have noted them down in this blog post. If you want to listen to the Keynote, I think it is also available in PASS TV.

STRING_SPLIT function in SQL Server 2016

As a developer, have you ever written your own customized string splitting function in your code? Do you still have comma separated values stored inside your database columns? If the answer to any of these questions in YES, then you will be happy to know that with SQL Server 2016, we have finally got a built-in function which takes care of this overhead.

Troubleshooting long running queries in SQL Server

Diagnosing performance issues with long running queries is challenging. Generally for troubleshooting a query performance, we look at the execution plan generated by the T-SQL query and then identify the expensive operators. However for a long running query, where we have to stop the T-SQL execution prior to its completion, there is no execution plan generated. Live Query Statistics in SQL Server 2016 comes to our rescue in such scenarios.