Month: September 2017

Speaking at Gulf Coast Code Camp 2017

The Gulf Coast Code Camp is a free one-day code camp being held at the University of South Alabama, Mobile, Alabama. This will be Mobile’s largest technical event in 2017 and a great networking opportunity. There will be quality talks on Web Development, Cloud Technologies, DevOps, Database, Front end technologies and more. If this interests you, make sure you register and also help spread the word in social media.

Attach to Process in Visual Studio 2017 not working

I started seeing a weird issue while working in Visual Studio 2017 few days back. I was not able to attach to running processes with the Visual Studio debugger. The IDE used to freeze/hung each time I tried to do so. The ‘Attach to Process’ window used to come up but it was blank and all I saw was the spinner – eventually the screen became unresponsive after some time.

JSON_VALUE Function in SQL Server 2016

SQL Server 2016 provides built-in support for storing, managing and parsing JSON data. Sometimes you might need to just extract one scalar value from the JSON data, instead of parsing and returning the entire data. In such cases, you can effectively use a new function in SQL Server 2016 called JSON_VALUE().

ISJSON Function in SQL Server 2016

SQL Server 2016 provides built-in support for storing, managing and parsing JSON data. Lot of web services and Web APIs are using JSON these days, primarily as their data interchange format. The inability of the older versions of SQL Server to parse, store and process JSON data has been a hindrance. This makes the integration of JSON tinto SQL Server as one of the most popular features of SQL Server 2016.

SSMS 17: Built-in Performance Dashboard Reports

SQL Server Performance Dashboard Reports are used to monitor and resolve performance issues in your Database Server. They are generally targeted towards a Database Administrator, and enabling them to quickly identify any performance bottlenecks in the system, gather diagnostic information that can potentially help to resolve the issue.

SSMS 2017 – Number of affected rows

SQL Server Management Studio is an integrated environment for managing any SQL infrastructure, from SQL Server to SQL Database. SSMS 17.2 is the latest version of SQL Server Management Studio. It provides support for almost all features on SQL Server 2008 through SQL Server 2017.