Version 1.2.0.7 (15/12/2021) Changes

HUMMDB-700 No Comms live alert emails no longer working
HUMMDB-643 Add option to send test live alert immediately
HUMMDB-683 Add refresh button to Live Alert Monitoring screen
HUMMDB-624 Capture backup and maintenance duration
HUMMDB-696 Add DurationSeconds columns in SQLPro database audit tables and populate them
HUMMDB-687 Health report details has no heading
HUMMDB-682 Cannot click on same "View Details" on "User Query History" more than once
HUMMDB-573 Add Login type to user access report in classification report
HUMMDB-310 Backup and maintenance reporting queries need to check if SQLPro database exists
HUMMDB-695 Hide sensitive data in the classification tables using data masking

Version 1.2.0.6 (10/12/2021) Changes

HUMMDB-693 Backup and maintenance information query firing 24 times a day
HUMMDB-692 Adjust Hub to use Conductor4SQL site styling
HUMMDB-661 Online POV form doesn't have a notification that form was submitted.
HUMMDB-691 Minor improvements to POV form
HUMMDB-690 Format POV email in a human readable format
HUMMDB-650 Add Conductor4SQL hub email alerts on pov forms
HUMMDB-689 Live alerts does not allow custom queries with column names with spaces
HUMMDB-688 Implement logging in the SQLPro Hub
HUMMDB-686 Add email queue to SQLPro hub
HUMMDB-446 Add export to xlsx on all detail popup tables
HUMMDB-679 Remove report history scripts and use new KeepTableHistory flag
HUMMDB-685 Make dev Version of SQLPro use the UAT Hub
HUMMDB-680 Add UAT SQLPro/Conductor4SQL hub
HUMMDB-684 Setup Hub certificates to auto renew
HUMMDB-569 Cannot change instances from one instance type to another
HUMMDB-95 Add lead blocker detection to monitoring scripts

Version 1.2.0.5 (07/12/2021) Changes

HUMMDB-668 Cannot remove any user query schedules that have been used for email query results
HUMMDB-667 Add history tables for live alerts
HUMMDB-678 Add KeepTableHistory flag to base queries functionality
HUMMDB-666 Add additional Live alert schedules: 2 minutes, 5 minutes and 10 minutes
HUMMDB-675 SQLPro breaking when using binary server collation
HUMMDB-677 Newly installed instances getting added with SQLQueueEnabled = 0 and not processing messages on restart
HUMMDB-655 Prevent user from selecting the same schedule for query schedule and email schedule in user schedules

Version 1.2.0.4 (02/12/2021) Changes

HUMMDB-676 SQLPro certificate expired
HUMMDB-654 Query schedules are not getting refreshed on schedule change
HUMMDB-669 Admin role should not be able to see System Query History
HUMMDB-672 'Job Run Date Age Days' is incorrect in C4Sql_PBI.CM_Report_Client_Jobs_Summary_Latest_VW
HUMMDB-670 PowerBI report data for Database trends not looking correct
HUMMDB-674 SQL Server latest service pack/cu information out of date
HUMMDB-665 Improve each instance type test connection logic
HUMMDB-642 Add test connection button to add instance screen
HUMMDB-664 Add business attributes to live alert details
HUMMDB-649 Add business attributes to "SQLPro Backup & Maintenance Report"
HUMMDB-645 Add default Admin user with admin role with a strong password
HUMMDB-660 Allow exporting of C4SQL license .lic file for C4SQL client deployment
HUMMDB-659 Limit C4SQL license editing to role
HUMMDB-653 Create web Version of Conductor4SQL license editor
HUMMDB-647 Update freshdesk integration to use new product name
HUMMDB-648 Move backup and maintenance reports to Backup and Database menu section
HUMMDB-640 Email query results does not work when saving results to table
HUMMDB-646 Using old product name in Health Report

Version 1.2.0.3 (03/11/2021) Changes

