Activity overview
Latest activity by DLyes
Hello, I came across the need for this again this week, and posted it as an issue on the SQLCover github page. Eddie replied confirming that SQLCover already has the ability to take a filter to exclude specific objects ("sp_.*diagram" would work in this instance) but there is nothing in the SQLTest ui to allow you to specify anything that can be passed to SQLCover.
Is this something which could be added to SQLTest? Link to GitHub comment : https://github.com/GoEddie/SQLCover/issues/45#issuecomment-548136446
/ comments
Hello, I came across the need for this again this week, and posted it as an issue on the SQLCover github page.Eddie replied confirming that SQLCover already has the ability to take a filter to excl...
Thanks for confirming that @Alex B. / comments
Thanks for confirming that @Alex B.
Thanks for the reply Alex, sorry this reply took so long. What you've mentioned above sounds like it should exclude most of them, but it doesn't line up with what I can see. When I run my tests on a database which has the diagramming objects, these ones show up in the Code coverage section.
[dbo].[sp_upgraddiagrams]
7
0
0.00
[dbo].[sp_helpdiagrams]
5
0
0.00
[dbo].[sp_helpdiagramdefinition]
16
0
0.00
[dbo].[sp_creatediagram]
21
0
0.00
[dbo].[sp_renamediagram]
25
0
0.00
[dbo].[sp_alterdiagram]
24
0
0.00
[dbo].[sp_dropdiagram]
16
0
0.00
[dbo].[fn_diagramobjects]
19
0
0.00
I am using the latest available version - SQL Test Version 3.1.3.585 / comments
Thanks for the reply Alex, sorry this reply took so long.What you've mentioned above sounds like it should exclude most of them, but it doesn't line up with what I can see.When I run my tests on a ...
How can I exclude the system stored procedures for diagrams from Code coverage results?
I have recently noticed that the sp_%diagram procedures are now being listed in the Code coverage results, but they didn't use to.They all have an extended property of microsoft_database_tools_supp...
I'm not sure what the initial problem was, but I have had another go and have it working now.
The error log messages weren't being recorded, so must have been something with the DLM Automation side (or permissions) rather than the SQL Monitor side.
I updated the TFS plugins and DLM Automation 2 to the latest versions, and it is working nicely now :simple smile: / comments
I'm not sure what the initial problem was, but I have had another go and have it working now.
The error log messages weren't being recorded, so must have been something with the DLM Automation side...
I would also love this feature.
I don't suppose you have an update on this? / comments
I would also love this feature.
I don't suppose you have an update on this?
SQL Monitor integration
I created my first VSTS Release process and have used the "Deploy database changes from a database release" operation to deploy to a UAT server.
The release is working, with the schema updates depl...
I don't think so for us. Most of the time we sit on our primary node unless we were testing patches etc. So having the ability to stand-up clones on even one of the nodes would be helpful for us. It would be great if they failed-over onto the other node in the case of a fail-over, but our immediate desire would be just to have them available on the primary node. / comments
I don't think so for us. Most of the time we sit on our primary node unless we were testing patches etc. So having the ability to stand-up clones on even one of the nodes would be helpful for us. I...
Hi Mark R,
I sent an email this morning with some thoughts.
I tried the workaround today and it partially works.
It does take the clone off the dashboard, allowing an image to be deleted.
But sometimes the vhd file is locked by the agent, which means the image deletion sometimes doesn't work, and the other times the image does disappear from the dashboard but the vhd file still exists.
The local system administrator can manually remove the lock and then we can clean this up, but this doesn't seem like something we can easily automate.
Now that I know about the locks, I don't know if my suggestions in my email will actually be feasible, but I'm more than happy to discuss it further. / comments
Hi Mark R,
I sent an email this morning with some thoughts.
I tried the workaround today and it partially works.
It does take the clone off the dashboard, allowing an image to be deleted.
But somet...
Deleting clones on disconnected agents
Hello,
What should we do if we want to delete an image but a clone exists on an location whose agent is disconnected?
E.g. if a coworker is out of the office, or their laptop has died; how can we d...