Comments
Sort by recent activity
Hello, Thank you for your inquiry into SQL Monitor. Unfortunately, there is no way of viewing Trace Data if an Alert wasn't raised. Apologies for the inconvenience this may cause. Best, Dustin / comments
Hello,Thank you for your inquiry into SQL Monitor.Unfortunately, there is no way of viewing Trace Data if an Alert wasn't raised.Apologies for the inconvenience this may cause.Best,Dustin
Hello, I wanted to follow up with you on this bug, this should be resolved in the latest release of SQL Prompt. Best, Dustin / comments
Hello, I wanted to follow up with you on this bug, this should be resolved in the latest release of SQL Prompt.Best, Dustin
Hello, We wanted to follow up on this one, our dev team has notified us they have placed this on their schedule to take a deeper look. Best, Dustin / comments
Hello,We wanted to follow up on this one, our dev team has notified us they have placed this on their schedule to take a deeper look.Best,Dustin
Hello, We have recreated this on our end and are escalating it to the dev team to look into. Best, Dustin / comments
Hello,We have recreated this on our end and are escalating it to the dev team to look into.Best,Dustin
Hello, Thank you for your inquiry into SQL Monitor. Unfortunately, there is no way of exporting the SQL Server Licensing(Estate) to a SQL table instead of a spreadsheet from SQL Monitor. It may be possible to import from xls doc to SQL table (or save the xls as csv which may be easier to import to SQL). https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-data-from-excel-to-sql?view=sql-server-ver16 I hope this information helps. Best, Dustin / comments
Hello,Thank you for your inquiry into SQL Monitor.Unfortunately, there is no way of exporting the SQL Server Licensing(Estate) to a SQL table instead of a spreadsheet from SQL Monitor.It may be pos...
Hello, Unfortunately, there is no simple way of disabling the alerts during off-peak hours as there is nothing built in by default to do this. The couple options that may be possible are. To use the PowerShell API on a schedule to disable the alert during off-peak hours and re-enable it when peak hours start. This is probably the best option as the data will be collected throughout and it is just the alert that is disabled. Though this may not work with custom alerts. Apart from that would be setting fake values in the SQL which you stated you are wanting to avoid, but adding +1 to any data in the off-peak hours so that it would always be at least 1 and just understand during offpeak hours it shows 1 more than it actually is ( the custom alert will need to be set up to fire when the value crosses the threshold 1). I hope this information helps. Best, Dustin / comments
Hello,Unfortunately, there is no simple way of disabling the alerts during off-peak hours as there is nothing built in by default to do this. The couple options that may be possible are. To use the...
Hi Surya, There were recent changes to the way information is exported to excel during the latest release but it looks to be just the way BIGINT is handled. 10.12.3.28623 - Released on 29 July 2022 Fixes
Fixed an issue where BIGINT data types were being exported to Excel in scientific notation.
Fixed a performance issue where typing in SSMS was laggy when large snippets are present.
Fixed an issue with an incorrect execution warning when using the ALTER TABLE syntax.
Added support for some SQL Server 2022 syntax, including LEDGER.
Fixed a crash that could occur when running the command line formatter.
What is the DataType that is being exported as text to excel so we can attempt to recreate it on our end? Best, Dustin / comments
Hi Surya, There were recent changes to the way information is exported to excel during the latest release but it looks to be just the way BIGINT is handled.10.12.3.28623 - Released on 29 July 2022F...
Hello, Unfortunately, it does not appear that SQL Prompt has the level of customization available to remove the spaces between the values. We are always looking for suggestions for new features and welcome you to add this as a recommendation for our development team to look into in our user's voice forum. https://redgate.uservoice.com/forums/94413-sql-prompt Best, Dustin / comments
Hello,Unfortunately, it does not appear that SQL Prompt has the level of customization available to remove the spaces between the values.We are always looking for suggestions for new features and w...
Hi Richard, Thank you for your inquiry into SQL Clone. You may be running into a limitation with SQL Clone when attempting to make modifications: "The scripts will be run with limited privileges - as a temporary user which only has permission to modify the image as db_owner, not to make changes to the server or to other databases." https://documentation.red-gate.com/clone/modifications-during-provisioning/image-modifications/t-sql-modifications I hope this information helps. Best, Dustin / comments
Hi Richard, Thank you for your inquiry into SQL Clone. You may be running into a limitation with SQL Clone when attempting to make modifications:"The scripts will be run with limited privileges - a...
Hi Richard, Thank you for your inquiry into SQL Source Control. The article below gives advice and steps on migrating to Azure DevOps: https://www.dotnetcurry.com/devops/1540/code-migration-azure-devops I hope this information helps. Best, Dustin / comments
Hi Richard,Thank you for your inquiry into SQL Source Control.The article below gives advice and steps on migrating to Azure DevOps:https://www.dotnetcurry.com/devops/1540/code-migration-azure-devo...