JSON Archives - {coding}Sight https://codingsight.com/category/languages-coding/json/ Blog for SQL Server DBAs and Developers Mon, 04 Sep 2023 08:08:01 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png JSON Archives - {coding}Sight https://codingsight.com/category/languages-coding/json/ 32 32 JSON in SQL Server: The Ultimate Guide to JSON Data Manipulation https://codingsight.com/json-for-sql-server/ Mon, 26 Jul 2021 12:25:10 +0000 http://codingsight.com/?p=15741 In the last few years, JSON has positioned itself as a standard data exchange format between services, although XML is still widely used. In the SQL Server 2016, Microsoft implemented JSON support directly in the database engine, and the capabilities of data manipulation are increasing in each following version. The word comes as an abbreviation …

The post JSON in SQL Server: The Ultimate Guide to JSON Data Manipulation appeared first on {coding}Sight.

]]> Query JSON Data with SQL/JSON Functions & Autonomous Database https://codingsight.com/json-query-data-with-sql-json-functions-autonomous-database/ Fri, 02 Jul 2021 10:07:43 +0000 http://codingsight.com/?p=14629 In the previous article, we worked on the Twitter Activity dataset in JSON format with the SQL Developer Web tool in Autonomous Database. However, SQL Developer Web has its limitations. It only allows you to parse the first level of the JSON data. Thus, it won’t support parsing complicated JSON structures. So, does it mean …

The post Query JSON Data with SQL/JSON Functions & Autonomous Database appeared first on {coding}Sight.

]]> Import JSON Data with SQL Developer Web into Autonomous Database https://codingsight.com/import-json-data-with-sql-developer-web-into-autonomous-database/ Thu, 10 Jun 2021 11:22:53 +0000 http://codingsight.com/?p=14591 Twitter Activity provides loads of information for analysis. You can learn your target audience better, determine the most popular content, check the right time when your visitors are more active, etc. By getting the Twitter Activity data and putting it into the advanced analytical systems, you can correlate that data with other essential information from …

The post Import JSON Data with SQL Developer Web into Autonomous Database appeared first on {coding}Sight.

]]> How to Easily Get Data from Web Source Using Power BI Rest API Calls https://codingsight.com/using-rest-api-as-data-source-in-power-bi/ Fri, 26 Feb 2021 13:57:26 +0000 http://codingsight.com/?p=12179 Microsoft Power BI is a data visualization and analytics tool which lets you create powerful visualizations with a graphical user interface. It can use a variety of data sources such as CSV, TSV, and other flat files, SQL databases, and even online sources through Rest APIs. This article explains the usage of Rest API as …

The post How to Easily Get Data from Web Source Using Power BI Rest API Calls appeared first on {coding}Sight.

]]> Basics of Working with JSON in SQL Server https://codingsight.com/basics-of-working-with-json-in-sql-server/ Thu, 23 Apr 2020 07:56:06 +0000 https://codingsight.com/?p=8562 JSON – A Brief Background JSON is an acronym for JavaScript Object Notation, that became popular a little over seventeen years ago. JSON is essentially a data format, it was popularized by Douglas Crockford, a well-known programmer with an interesting history who was also involved in the development of JavaScript. JSON has nearly replaced XML …

The post Basics of Working with JSON in SQL Server appeared first on {coding}Sight.

]]> Working with JSON in SQL Server 2016 https://codingsight.com/sql-server-2016-json-vs-xml-performance-comparison-part-6/ https://codingsight.com/sql-server-2016-json-vs-xml-performance-comparison-part-6/#comments Fri, 12 May 2017 09:52:09 +0000 http://codingsight.com/?p=1405 JSON is one of the most widely used data interchange formats. It is also a storing format in several NoSQL solutions, in particular, in Microsoft Azure DocumentDB. One of the reasons for its popularity is a simpler form and better readability in comparison with XML. Naturally, there was a need in processing data in the …

The post Working with JSON in SQL Server 2016 appeared first on {coding}Sight.

]]> https://codingsight.com/sql-server-2016-json-vs-xml-performance-comparison-part-6/feed/ 1 JSON Support in SQL Server 2016 https://codingsight.com/json-support-in-sql-server-2016/ Sat, 16 Jul 2016 15:18:18 +0000 http://codingsight.com/?p=63 SQL Server 2016 provides the built-in support for importing, exporting, parsing, and querying JSON documents or fragments. In this article, we will discuss this feature in more details! JSON (JavaScript Object Notation) is a lightweight data-interchange format that uses text name/value (or attribute/value) pairs to represent data. JSON serves as a data transmission technology that …

The post JSON Support in SQL Server 2016 appeared first on {coding}Sight.

]]>