User objects in the master database
Recently when doing a database upgrade for a client, I was informed that we had missed some user procedures, tables and functions in the master… Read More »User objects in the master database
XML and JSON making simple changes
As part of the XML and JSON month of blog posts, this post is going to cover how to make changes to XML and JSON… Read More »XML and JSON making simple changes
Pass Summit 2020?
PASS Summit 2020? What are your thoughts on PASS Summit 2020 as a virtual conference? I am curious to see what you think. We certainly… Read More »Pass Summit 2020?
Iterating over JSON and XML values
One handy thing when working with JSON or XML is to take part of the data and represent it as tabular data, since everything in… Read More »Iterating over JSON and XML values
Weekly Summary July 4, 2020
Here is a recap of my last week of posts. Accessing XML and JSON contentJuly 3, 2020 Building on my earlier post of JSON and… Read More »Weekly Summary July 4, 2020
Accessing XML and JSON content
Building on my earlier post of JSON and XML data, using the same table today we will take a look at accessing data. With that… Read More »Accessing XML and JSON content
July is JSON and XML month
I have decided that for the month of July I will post 31 blog entries for the month about JSON and XML. Every post will… Read More »July is JSON and XML month
SQL 2019 Page and Row Compression with XML and JSON
On a week long theme on XML and JSON in SQL Server, this is the second post. After the first post of just showing how… Read More »SQL 2019 Page and Row Compression with XML and JSON
JSON and XML in SQL Server
This post is the first in a series of blog posts around using XML and JSON in SQL Server. XML has been supported, although slightly… Read More »JSON and XML in SQL Server
June 2020 Blog Posts by Steve
At the beginning of June I realized that I was slightly behind on my blogging, so today, June 30th marks 30 days of 30 blog… Read More »June 2020 Blog Posts by Steve