XML

Converting part of a result set to a comma separated list

by SteveStedman
May 13, 2021November 29, 2022
TSQL

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… Read More »Converting part of a result set to a comma separated list

XML and JSON making simple changes

by SteveStedman
July 9, 2020July 9, 2020
JSON and XML month, TSQL

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

Iterating over JSON and XML values

by SteveStedman
July 6, 2020July 8, 2020
JSON and XML month, SQL Server, TSQL

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

July is JSON and XML month

by SteveStedman
July 2, 2020November 29, 2022
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

by SteveStedman
July 2, 2020July 2, 2020
JSON and XML month, TSQL

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

by SteveStedman
July 1, 2020July 2, 2020
JSON and XML month, TSQL

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

February 2017 Release of Database Health Monitor

by SteveStedman
February 19, 2017February 19, 2017
2 Comments
Database Health

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, released on February 19, 2017.

What People Are Saying About Database Health Monitor

Outstanding app. Already referred it to several friends in the field. Well I do have to say the changes you have made (regarding version 2.5), seems to have made everything in the interface much snappier. Your work here is quite impressive. (Frank from Texas)
Outstanding! Besides enjoying the layout of your app, one thing I really like about the Quick Scan Report is each entry has a corresponding link that discusses the finding so I can go back and review recommendations, cautions, etc. (Michael)

New Features in 2.5

Upgraded application to use the .Net 4.5 runtime.
Fragmented Indexes Advisor – added buttons to rebuild or reorganize all fragmented indexes. Wow this will save some time when you have a bunch of indexes to defragment.
Added historic monitoring for disk space. Still need to add reports, but the tracking is there.
Added a menu to the main application window. Removed the big buttons for Connect, Settings, and About, and replaced them with menu items.
Added a menu item to link to the feedback survey.
Rearranged some of the columns on the What is Active report to make it easier to see what is running right away without scrolling.

Converting part of a result set to a comma separated list

by SteveStedman
October 22, 2011May 3, 2018
TSQL

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… Read More »Converting part of a result set to a comma separated list

Creating Tables – Data Integrity, and XML

by SteveStedman
April 14, 2009November 20, 2011
Classes

Teaching the Maintaining SQL Server 2005 class tonight. Week 3 – Creating Tables – Data Integrity, and XML Here is the slide deck for the… Read More »Creating Tables – Data Integrity, and XML