How can we help you today? How can we help you today?
DustinM
Activity overview Badges (0) Posts (0) Comments (66)

Comments

Sort by recent activity
Hi Aaron, Thank you for your inquiry into SQL Prompt we are sorry to hear it is giving you trouble. We unfortunately were unable to replicate the issue on our end regarding the tabs not being the correct color when connected to a database using SSMS 18.12.1 and SQL Prompt 10.12.2 and may need a little more information to hopefully narrow down the issue. We have opened a case and sent an email to inquire for further information. Best, Dustin / comments
  1. Community
  2. SQL Prompt
  3. Tab coloring lag in SSMS 18.12.1
Hi Aaron,Thank you for your inquiry into SQL Prompt we are sorry to hear it is giving you trouble.We unfortunately were unable to replicate the issue on our end regarding the tabs not being the cor...
0 votes
HI Craig,   Thank you for your inquiry into SQL Source Control.   The article below may help with the git error you are seeing: https://github.com/actions/checkout/issues/766   Workaround: Other steps are failing Since we don't persist that configuration, you may still see this error if your job uses git commands outside of the checkout action. If so, you just need to set the configuration value yourself. Simply set the GITHUB_WORKSPACE as a safe directory. git config --global --add safe.directory "$GITHUB_WORKSPACE" If your github workspace starts off with // , you may need to set it via git config --global --add safe.directory "%(prefix)/$GITHUB_WORKSPACE"   A little more detail about setting a safe repository is located here: https://git-scm.com/docs/git-config/#Documentation/git-config.txt-safedirectory   I hope this helps.   Best,   Dustin    / comments
  1. Community
  2. SQL Source Control
  3. Can't commit to local repository, owned by someone else
HI Craig, Thank you for your inquiry into SQL Source Control. The article below may help with the git error you are seeing:https://github.com/actions/checkout/issues/766  Workaround: Other steps ar...
0 votes
Hi Chris, Thank you for checking that, we may need more information on this one since we can no longer replicate this scenario on our end and will be reaching out via email. Best, Dustin / comments
  1. Community
  2. SQL Prompt
  3. Formatting problem
Hi Chris,Thank you for checking that, we may need more information on this one since we can no longer replicate this scenario on our end and will be reaching out via email.Best,Dustin
0 votes
Hi Chris, We were able to reproduce the formatting problem as described. We have escalated this to our dev team for further investigation and will follow up once more information has been made available. Best, Dustin / comments
  1. Community
  2. SQL Prompt
  3. Formatting problem
Hi Chris,We were able to reproduce the formatting problem as described.We have escalated this to our dev team for further investigation and will follow up once more information has been made availa...
0 votes
Hi Chris, Would you be able to update to the most recent version of SQL Prompt v10.12.3 and see if the issue is still occurring? Best, Dustin / comments
  1. Community
  2. SQL Prompt
  3. Formatting problem
Hi Chris,Would you be able to update to the most recent version of SQL Prompt v10.12.3 and see if the issue is still occurring?Best,Dustin
0 votes
Hi Chris, Could you confirm which version of SSMS and SQL Prompt you are currently using? Best, Dustin / comments
  1. Community
  2. SQL Prompt
  3. Formatting problem
