David Wiseman

Dotnet build issue with system database reference.

9

- SqlPackage or DacFx Version:0.1.3-preview - .NET Framework (Windows-only) or .NET Core:.NET Core - Environment (local platform and source/target platforms): Windows **Steps to Reproduce:** 1. Create a new database project...

If the GUI is unable to connect the the repository database an error occurs and the GUI is loaded without any instances. This could be improved with a connection test...

``` System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.Int32'. at DBADash.DBADashAgent.update(String connectionString) in D:\a\dba-dash\dba-dash\DBADash\DBADashAgent.cs:line 108 at DBADash.DBADashAgent.GetDBADashAgentID(String connectionString) in D:\a\dba-dash\dba-dash\DBADash\DBADashAgent.cs:line 44 at DBADash.DBImporter.updateInstance(DataRow& rInstance) in D:\a\dba-dash\dba-dash\DBADash\DBImporter.cs:line 445...

The user might be prompted to save changes if the newly serialized object is different from the one on the disk. This might occur if a new property is introduced....

Connect dialog will fail to list databases if the selected database doesn't exist 

Agent job collection can be slow on servers with large numbers of jobs

4

SMO performance in enumerating jobs can be slow. This can slow down the other collections that are batched with the same start time. Look at options to improve the performance...

SerializedDataSetViewer can be used to view the xml files that DBA Dash writes to S3 or folder destinations. DBA Dash also writes these files to the Failed folder if there...

RDS Instance check issue if server name is changed.

1

Issue/PR for first responder kit: https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/3140 https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/pull/3146/files DBA Dash also uses the server name to identify RDS instance and will have a similar bug. This probably won't impact many people....

From reddit > [r-NBK](https://www.reddit.com/user/r-NBK/) > I would recommend you look into switching your WMI calls over to CIM calls. Much easier to get access through firewalls... Defined ports via WSMan...

dbo.DatabaseBackup performance issue with large numbers of databases

5

If you have a very large number of databases, one of the validation checks experiences significant performance issues which can add minutes to the execution time. Under the section "Check...