HUMMDB-637 Add query result summary to User Query results attachments
HUMMDB-639 Rename business attributes in query results email
HUMMDB-633 Add hangfire job to send query results
HUMMDB-638 Add nullable int UserQueryScheduleID to dbo.SqlStatements to track past scheduled queries
HUMMDB-635 Add datatable to xlsx conVersion logic
HUMMDB-632 Allow user to set Email List when scheduling query
HUMMDB-631 Force user to set email schedule when they set query schedule
HUMMDB-630 Add ability to have attachments in mail queue

Version 1.2.0.2 (28/10/2021) Changes

HUMMDB-634 SQLPro database deployment failing on error 'Must declare the scalar variable "@fullBackupPath"'

Version 1.2.0.1 (27/10/2021) Changes

HUMMDB-626 Switching between result sets yelds no results
HUMMDB-623 Apply latest Angular and npm security patches
HUMMDB-628 Move reporting library to module in SQLPro code base
HUMMDB-625 Showing HummdbUseDatabase in query results, should be "SQLPro Use Database"
HUMMDB-627 Improve API endpoint logging
HUMMDB-620 Add business attributes to query results screens
HUMMDB-622 Get error "Conductor4SQL service failed to start, check configuration" in configuration utility even if service starts successfully
HUMMDB-621 Trying to get to the live alert edit screen via the edit icon takes you to the landing page
HUMMDB-619 Rename Admin/Groups to Admin/Instance Groups
HUMMDB-618 Email lists inconsistent and no delete confirmation
HUMMDB-617 No confirmation when deleting saved queries

Version 1.2.0.0 (07/10/2021) Changes

HUMMDB-603 Add Instance Type and business attribute columns to classification screens
HUMMDB-614 500 Server error when selecting View Query in user or system query
HUMMDB-616 Don't allow full or log backups of tempdb in backup and maintenance module
HUMMDB-607 Add business attributes to backup and maintenance screen
HUMMDB-605 Add Last backup date and Last checkdb date to database configuration screen
HUMMDB-563 Allow bulk allocation in Backup and Maintenance
HUMMDB-604 Adjust UI for backup and maintenance to have edit button rather than inline editing

Version 1.1.9.9 (04/10/2021) Changes

HUMMDB-612 Backup and maintenance screen results not populating
HUMMDB-611 Send to central process no longer working after upgrade to entity framework .net core
HUMMDB-610 Add build Version to application footer
HUMMDB-600 Use Picklist control for group assignment screen

Version 1.1.9.8 (01/10/2021) Changes

HUMMDB-609 Remove EntityFramework References
HUMMDB-598 Remove database objects and cleanup C4Sql.Core project
HUMMDB-597 Update C4Sql.SqlProcessor to use new database layer
HUMMDB-595 Move migrations to new database layer
HUMMDB-596 Update C4Sql.Business to use new database layer
HUMMDB-594 Create new Database layer for Core module
HUMMDB-589 Resize the logo and landing page files to rendered size
HUMMDB-602 Add column selector control to table wrapper component
HUMMDB-601 Index re-indexing only getting executed via backup SQL jobs
HUMMDB-592 Add confirmation dialog when deleting role, group and user
HUMMDB-588 Getting query timeouts in Query module if SQL query runs for longer than 5 minutes
HUMMDB-590 Add Roles edit screen to SQLSense
HUMMDB-599 Maintenance report data not refreshing

Version 1.1.9.7 (23/09/2021) Changes

HUMMDB-587 Create script to create database with table fragmentation
HUMMDB-451 Add schedule for reindexing tables
HUMMDB-583 SQLPro emails have humm.db in the subject
HUMMDB-527 Hummdb service doesn't attempt to auto restart if database is not accessible
HUMMDB-581 Query results tabs wrong cursor
HUMMDB-408 Add role edit screen
HUMMDB-580 Show error when trying to view access of classification table for instance types that are not yet supported
HUMMDB-584 Backup to azure making sub-folders when working with named instances
HUMMDB-582 500 error when trying to load Database Configuration screen on fresh install

Version 1.1.9.6 (20/09/2021) Changes

