Category Archives: JSON

How to Capture Database(s) usage stats using sp_spaceused and PowerShell

The objective of this article is to look at the possible ways of capturing database usage trends using the most commonly available tools and techniques. The integration of SQL, the use of sp_spaceused, and the flexibility offered by PowerShell have … Continue reading

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

Illustration of an example availability monitoring service Using PowerShell and SQL

This article discusses a simple solution of how to monitor SQL service availability across multiple servers and reporting. To build this I’ll use SQL Server with simple PowerShell script and cmdlets which generate JSON data and displays results in HTML … Continue reading

Posted in JSON, SQL | Tagged , , , | Leave a comment

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

XML-> JSON document Example

Convert the XML document to JSON document example <person> <name>John</name> <age>25</age> <address> <city>New York</city> <postalCode>10021</postalCode> </address> <phones> <phone type=”home”>212-555-1234</phone> <phone type=”mobile”>646-555-1234</phone> </phones> </person>   { “name” : “John”, “age” : 25, “address” : { “city” : “New York”, “postalCode” : … Continue reading

Posted in JSON | Tagged , | 1 Comment