The default insights included in sqlops provides a widget called "all-database-size-server-insight". It could be useful to have a DB size widget to show on the database dashboard.

Type: Pie Chart
Value: Used space as % of total space

Could try a doughnut and include Data and Log space as separate values.

Need to configure AppVeyor for this project.

As we are moving to new separate projects the code should be archived and comments made to the README

The following are the new projects:

• sqlops-alwayson-insights
• sqlops-mssql-instance-insights
• sqlops-mssql-db-insights

The alwayson-ag-db-rpo-rto widget doesn't fit too well when running as a Bar due to the labels.

Currently it is defined as:

"type": {
                        "bar": {
                            "dataDirection": "vertical",
                            "dataType": "number",
                            "legendPosition": "top",
                            "labelFirstColumn": false,
                            "columnsAsLabels": true
                        }
                    },

This should be changed to be:

"type": {
                "horizontalBar": {
                    "dataDirection": "vertical",
                    "dataType": "point",
                    "legendPosition": "bottom",
                    "labelFirstColumn": false,
                    "columnsAsLabels": true
                }
            }

Along with AppVeyor we should configure CodeCov and Reviewable

In preparation for Version 0.3.0.0 we want to move all our documentation into the Wiki.

This will provide the following benefits:

• Separation of code and documentation
• Easier packaging of extension for distribution

We need to decide if we are splitting the extentions out into individual projects.
if we do then the project should be renamed

The current sql query used in XEL only supports SQL Server on-premises not Azure SQL DB.

Information on what is needed is at
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-xevent-code-ring-buffer

For the alwayson-insights widgets we should move the Legend to below the pie chart.

Current value: "legendPosition": "top"

Suggested value: "legendPosition": "bottom"

During development it was identified that the TSQL query for the System Health Session XEL widgets do not have any filtering. Might need to add something like this to filter by the last few hours.

AND DATEADD(mi,@UTCDateDiff,EventXML.value('(/event/@timestamp)[1]','datetime')) >= DATEADD(mi, -120, GETUTCDATE())

The SQL Ops Studio extension support is now official. Need to update this project to move to the new format.

Reference: Kevin Cunnane - Writing a SQL Operations Studio Extension in 15 minutes

Need to review and update documentation for new capabilities and fixes for v0.2.0.0

• General Readme.md
• Widget documentation
• Change log

In the detail fly-outs where we have an expression using anything but equals it doesn't set the icon. This needs further investigation.

Now that the extension support and marketplace is complete in SqlOps Studio we can publish the extension to the marketplace.

Reference: Kevin Cunnane - Publishing an extension for SQL Operations Studio

The query is returning NULL values for the [Longest Pending Request File] and [Longest Pending IO Duration] in some cases. This breaks the line chart visual.

One solution is to add ISNULL around the fields and default to 0.