Activity overview
Latest activity by krshort
I'm curious which wait types are included in the metric 'Avg Lock Wait Time'.
This has proven to be a good 'canary in the coal mine' indicator on an old legacy system we have, and we would like to customize this for more specific purposes. Is this canned metric available f...
It would appear that I'm not alone in trying to get SQL Prompt installed on SSMS 18. Is there a 'graceful' way to do this? I've gone so far as to uninstall SSMS 17, reboot, reinstall SQL Prompt. It still does not show up in SSMS 18. Any suggestions appreciated. UPDATE: I was able to finally get SQL Prompt installed in SSMS 18 by following the instructions at the bottom of this link, then re-installing SQL Prompt using the latest download of Toolbelt. https://productsupport.red-gate.com/hc/en-us/articles/360003503274-SQL-Prompt-SQL-Search-SQL-Source-Control-or-SQL-Test-doesn-t-appear-in-SSMS?flash_digest=df9a29904a11c6a13cb146d9c4703cd829151326 / comments
It would appear that I'm not alone in trying to get SQL Prompt installed on SSMS 18. Is there a 'graceful' way to do this? I've gone so far as to uninstall SSMS 17, reboot, reinstall SQL Prompt...
Minimum permissions needed for SQL Compare?
I'm sure this has been asked (and answered) before, but I can't find anything in the forums. What is the minimum security/role needed to run SQL Compare against a prod DB? Surely there must be ...
Unfortunately we have not migrated to GIT yet, it is a project slated for 2018 Q1. Let me review the doc you referenced and see if I can figure out how to get my folders in sync. Thanks again. / comments
Unfortunately we have not migrated to GIT yet, it is a project slated for 2018 Q1. Let me review the doc you referenced and see if I can figure out how to get my folders in sync. Thanks again.
No. When I select 'commit changes', the objects in question do not show up on the list. / comments
No. When I select 'commit changes', the objects in question do not show up on the list.
Thanks for your quick response. I am on TFS. The relink re-created my working and transient folders, but my new objects do not show as belonging to me. They exist on the shared model DB, of course, but I can't check them in to source control from the new laptop. / comments
Thanks for your quick response. I am on TFS. The relink re-created my working and transient folders, but my new objects do not show as belonging to me. They exist on the shared model DB, of c...
How to sync local source control folders on new laptop?
I recently had a drive crash on my laptop. I'm using a different machine for now, but discovered that after I re-linked to my dev DB (shared model), the objects I created are not correctly display...
Thanks, Harry, for the response. As I stated earlier, we are attempting to implement DLM Automation, and this partitioning issue (among other things) has prevented us from becoming fully automated. However, your workaround suggestion did give me another idea. Syncing the boundaries in source control with current prod just prior to build/deploy just might do it. I'll give it some thought. I would welcome any other suggestions from Red Gate users. I have to believe that someone out there has come up with the 'brilliantly elegant' solution!! / comments
Thanks, Harry, for the response. As I stated earlier, we are attempting to implement DLM Automation, and this partitioning issue (among other things) has prevented us from becoming fully automat...
Avoid deploying partition boundary definitions?
I've inherited the responsibility of DB deployment for several legacy databases. I see that partitioned tables, along with their schemes and functions are checked in to source control. When I tr...
I'm having the same difficulties, and I believe my problem may be related to the default behavior of the command line. How do I Exclude Dependencies using command line?
Regards,
Kevin / comments
I'm having the same difficulties, and I believe my problem may be related to the default behavior of the command line. How do I Exclude Dependencies using command line?
Regards,
Kevin