HUMMDB-570 Instance type dropdown not visible in dark mode theme
HUMMDB-571 Tabs in query results view are not easy to see in dark mode theme
HUMMDB-578 Application build size increased drasticly after ngx-monaco-editor upgrade
HUMMDB-577 ConfuserEX obscure project fails after .net 3.1 updates
HUMMDB-576 SQLPro database getting deployed even when no changes have occurred in the schedules
HUMMDB-575 Upgrade to angular 12
HUMMDB-567 Add Sensitive Data User Rank Report
HUMMDB-565 Add Sensitive Instance Database Rank Report
HUMMDB-572 Add 'Report Date' to classification report tables in format yyyy-MM-dd HH:mm
HUMMDB-566 Add button to view user access for individual tables in classification report
HUMMDB-564 Add database access query for classification user access reports
HUMMDB-568 Export bulk instances no longer works due to new database types

Version 1.1.9.5 (15/09/2021) Changes

HUMMDB-560 Change Service Name to Conductor4SQL Service
HUMMDB-559 Change HummdbCentral database name to CentralConductor4SQL
HUMMDB-558 Change Hummdb client database name to SQLPro
HUMMDB-561 Sign application installer with certificate
HUMMDB-562 Fix config utility name and icon
HUMMDB-555 Change folder path in installer from Hummdb to SQLPro
HUMMDB-557 Remove HomeController and use ASP.NET default spa middleware
HUMMDB-554 Replace Hummdb browser icon with Conductor4SQL icon
HUMMDB-553 Add login background image to landing page

Version 1.1.9.4 (13/09/2021) Changes

HUMMDB-549 Add dark mode logos
HUMMDB-540 Change login page logos and background image
HUMMDB-551 Setup Azure VM docker with MySQL and PosgreSQL with columns with classification issues
HUMMDB-541 Add additional icon for Data Classification module/report
HUMMDB-552 Hummdb license isn't locked to a specific instance
HUMMDB-550 Max date 9999-12-31 is invalid license expire date find valid max date for license expire date for Hummdb hub
HUMMDB-543 Hide unlicensed modules in landing page
HUMMDB-542 Add landing page for all the modules (SQLPro, SQLSense)
HUMMDB-539 Change Hummdb logo to SQLPro
HUMMDB-538 Adjust Hummdb colour pallet to SQLPro colors
HUMMDB-547 Disable functionality for modules for unimplemented client types
HUMMDB-548 Disable install of Oracle client until we can find a driver that supports transactions and multiline statements
HUMMDB-534 Create classification report query for PostgreSQL
HUMMDB-535 Create classification report query for Oracle Express Edition
HUMMDB-546 Oracle database c# driver cannot handle multiple statements in single query
HUMMDB-532 Add new instance type: Oracle Express Edition
HUMMDB-545 Transactions not working in PosgresSQL databases
HUMMDB-531 Add new instance type: PostgreSQL
HUMMDB-544 Create docker compose script for all database types supported in Hummdb
HUMMDB-533 Create classification report query for MySQL
HUMMDB-530 Add new instance type: MySQL

Version 1.1.9.3 (06/09/2021) Changes

HUMMDB-536 Backup errors in Hummdb since implementing backup to azure blob storage
HUMMDB-526 Add option to import all instances from Conductor4SQL into Hummdb

Version 1.1.9.2 (03/09/2021) Changes

HUMMDB-524 Migrate Report module to EntityFrameworkCore
HUMMDB-523 Migrate Live Alerts module to EntityFrameworkCore
HUMMDB-525 Migrate SKU module to EntityFrameworkCore
HUMMDB-529 Allow %ServerName% variable in backup and log backup path
HUMMDB-478 Add Backup to Azure Blob storage functionality to Hummdb UI
HUMMDB-528 Can no longer change Information and Sensitivity type in classification report
HUMMDB-521 Migrate Backup and Maintenance module to EntityFrameworkCore
HUMMDB-518 Make it harder to decompile hummdb
HUMMDB-493 Create small Winforms Hummdb setup utility
HUMMDB-517 If license is invalid all modules should be disabled in the UI
HUMMDB-520 Migrate Classification module to EntityFrameworkCore

Version 1.1.9.1 (19/08/2021) Changes

