One of the common task that I have come across is the need to convert a list of results into a comma separated list. There are many ways to use this, one if which is in reports. Download the AsCSV.sql …
Converting part of a result set to a comma separated list Read more »
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 in TSQL.We will be using the same sample data from the original post with a …
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 SQL Server works better as a table, pulling values out and representing them as a …
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 contain something that compares and contrasts or explains something about JSON and XML in SQL …
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 to store these values in the database I am going to take a look at …
SQL 2019 Page and Row Compression with XML and JSON Read more »
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 clunky since SQL Server 2005, and it has not changed much. Later versions of SQL …
Today I had the opportunity to complete and launch the February 2017 version of Database Health Monitor. I hope you like the latest version. Here are the Release Notes: Version 2.5 Release Notes – February 2017. Version 2.5 is the …
February 2017 Release of Database Health Monitor Read more »
One of the common task that I have come across is the need to convert a list of results into a comma separated list. There are many ways to use this, one if which is in reports. Download the AsCSV.sql …
Converting part of a result set to a comma separated list Read more »
Teaching the Maintaining SQL Server 2005 class tonight. Week 3 – Creating Tables – Data Integrity, and XML Here is the slide deck for the class tonight. DBA_Essentials_Class03_Creating_Tables_Data_Integrity.pdf