Hi Chris,Could you confirm which version of SSMS and SQL Prompt you are currently using?Best,Dustin
0 votes
There are a few things we can do to check what is happening with the webhooks.   Can you run the script below against the base monitor database to check if the webhook is enabled?   SELECT 'Root' Level, NULL Name1, NULL Name2, NULL Name3, alert.Alert_Type.AlertType, alert.Alert_Type.Name AS 'Alert Name', SubType, Configuration, Enabled, AlertNotification, EmailAddress, Version, WebhookEnabled<br>FROM config.AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.AlertConfiguration_View.AlertType<br>UNION ALL<br>SELECT 'Group', Group_Name, NULL, NULL, Group_AlertType, alert.Alert_Type.Name, Group_SubType, Group_Configuration, Group_Enabled, Group_AlertNotification, Group_EmailAddress, Group_Version, Group_WebhookEnabled<br>FROM config.Group_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Group_AlertConfiguration_View.Group_AlertType<br>UNION ALL<br>SELECT 'Cluster', Cluster_Name, NULL, NULL, Cluster_AlertType, alert.Alert_Type.Name, Cluster_SubType, Cluster_Configuration, Cluster_Enabled, Cluster_AlertNotification, Cluster_EmailAddress, Cluster_Version, Cluster_WebhookEnabled<br>FROM config.Cluster_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Cluster_AlertConfiguration_View.Cluster_AlertType<br>UNION ALL<br>SELECT 'Machine', Cluster_Name, Cluster_Machine_Name, NULL, Cluster_Machine_AlertType, alert.Alert_Type.Name, Cluster_Machine_SubType, Cluster_Machine_Configuration, Cluster_Machine_Enabled, Cluster_Machine_AlertNotification, Cluster_Machine_EmailAddress, Cluster_Machine_Version, Cluster_Machine_WebhookEnabled<br>FROM config.Cluster_Machine_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Cluster_Machine_AlertConfiguration_View.Cluster_Machine_AlertType<br>UNION ALL<br>SELECT 'SqlServer', Cluster_Name, Cluster_SqlServer_Name, NULL, Cluster_SqlServer_AlertType, alert.Alert_Type.Name, Cluster_SqlServer_SubType, Cluster_SqlServer_Configuration, Cluster_SqlServer_Enabled, Cluster_SqlServer_AlertNotification, Cluster_SqlServer_EmailAddress, Cluster_SqlServer_Version, Cluster_SqlServer_WebhookEnabled<br>FROM config.Cluster_SqlServer_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Cluster_SqlServer_AlertConfiguration_View.Cluster_SqlServer_AlertType<br>UNION ALL<br>SELECT 'Database', Cluster_Name, Cluster_SqlServer_Name, Cluster_SqlServer_Database_Name, Cluster_SqlServer_Database_AlertType, alert.Alert_Type.Name, Cluster_SqlServer_Database_SubType, Cluster_SqlServer_Database_Configuration, Cluster_SqlServer_Database_Enabled, Cluster_SqlServer_Database_AlertNotification, Cluster_SqlServer_Database_EmailAddress, Cluster_SqlServer_Database_Version, Cluster_SqlServer_Database_WebhookEnabled<br>FROM config.Cluster_SqlServer_Database_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Cluster_SqlServer_Database_AlertConfiguration_View.Cluster_SqlServer_Database_AlertType<br>UNION ALL<br>SELECT 'Job', Cluster_Name, Cluster_SqlServer_Name, Cluster_SqlServer_Agent_Job_Name, Cluster_SqlServer_Agent_Job_AlertType, alert.Alert_Type.Name, Cluster_SqlServer_Agent_Job_SubType, Cluster_SqlServer_Agent_Job_Configuration, Cluster_SqlServer_Agent_Job_Enabled, Cluster_SqlServer_Agent_Job_AlertNotification, Cluster_SqlServer_Agent_Job_EmailAddress, Cluster_SqlServer_Agent_Job_Version, Cluster_SqlServer_Agent_Job_WebhookEnabled<br>FROM config.Cluster_SqlServer_Agent_Job_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Cluster_SqlServer_Agent_Job_AlertConfiguration_View.Cluster_SqlServer_Agent_Job_AlertType<br>UNION ALL<br>SELECT 'Disk', Cluster_Name, Cluster_Machine_Name, Cluster_Machine_LogicalDisk_Name, Cluster_Machine_LogicalDisk_AlertType, alert.Alert_Type.Name, Cluster_Machine_LogicalDisk_SubType, Cluster_Machine_LogicalDisk_Configuration, Cluster_Machine_LogicalDisk_Enabled, Cluster_Machine_LogicalDisk_AlertNotification, Cluster_Machine_LogicalDisk_EmailAddress, Cluster_Machine_LogicalDisk_Version, Cluster_Machine_LogicalDisk_WebhookEnabled<br>FROM config.Cluster_Machine_LogicalDisk_AlertConfiguration_View<br>JOIN alert.Alert_Type ON alert.Alert_Type.AlertType = config.Cluster_Machine_LogicalDisk_AlertConfiguration_View.Cluster_Machine_LogicalDisk_AlertType  If the above script shows that webhook is enabled could you also run the script below to check if any webhook notifications are being sent? SELECT TOP 1000 [n].[AlertId]<br> ,[utils].[TicksToDateTime]([n].[SeverityDate]) AS SeverityDate<br> ,[utils].[TicksToDateTime]([n].[NotificationDate]) AS NotificationDate<br> ,CASE<br>WHEN [n].[NotificationType] = 0 THEN 'Email'<br>WHEN [n].[NotificationType] = 1 THEN 'Slack'<br>WHEN [n].[NotificationType] = 2 THEN 'SNMP'<br>WHEN [n].[NotificationType] = 3 THEN 'Webhook'<br>END AS NotificationType<br>FROM [alert].[Notifications] AS [n]<br>WHERE [n].[NotificationType] = 3<br>ORDER BY n.NotificationDate DESCBest,   Dustin  / comments
  1. Community
  2. Redgate Monitor
  3. SQLMonitor integration with ServiceNow
There are a few things we can do to check what is happening with the webhooks. Can you run the script below against the base monitor database to check if the webhook is enabled? SELECT 'Root' Leve...
0 votes
Hi Tanner,   Thank you for your inquiry into SQL Dependency Tracker. Unfortunately it looks like there are currently no plans to produce a 64 bit version of this offering.   A potential workaround is to use Large Address Aware utility which will enable Redgate.DependencyViewer.UI.exe Large Address Aware (allowing this process to use up to 4GB RAM within a 64bit system). The following link will provide further information and the utility to download - https://www.techpowerup.com/forums/threads/large-address-aware.112556/     Best,   Dustin  / comments
  1. Community
  2. SQL Dependency Tracker
  3. SQL Dependency Tracker Hangs On VERY large SQL databases - 64bit or command line execution options?
Hi Tanner, Thank you for your inquiry into SQL Dependency Tracker. Unfortunately it looks like there are currently no plans to produce a 64 bit version of this offering. A potential workaround is t...
0 votes
Hello, Thank you for your inquiry into SQL Prompt. Currently, the SQL servers that are supported outside of the standard SQL Server 2012 - 2022 are below. https://documentation.red-gate.com/sp/getting-started/requirements Azure SQL Database SQL Server on Azure VM Google Cloud SQL for SQL Server & Virtual Machines Amazon SQL Server RDS & Virtual Machines I will leave the SQL Prompt UserVoice forum here if you would like to suggest this addition to our dev team. https://redgate.uservoice.com/forums/94413-sql-prompt Best, Dustin  / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt is not showing all linked server contents
Hello,Thank you for your inquiry into SQL Prompt. Currently, the SQL servers that are supported outside of the standard SQL Server 2012 - 2022 are below.https://documentation.red-gate.com/sp/gettin...
0 votes
AWS Redshift is a different offering from Amazon SQL Server RDS, the method in which the way data is stored is different between the two platforms and is unfortunetly not currently supported by SQL Prompt. Best,  Dustin  / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt is not showing all linked server contents
AWS Redshift is a different offering from Amazon SQL Server RDS, the method in which the way data is stored is different between the two platforms and is unfortunetly not currently supported by SQL...
0 votes
Total activity
112
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
46