HUMMDB-512 Add ability to edit license types in the hub
HUMMDB-516 Add ModuleSkuRequest to the license modules
HUMMDB-514 Ensure max databases limit for backup and maintenance is handled with bulk csv import
HUMMDB-513 Ensure max instances handled with bulk csv import
HUMMDB-515 Use hangfire to check for updates hummdb hub license
HUMMDB-506 Add screen in hub to edit node licenses
HUMMDB-507 Hide unlicensed functionality for hummdb client app
HUMMDB-511 Limit the number of database backups/maintence that can be enabled based on license
HUMMDB-510 Limit the number of scheduled queries that can be enabled based on the license
HUMMDB-509 Limit number of live alerts that can be enabled based on the license
HUMMDB-508 Limit number of instances that can be installed based on the license information
HUMMDB-504 Store license file in database of Hummdb client app and add screen to refresh license
HUMMDB-503 Add endpoint in Hub to generate license file from License table
HUMMDB-505 Live alert details and email alert shouldn't have 'HummdbUseDatabase' column
HUMMDB-500 Add license table to Hummb hub
HUMMDB-497 Implement auditing for Data Classification
HUMMDB-498 Information type and Sensitivity filters not updating when verifying/unverifying columns
HUMMDB-495 Add a new role to humm, “Data Steward” role, that can only access the data classification screens.

Version 1.1.9.0 (03/08/2021) Changes

HUMMDB-425 Add hummdb installer
HUMMDB-431 Show sku prices on SKU request screen when requesting a new SKU
HUMMDB-492 Adjust table filters on classification configuration screen
HUMMDB-491 Add indicator that screen data is loading
HUMMDB-490 Allow node deactivation in Hub
HUMMDB-489 Adjust Hummdb Hub containers to auto restart
HUMMDB-488 Cannot Verify more than 2000 columns at once
HUMMDB-486 Bug: If no Azure SQL Clients classification report goes out to all instances
HUMMDB-483 Move classification report to seperate angular module
HUMMDB-484 Speed up the bulk verify/unverify process
HUMMDB-482 Data Classification report query not working on Azure SQL pools
HUMMDB-485 Classification query failing on SQL Server 2005 Versions
HUMMDB-481 Allow user to verify and unverify found classifications
HUMMDB-343 Add UTC time live alert

Version 1.1.8.0 (12/07/2021) Changes

HUMMDB-480 User query edit screen does not load the selected item after first load
HUMMDB-474 Add Use Database field to Saved user queries
HUMMDB-477 Add roles to Hummdb Hub API endpoints and prevent unauthorized people from changing administrative settings
HUMMDB-479 Hummdb Hub Minor wording changes
HUMMDB-476 Add KPI cards to classification report
HUMMDB-475 Add high level filters to classification report
HUMMDB-472 Nothing happens when clicking on the 'Refresh Report Data' button on hummdb/report/data-classification screen
HUMMDB-470 Update Hummdb Getting Started requirements
HUMMDB-471 Hummdb fails to start when CentralHummdb Database does not exist

Version 1.1.7.4 (02/07/2021) Changes

HUMMDB-468 Add report screen for data classification report
HUMMDB-467 User query errors aren't shown in their own tab
HUMMDB-466 Using ‘%’ in the Use Database fields should exclude system databases
HUMMDB-461 Add column classification query for azure instances
HUMMDB-465 Azure SQL instance type not keeping it's type on client instance edit screen
HUMMDB-464 Implement UseDatabase feature for Azure SQL
HUMMDB-460 Add ‘Use Database’ option for queries
HUMMDB-455 Backup and Maintenance still running against removed databases
HUMMDB-459 Add SQL Azure as a separate instance type
HUMMDB-462 Upgrade UI packages to resolve security issues
HUMMDB-463 Upgrade backend packages to resolve security issues
HUMMDB-458 Get Classification data query failing on older Versions of SQL server
HUMMDB-456 Get Data Classification data for all databases for all instances
HUMMDB-453 When getting list of available databases getting error and populating in table [BackupAndMaintenance].[ActualHummdbDatabaseConfiguration]
HUMMDB-449 Improve look and feel of billing calculator and ROI calculator
HUMMDB-448 Upgrade Hummdb HUB UI to resolve vulnerabilities
HUMMDB-434 Create ROI Calculator
HUMMDB-443 Add theme dropdown selector

