skip to content
Covid-19 virus
COVID-19 Resources

Reliable information about the coronavirus (COVID-19) is available from the World Health Organization (current situation, international travel). Numerous and frequently-updated resource results are available from this WorldCat.org search. OCLC’s WebJunction has pulled together information and resources to assist library staff as they consider how to handle coronavirus issues in their communities.

Image provided by: CDC/ Alissa Eckert, MS; Dan Higgins, MAM
XML and JSON recipes for SQL Server : a problem-solution approach Preview this item
ClosePreview this item
Checking...

XML and JSON recipes for SQL Server : a problem-solution approach

Author: Alex Grinberg
Publisher: [Place of publication not identified] : Apress, 2018.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved! This book shows how to take advantage of XML and JSON to share data and automate tasks. JSON is  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Grinberg, Alex.
XML and JSON recipes for SQL Server.
[Place of publication not identified] : Apress, 2018
(OCoLC)1005101677
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Alex Grinberg
ISBN: 9781484231173 1484231171
OCLC Number: 1016156247
Description: 1 online resource
Contents: Part I: XML in SQL Server --
1. Introducing XML --
2. Building XML --
3. Manipulating XML Files --
4. Shredding XML --
5. Modifying XML --
6. Filtering XML --
7. Improving XML Performance.- Part II: JSON in SQL Server.- 8. Constructing JSON --
9. Converting JSON to Row Sets --
10. Modifying JSON.
Responsibility: Alex Grinberg.

Abstract:

Tagline: Ready-to-run solutions for busy developers  Read more...

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


\n\n

Primary Entity<\/h3>\n
<http:\/\/www.worldcat.org\/oclc\/1016156247<\/a>> # XML and JSON recipes for SQL Server : a problem-solution approach<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:CreativeWork<\/a>, schema:Book<\/a>, schema:MediaObject<\/a> ;\u00A0\u00A0\u00A0\nlibrary:oclcnum<\/a> \"1016156247<\/span>\" ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/4680162247#Topic\/json_document_markup_language<\/a>> ; # JSON (Document markup language)<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/4680162247#Topic\/computers_general<\/a>> ; # COMPUTERS--General<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/4680162247#Topic\/xml_document_markup_language<\/a>> ; # XML (Document markup language)<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/dewey.info\/class\/006.74\/e23\/<\/a>> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/4680162247#Topic\/databases<\/a>> ; # Databases<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/4680162247#Topic\/microsoft_programming<\/a>> ; # Microsoft programming<\/span>\n\u00A0\u00A0\u00A0\nschema:author<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/4680162247#Person\/grinberg_alex<\/a>> ; # Alex Grinberg<\/span>\n\u00A0\u00A0\u00A0\nschema:bookFormat<\/a> schema:EBook<\/a> ;\u00A0\u00A0\u00A0\nschema:datePublished<\/a> \"2018<\/span>\" ;\u00A0\u00A0\u00A0\nschema:description<\/a> \"Part I: XML in SQL Server -- 1. Introducing XML -- 2. Building XML -- 3. Manipulating XML Files -- 4. Shredding XML -- 5. Modifying XML -- 6. Filtering XML -- 7. Improving XML Performance.- Part II: JSON in SQL Server.- 8. Constructing JSON -- 9. Converting JSON to Row Sets -- 10. Modifying JSON.<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:description<\/a> \"Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved! This book shows how to take advantage of XML and JSON to share data and automate tasks. JSON is commonly used to move data back and forth between the database and front-end applications, often running in a browser. This book shows all you need to know about transforming query results into JSON format, and back again. Also covered are the processes and techniques for moving data into and out of XML format for business intelligence and other purposes, such as when transferring data from a reporting system into a data warehouse, or between different database brands such as between SQL Server and Oracle. Microsoft intensively implements XML in SQL Server, and in many related products. Execution plans are generated in XML format, and this book shows you how to parse those plans and automate the detection of performance problems. The relatively new Extended Events feature writes tracing data into XML files, and the recipes in this book help in parsing those files. XML is also used in SQL Server\'s BI tool set, including in SSIS, SSR, and SSAS. XML is used in many configuration files, and is even behind the construction of DDL triggers. In reading this book you?ll dive deeply into the features that allow you to build and parse XML, and also JSON, which is a specific format of XML used to transmit objects in a web-friendly format between a database and its front-end applications. What You Will Learn: Build XML and JSON objects in support of automation and data transfer Import and parse XML and JSON from operating system files Build appropriate indexes on XML objects to improve query performance Move data from query result sets into JSON format, and back again Automate the detection of database performance problems by querying and parsing the database?s own execution plans Replace external and manual JSON processes with SQL Server\'s internal, JSON functionality.<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:exampleOfWork<\/a> <http:\/\/worldcat.org\/entity\/work\/id\/4680162247<\/a>> ;\u00A0\u00A0\u00A0\nschema:genre<\/a> \"Electronic books<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:inLanguage<\/a> \"en<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isSimilarTo<\/a> <http:\/\/www.worldcat.org\/oclc\/1005101677<\/a>> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"XML and JSON recipes for SQL Server : a problem-solution approach<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:productID<\/a> \"1016156247<\/span>\" ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/dproxy.library.dc-uoit.ca\/sso\/skillport?context=138827<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/public.ebookcentral.proquest.com\/choice\/publicfullrecord.aspx?p=5205506<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/search.ebscohost.com\/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=1663934<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/doi.org\/10.1007\/978-1-4842-3117-3<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/resolver.library.cornell.edu\/cgi-bin\/EBookresolver?set=Books24x7&id=138827<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/link.springer.com\/book\/10.1007\/978-1-4842-3117-3<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/proquest.safaribooksonline.com\/9781484231173<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/cornell-library.skillport.com\/skillportfe\/main.action?assetid=138827<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/www.books24x7.com\/marc.asp?bookid=138827<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/link.springer.com\/book\/10.1007\/978-1-4842-3116-6<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9781484231173<\/a>> ;\u00A0\u00A0\u00A0\numbel:isLike<\/a> <http:\/\/bnb.data.bl.uk\/id\/resource\/GBB8O3791<\/a>> ;\u00A0\u00A0\u00A0\nwdrs:describedby<\/a> <http:\/\/www.worldcat.org\/title\/-\/oclc\/1016156247<\/a>> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n\n

