Activity overview
Latest activity by David_D
Hi @davehahn, Database strings are supported. I'm glad you figured it out. Please don't hesitate to reach out if you have any other questions. Kind regards, David Dang | Product Support Engineer / comments
Hi @davehahn,Database strings are supported.I'm glad you figured it out. Please don't hesitate to reach out if you have any other questions.Kind regards,David Dang | Product Support Engineer
Hello @BlueBSH, Thanks for reaching out and sharing the details. By using <IgnoreTfsPolicies>True</IgnoreTfsPolicies>, you will be essentially ignoring all TFS policies. As for <TeamFoundationServerDllOverride>TfsExtendedClient</TeamFoundationServerDllOverride>, that will connect without using Team Explorer. That error you are receiving is related to a policy set up by your team's server administrator to make sure commits meet requirements they specify. Commits that don't meet the policy requirements are rejected by the server. Hence, why you are receiving "This commit doesn't meet the server's policy requirements, or the policy isn't configured on your machine." There can be multiple causes of this error, please refer to this page to try each of the options. I would recommend reaching out to your team's server admin to confirm what policies are set. https://documentation.red-gate.com/soc/troubleshooting/error-messages/this-commit-doesn-t-meet-the-server-s-policy-requirements-or-the-policy-isn-t-configured-on-your-machine Kind regards, David Dang Product Support Engineer / comments
Hello @BlueBSH,Thanks for reaching out and sharing the details.By using <IgnoreTfsPolicies>True</IgnoreTfsPolicies>, you will be essentially ignoring all TFS policies. As for <TeamFoundationServerD...
Hello @MGibson, Thanks for reaching out! I have not personally encountered this issue but it does seem related to SSMS (which you may be able to raise a bug with Microsoft). Another user that had the same error along with the forceseek query hint: https://dba.stackexchange.com/questions/222640/query-processor-could-not-produce-a-query-plan-because-of-the-hints-defined-in-t In my case I got the same error with my query where somebody used with forceseek hint. Finally I figured out that table was a HEAP and the creation of a Clustered Index solved the problem. I hope this helps you out. Kind regards, David / comments
Hello @MGibson,Thanks for reaching out!I have not personally encountered this issue but it does seem related to SSMS (which you may be able to raise a bug with Microsoft). Another user that had the...
Hello @NBMon, Thanks for your post. It seems that error code is related to Git and your SSL certificate. The easier workaround for this would be to disable Git SSL verification in the server. git config --global http.sslVerify falsePlease be advised disabling SSL verification globally might be considered a security risk and should be implemented only temporary. You can find more details about this error at this stack overflow post: https://stackoverflow.com/questions/11621768/how-can-i-make-git-accept-a-self-signed-certificate Kind regards, David Dang Product Support Engineer / comments
Hello @NBMon,Thanks for your post.It seems that error code is related to Git and your SSL certificate. The easier workaround for this would be to disable Git SSL verification in the server.git conf...
Hi @Derrick, Thanks for reaching back out, and I'm hoping you are having a Happy Holiday! What version of SQL Monitor are you using? Our documentation will change as the information changes or new information are being added, hence older links may be outdated or dead. I suspect that you are using an older version of SQL Monitor that is directing to an older link. Regarding AD Authentication, please do keep me updated on your results and don't hesitate to reach back out if you have any questions. Kind regards, David Dang Product Support Engineer / comments
Hi @Derrick,Thanks for reaching back out, and I'm hoping you are having a Happy Holiday! What version of SQL Monitor are you using? Our documentation will change as the information changes or new i...
Hello @crimdon, We once tried (2016) integrating Power BI, however, instead created the Reports tab instead. So, unfortunately, connecting SQL Monitor to Power BI is not a feature. Thank you, David Dang Product Support Engineer / comments
Hello @crimdon,We once tried (2016) integrating Power BI, however, instead created the Reports tab instead. So, unfortunately, connecting SQL Monitor to Power BI is not a feature. Thank you,David D...
Hello @Derrick, Thanks for reaching out. Can you provide more details with what you mean by enabling PKI with the integrated authentication? Are you referring to TLS/SSL or self-signed certificates? Regarding integrated authentication on IIS, please see below for information with enabling Basic Authentication in IIS. A default domain and realm can be specified. Access rights are given to users who have access rights to SQL Monitor’s web folder:
Official instructions: https://technet.microsoft.com/en-us/library/cc772009(WS.10).aspx
Personally, I find this set of instructions more helpful than the official one: http://manual.aspdotnetstorefront.com/p-1614-enabling-windows-authentication-in-iis7.aspx
It’s very important to configure the site to use SSL. (See second link above)
I hope this answer helps you out. Kind regards, David Dang Product Support Engineer / comments
Hello @Derrick,Thanks for reaching out. Can you provide more details with what you mean by enabling PKI with the integrated authentication? Are you referring to TLS/SSL or self-signed certificates?...
Hi @hroberts, Thanks for sharing the logs. I do notice a difference in time at the point where SQL Prompt seems to be taking longer to decrypt objects. Do you have encrypted objects in your databases? Based on our SQL Prompt release notes, I don't see any changes that would affect this issues moving from 10.4.6 to 10.4.7. Although, as a workaround if you were to ever encounter this issue again, would be to uncheck the option to "Decrypt encrypted objects" in SQL Prompt > Options > Suggestions > Behavior > Encrypted Objects. I hope this was helpful! Don't hesitate to reach back out if you have any other questions. Kind regards, David Dang Product Support Engineer / comments
Hi @hroberts,Thanks for sharing the logs. I do notice a difference in time at the point where SQL Prompt seems to be taking longer to decrypt objects. Do you have encrypted objects in your database...
Hi @hroberts, Thanks for the follow up! I'm glad that reverting to a previous version of SQL Prompt helped for you. I am not entirely sure why SQL Prompt may take longer in your environment as I was not able to replicate the issue in my environment. As environmental factors can affect performance of SQL Prompt, it may be difficult to pinpoint what were the exact causes of the issue. With that said, if you don't mind sharing the log files, I would be interested in seeing if the logs may contain any useful information. https://documentation.red-gate.com/sp/troubleshooting/finding-the-sql-prompt-log-files Kind regards, David Dang / comments
Hi @hroberts,Thanks for the follow up! I'm glad that reverting to a previous version of SQL Prompt helped for you. I am not entirely sure why SQL Prompt may take longer in your environment as I was...
Hello @hroberts, I unfortunately haven't been able to reproduce (there does seem to be a short delay for me though only for a few seconds). Can you please check the following below to see if it helps: - Does it make any difference if you disable suggestions and code analysis (from the SQL Prompt menu) and also disable tab history (SQL Prompt>Options>Tab History) before opening the query? - What SQL Server version are you connected to? - To confirm, if you revert to the previous SQL Prompt release, does the issue go away for you? https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.4.6.16406.exe Kind regards, David Dang Product Support Engineer / comments
Hello @hroberts,I unfortunately haven't been able to reproduce (there does seem to be a short delay for me though only for a few seconds).Can you please check the following below to see if it helps...