Version 1.1.7.3 (18/03/2021) Changes

HUMMDB-438 Improve Hummdb Hub build process
HUMMDB-437 Add banners to Hummdb hub public pages
HUMMDB-432 Hummdb public calculator style tweaks
HUMMDB-435 Hummdb Hub UI does not show errors
HUMMDB-433 Add screen for configuring client (node)
HUMMDB-420 Show sku prices on when requesting a sku API
HUMMDB-427 Make smaller Version of Hummdb calculator that is available to the public

Version 1.1.7.2 (11/03/2021) Changes

HUMMDB-430 Hummdb Pending and Error messages getting marked as Cancelled on service shutdown
HUMMDB-429 When a server has no comms show the past comms error instead of pending
HUMMDB-428 No Comms live alert does not give comms error
HUMMDB-423 Allow editing and updating of available sku items
HUMMDB-426 Getting 500 error when adding a new instance
HUMMDB-424 Hummdb Price calculator UI
HUMMDB-422 Hummdb Price calculator API

Version 1.1.7.1 (02/03/2021) Changes

HUMMDB-421 Allow assigning a billing configuration to a node backend
HUMMDB-419 Add sku billing to billing configuration screen
HUMMDB-418 Add billing pricing editor screen in hub
HUMMDB-416 Refactor Hummdb Hub UI code
HUMMDB-415 Fix project code style
HUMMDB-414 Prevent non select statements from commiting changes in live alerts
HUMMDB-400 Make live alerts work on Azure SQL where possible
HUMMDB-407 Freshdesk integration part 2
HUMMDB-374 Integrate Service SKU request with Freshdesk
HUMMDB-404 Add basic dark theme
HUMMDB-392 Upgrade frontend to angular 11

Version 1.1.7.0 (17/02/2021) Changes

HUMMDB-320 Importing of large numbers of instances is very slow
HUMMDB-403 Move backup and maintenance report logic to Backup and Maintenance Module
HUMMDB-379 Split Maintenance between Integrity checking and index rebuilds
HUMMDB-402 Hangfire schedules firing before hummdb completed starting up

Version 1.1.6.9 (16/02/2021) Changes

HUMMDB-398 Prevent a backup/maintenance from running multiple times in one window
HUMMDB-399 Weekly failover job is hardcoded to run on Sundays
HUMMDB-397 Backup/Maintenance windows that run over midnight not calculating correctly
HUMMDB-33 Add SQL job backup and maintenance failover for SQL Server Standard plus instances
HUMMDB-388 Save to table needs to auto add columns if the table already exists
HUMMDB-393 Remove @ng-bootstrap/ng-bootstrap package dependency
HUMMDB-394 Replace 'angular-bootstrap-toasts' with primeng toasts
HUMMDB-396 Hummdb Service not starting up on Windows startup
HUMMDB-395 Backup and Maintenance history not populating if the backup/maintenance happens at certain times
HUMMDB-391 Upgrade frontend to Angular 10
HUMMDB-390 Test hummdb with central on SQL Azure

Version 1.1.6.8 (05/02/2021) Changes

HUMMDB-377 Create Daily humm DBs Backup and Maintenance snapshot
HUMMDB-386 Cannot select midnight or 1am for backup/maintenance window
HUMMDB-383 When filtering results on backup-and-maintenance/database-configuration screen the selected group should effect the exported list
HUMMDB-382 When DISABLING backup and maintenance configurations in bulk we get an error "'SQL Server 2005' not supported"
HUMMDB-385 When add a new instance or multiple new instances there is no acknowledgement message
HUMMDB-380 Create pov form prototype on hub app
HUMMDB-381 Standard user should be able to see audit report
HUMMDB-354 Replace logout icon
HUMMDB-378 Add "Hummdb Enabled" toggle on health dashboard
HUMMDB-292 Implemented auotmatic SSL certificate renewal and change domain to hub.hummdb.com
HUMMDB-376 Make Hub.Hummdb auth callback dynamic