Related Entities<\/h3>\n
<http:\/\/dewey.info\/class\/006.74\/e23\/<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/dproxy.library.dc-uoit.ca\/sso\/skillport?context=138827<\/a>>\u00A0\u00A0\u00A0\nrdfs:comment<\/a> \"eBook available for Durham College via Skillport. Click link to access<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/4680162247#Person\/grinberg_alex<\/a>> # Alex Grinberg<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Person<\/a> ;\u00A0\u00A0\u00A0\nschema:familyName<\/a> \"Grinberg<\/span>\" ;\u00A0\u00A0\u00A0\nschema:givenName<\/a> \"Alex<\/span>\" ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Alex Grinberg<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/4680162247#Topic\/computers_general<\/a>> # COMPUTERS--General<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"COMPUTERS--General<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/4680162247#Topic\/databases<\/a>> # Databases<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Databases<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/4680162247#Topic\/json_document_markup_language<\/a>> # JSON (Document markup language)<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"JSON (Document markup language)<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/4680162247#Topic\/microsoft_programming<\/a>> # Microsoft programming<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Microsoft programming<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/4680162247#Topic\/xml_document_markup_language<\/a>> # XML (Document markup language)<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"XML (Document markup language)<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/resolver.library.cornell.edu\/cgi-bin\/EBookresolver?set=Books24x7&id=138827<\/a>>\u00A0\u00A0\u00A0\nrdfs:comment<\/a> \"Connect to full text. Access restricted to authorized subscribers.<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9781484231173<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"1484231171<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9781484231173<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/www.worldcat.org\/oclc\/1005101677<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:CreativeWork<\/a> ;\u00A0\u00A0\u00A0\nrdfs:label<\/a> \"XML and JSON recipes for SQL Server.<\/span>\" ;\u00A0\u00A0\u00A0\nschema:description<\/a> \"Print version:<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isSimilarTo<\/a> <http:\/\/www.worldcat.org\/oclc\/1016156247<\/a>> ; # XML and JSON recipes for SQL Server : a problem-solution approach<\/span>\n\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n