Monthly Archives: January 2017

SQL Server 2016: JSON integration

Abstract This article helps to explain the application of JSON data and the use of new SQL 2016 constructs that enable an integration of JSON data into a relational schema. The idea behind this article is to list as many … Continue reading

Posted in JSON, SQL, SQL 2016, T-SQL | Tagged , , , , , , , , | Leave a comment

SQL Server: How to backup and replace text in all search string matching Stored Procedure(s)

Table of Contents Problem Statement:- Solution:- Generate script for matching search string of all SP’s Using sp_helptext Using system view sys.procedures Generate modified SP’s script Create Linked Server Alias Conclusion References Problem Statement:- After SQL Server Migration or database rename … Continue reading

Posted in SQL | Tagged , , , | 1 Comment

My Interview published on Microsoft Technet Blog

Wish you a Happy New Year to all the readers and technical enthusiasts!!! https://blogs.technet.microsoft.com/wikininjas/2017/01/02/interview-with-a-sql-server-expert-and-wiki-ninja-prashanth-jayaram/ My interview is published on the Microsoft Technet blog yesterday    

Posted in GENERAL | Leave a comment