Comments
Sort by recent activity
Yay!
Spotlight hides it's own activities from the monitoring results. It's kind of odd. I've never seen a monitoring tool do that before. / comments
Yay!
Spotlight hides it's own activities from the monitoring results. It's kind of odd. I've never seen a monitoring tool do that before.
We show it in near real time. It's only delayed by a few seconds, but, it radically reduces what happens on your server. People can absolutely disagree on whether it's the right approach.
I'd be VERY cautious of Spotlight. Of all the other vendor products out there, it's the single one I've had the most issues with. Do you know that it masks it's own calls to the server? If you really want to evaluate us against another software, pursue another vendor. I think we're better (I do have a prejudice), but the others are much safer than Spotlight. / comments
We show it in near real time. It's only delayed by a few seconds, but, it radically reduces what happens on your server. People can absolutely disagree on whether it's the right approach.
I'd be VE...
So the top 10 is always just a snapshot. We don't continually poll the server in such a way that you can see queries scrolling by on your screen. You can update the snapshot just by clicking the button up on the timeline that will move everything to the latest data. / comments
So the top 10 is always just a snapshot. We don't continually poll the server in such a way that you can see queries scrolling by on your screen. You can update the snapshot just by clicking the bu...
Yeah, that's a very good idea. I'm always hesitant to suggest people to rewrite their code, but this is the way to get it done. / comments
Yeah, that's a very good idea. I'm always hesitant to suggest people to rewrite their code, but this is the way to get it done.
Absolute agreement. It's the right way to get things done. / comments
Absolute agreement. It's the right way to get things done.
To avoid a syntax error you'll probably need to dummy out the linked server. Just give it the same name as the one in production (or wherever) but you can point it to whatever you need to in order for it to work. It doesn't have to be the same server. It just has to have the same name locally. / comments
To avoid a syntax error you'll probably need to dummy out the linked server. Just give it the same name as the one in production (or wherever) but you can point it to whatever you need to in order ...
I used "Align subsequent items with first item", "Align items across clauses" and "Align items to tab stops". It seemed to be what you were looking for based on the initial post. / comments
I used "Align subsequent items with first item", "Align items across clauses" and "Align items to tab stops". It seemed to be what you were looking for based on the initial post.
There were changes to the formatting, especially the defaults. However, you should have control over those alignments, way more than before. Click on the SQLPrompt menu and then "Edit Formatting Styles..." to get started. / comments
There were changes to the formatting, especially the defaults. However, you should have control over those alignments, way more than before. Click on the SQLPrompt menu and then "Edit Formatting St...
OK, there's a lot to this. Best recommendation, check out the documentation located here. What you're looking for is Build. That's the one that's going to let you do the comparison and generate scripts and output. Sync will actually do the move after you've completed the Build. Come back here after you check that out if you have more questions.
As to C#, I don't know. I've only done this work using PowerShell and the examples will show that. I'll see if I can get someone to show that for you.
You can pass in a filter to the Build process.
You can distribute the artifacts you generate, but if you need to do a compare to each of the clients to generate that artifact, that's tougher. We'd need to drill down on what you're doing, why and how. / comments
OK, there's a lot to this. Best recommendation, check out the documentation located here. What you're looking for is Build. That's the one that's going to let you do the comparison and generate scr...
To validate this works, I just connected an Azure SQL Database to my Team Foundation Services source control. Everything ought to work.
Make sure you have the latest version. I think some of the older versions had a problem with Azure. / comments
To validate this works, I just connected an Azure SQL Database to my Team Foundation Services source control. Everything ought to work.
Make sure you have the latest version. I think some of the ol...