Comments
Sort by recent activity
Thanks, @Alex B. Just to make sure I'm clear. The "dark blue" that you are referring to is the darker blue graph area labeled "SQL Server"? And that is for "queries executing" as opposed to other sqlservr.exe processes? Hmmm. Why would it be labeled "Machine"? That makes me believe that it is something more like a non-SQL process like IIS or SSIS or somebody playing solitaire. [image] / comments
Thanks, @Alex B. Just to make sure I'm clear. The "dark blue" that you are referring to is the darker blue graph area labeled "SQL Server"? And that is for "queries executing" as opposed to othe...
Excellent. Thanks, @Alex B. That's helpful. And yes, it would be nice if these concepts were clearer in the UI. / comments
Excellent. Thanks, @Alex B. That's helpful. And yes, it would be nice if these concepts were clearer in the UI.
Thanks, @Alex B. I like how you added handling for named instances. I did go ahead and add the metric as-is. Turns out it's one of those perf counters that is mis-named - seems that it is a cumulative count and just increases over time. It's not actually an average #/sec over a sampling time. I've actually been working more with the "forward_fetch_count" from sys.dm_db_index_operational_stats to find which heaps are getting scanned and accessing the forwarding pointers. Not sure how I would implement a way to track this metric, though, as it would be a metric capture at a table level. Hmmm.... / comments
Thanks, @Alex B. I like how you added handling for named instances. I did go ahead and add the metric as-is. Turns out it's one of those perf counters that is mis-named - seems that it is a cumu...
Thanks for the update, @Ivo_Miller. Much appreciated. I know this is a large undertaking. I also imagine that actually getting the SCA tooling to fully port to linux and mac is an even larger project. Glad to hear you are making some headway in this direction. / comments
Thanks for the update, @Ivo_Miller. Much appreciated. I know this is a large undertaking. I also imagine that actually getting the SCA tooling to fully port to linux and mac is an even larger pr...
I discovered this as well. @Ivo_Miller - Docs at https://documentation.red-gate.com/sca/getting-started/system-requirements/powershell-component-requirements still just say: Supported PowerShell versions PowerShell 3 or above Would be helpful to get the docs updated with a disclaimer re: pwsh 7. / comments
I discovered this as well. @Ivo_Miller - Docs at https://documentation.red-gate.com/sca/getting-started/system-requirements/powershell-component-requirementsstill just say:Supported PowerShell ver...
Any updates on this? I'd love to not switch back and forth between powershell 5.x and 7.x. / comments
Any updates on this? I'd love to not switch back and forth between powershell 5.x and 7.x.
Quick follow up to this thread. I did work with James and the team to go through this new capability 9using clones for shadow and build DBs. It is still being refined, but the essence of it is there and works. This is a fabulous way to avoid dealing with cross DB references in DBs. Nice work, RG posse! / comments
Quick follow up to this thread. I did work with James and the team to go through this new capability 9using clones for shadow and build DBs. It is still being refined, but the essence of it is th...
Excellent. Would it rely on RG clones specifically? Or, might we get an option to work with other, more budget conscious cloning technologies like psdatabaseclone? Don't get me wrong, I understand the benefits of RG SQL Clone/Provision - just wish there were a few more tiers in the pricing model. / comments
Excellent. Would it rely on RG clones specifically? Or, might we get an option to work with other, more budget conscious cloning technologies like psdatabaseclone? Don't get me wrong, I understa...
Thanks, Steve @way0utwest . Filters and project file hacks have provided enough relief to get it to verfiy & build. However, I have been unable so far to come up with simple logic (regexp/filter) to say that "these objects we want" and "these we don't". Unfortunately, "our" objects are intermingled with the vendors within the dbo schema. Don't ask. Question, though - if I do find a way to filter off the vendor objects, won't we run into issues during build if our views refer to the vendor object? I'll try a POC... Also, I've read some of those xdb articles. They are awesome. Not sure if it's laziness or being overwhelmed that keeps me from fully embracing and implementing. Cheers, -Peter / comments
Thanks, Steve @way0utwest . Filters and project file hacks have provided enough relief to get it to verfiy & build. However, I have been unable so far to come up with simple logic (regexp/filter) ...
I'd also like to see a verify/build validation process that allows us to take a "blessed" snapshot of the DB or existing target as the "starting place", so we don't have to actually build the full DB each time we execute one of these processes. Something like SQL Clone could participate in this design. My container skills are weaksauce, but I've wondered if they might apply in some way here, too. Keep some images of baselined environments (perhaps multiple DBs) that can "seed" a build w/o having to build from src. / comments
I'd also like to see a verify/build validation process that allows us to take a "blessed" snapshot of the DB or existing target as the "starting place", so we don't have to actually build the full ...