Changes to server configuration option remote access are not supported in SQL Database Managed Instances

Having just set up our new SQL Server Managed Instance, restored a sample database for testing, and run Azure’s vulnerability assessment, it produces this high risk finding:

VA2120 – Features that may affect security should be disabled

The more SQL Server features and services you enable, the larger its surface attack area becomes, making your system more vulnerable to potential attacks. These fetures should be disabled unless it is absolutely needed in this environment.

Remediation Script:

EXECUTE sp_configure 'show advanced options', 1; RECONFIGURE WITH OVERRIDE; EXECUTE sp_configure 'remote access', 0; RECONFIGURE; EXECUTE sp_configure 'show advanced options', 0; RECONFIGURE; 

Turning to Google before doing anything, I found this Microsoft Docs article stating that (emphasis mine):

This topic is about the "Remote Access" feature. This configuration option is an obscure SQL Server to SQL Server communication feature that is deprecated, and you probably shouldn’t be using it.

Can anyone therefore please provide some clarity on the following?

  1. Why is it enabled given Microsoft’s description?
  2. Does it need to be enabled in Azure SQLMI? Because…
  3. When I run the remediation script I get this error:

Changes to server configuration option remote access are not supported in SQL Database Managed Instances.

How do I find out whenever a value changes in a certain column?

Need help if anyone can offer!

I currently have my select statement returning the TOP 1000 * results from a table. They are CC numbers that are currently active. I’d like to see how I can go about writing a query that could show me what has CC numbers have changed.

If something has changed, it will send a report to the listed people. If nothing, then it does nothing. It only actions once something has happened. We have an inhouse system that will do the automated part… I just need a select statement that will return what has changed. If I can get some help on this, it would be amazing!

Thank you!

Repairing buggy query server-side – without changes in the app

More external apps are accessing our ERP SW database. As we were adding some columns into our structure, some queries from the external app become buggy because they are not specifying the targeted table in the query and errors out with Ambiguous column name… message.

The app vendor is inaccesible. We cannot repair the query from the app point nor change our structure (it’s for more customers).

Can we do something at the database server level?

Changes When Using Solve with Plot3D and Evaluate

I’m solving the following equation, which should be straightforward:

func1[A1_, A2_] := -((    4 I + 4 I A2^2 - 12 I A1 (1 + A2 ((2 - I) + A2 - 2 I eig)) +      A2 ((1 + 2 I) + 2 eig) ((5 + 4 I) + 4 eig ((1 + 2 I) + eig)))/(    8 A2)); sol1[A1_, A2_] := Solve[func1[A1, A2] == 0, eig]; 

I want to extract the analytic solution to this, but I’m not sure that what Mathematica is producing is correct. Here are the plots to explain what I mean:

Smooth plot using the unpacked solution

This is a smooth plot and something that I expect. I’m plotting this with the line:

Plot3D[Re[eig /. sol1[A1, A2][[1]]], {A1, 0, 1}, {A2, 0, 1}] 

Now if I try to get the analytic expression for this solution and I plot it, I get something different. I can demonstrate this just by changing my Plot3D command:

Plot3D[Evaluate[Re[eig /. sol1[A1, A2][[1]]]], {A1, 0, 1}, {A2, 0, 1}] 

produces:

enter image description here

As you can see, the plot is different; it’s jagged with a discontinuity. With this, I can’t be sure that the analytic solution I extract from Mathematica is right. I’d like to either replicate the first plot with an explicit expression that I can acquire somehow or find out what function exactly Mathematica is plotting in the first instance. Am I missing something in regard to rule solutions here?

Thanks

What happens to Ability Score changes when shapeshifted?

A low strength druid has been hit twice by a Shadow’s Strength Drain ability, reducing their strength score from 9 to 3. Fearing potential instant death, the Druid uses Wild Shape to turn into a Brown Bear, changing there physical ability scores to match that of the Brown Bear, which would normally mean their strength is now 19. What happens to the reduction to strength score? The only official information on this matter comes from Sage Advise:

Can a creature under the effects of polymorph have other spell effects on them, or are those game statistics also replaced by the those of the beast form? Polymorph replaces only the target’s character sheet or stat block with the stat block of the chosen form. Other effects, such as other spells, still exist.

However this only covers what could happen if a creature already polymorphed has an effect placed on them. In this instance, would the Druid in Brown Bear form have 19, 13, 3, or something else as its strength score? Would the result be the same for Polymorph, or other shape changing abilities that take the new forms statistics?

Would these changes to the Arcane Archer be imbalanced?

The Arcane Archer seems to be pretty underwhelming, mostly because of its limited uses of the Arcane Shot feature. Would it be imbalanced to increase its number of uses per rest to match the number of Arcane Shot options known? The feature would read something like this:

Arcane Shot
At 3rd level, you learn to unleash special magical effects with some of your shots. When you gain this feature, you learn two Arcane Shot options of your choice (see "Arcane Shot Options" below).
Once per turn when you fire an arrow from a shortbow or longbow as part of the Attack action, you can apply one of your Arcane Shot options to that arrow. You decide to use the option when the arrow hits a creature, unless the option doesn’t involve an attack roll. You have two uses of this ability, and you regain all expended uses of it when you finish a short or long rest.
You gain an additional Arcane Shot option of your choice, as well as an addition use of the feature, when you reach certain levels in this class: 7th, 10th, 15th, and 18th level. Each option also improves when you become an 18th-level fighter.

Compared to other "pick X of Y" subclasses for the Fighter, Arcane Archer is the most limiting:

  • Battle Master gets 3 uses per rest, and has (after Tasha’s) 23 options, as compared to the Archer’s 2 uses per rest, and 8 options; The Battle Master can also further increase the uses by taking the Superior Technique Fighting Style or
  • Rune Knight starts with 2 uses per rest, and has only 6 options to choose from, but that number increases to 5 runes to use, which sets a precedent for an increasing number of uses as the class grows in strength.
  • Eldritch Knight starts with 3 spells known (of 14 1st level spells in the Abjuration and Evocation schools), and 2 uses, but the number of spells known and spell slots grows frequently, nearly every second level.

I think increasing the number of uses of Arcane Shot would at least bring the Arcane Archer closer to some of the more powerful Fighter subclasses, without overpowering this subclass.

The 7th level feature seems balanced, if not strong, and I don’t think needs any changing.

The 10th level feature is weak compared to other fighter 10th level abilities, so I propose adding the Close Quarters Shooting feature, from the UA Sharpshooter subclass:

Close Quarter’s Shooting
At 10th level, you learn to handle yourself in close combat. Making a ranged attack roll while within 5 feet of an enemy doesn’t impose disadvantage on your roll.
In addition, if you hit a creature within 5 feet of you with a ranged attack on your turn, that creature can’t take reactions until the end of this turn.

This feature is relatively situational, and adds a bit of defense to the repertoire of the arcane archer without forcing them to pick one shot over another. Because of the situational nature of this feature I don’t believe it would increase the strength of the class too much, but would still improve things.

The increase to number of uses of Arcane Shot does make the Ever-Ready Shot feature rather underwhelming, So is should be replaced with another feature from the UA Sharpshooter, Rapid Shot:

Rapid Shot
Starting at 15th level, you learn to trade accuracy for swift strikes. If you have advantage on a weapon attack against a target on your turn, you can forgo that advantage to immediately make an additional weapon attack against the same target as a bonus action. You may not use an Arcane Shot on this additional attack.

This matches the Samurai 15th level feature, and I don’t think adding that feature to this subclass is unfair. As it uses a bonus action, it limits the feature to once per turn, and only on the characters turn. Not allowing an Arcane Shot mostly clarifies that if you split advantage on a use of Arcane Shot, it does not make both attacks have the Arcane Shot.

The 18th level feature I don’t think needs changing, as the increased uses of the Arcane Shot improves the value of the 1d6 or 2d6 extra damage.

What are your thoughts? Is there any change that stacks aggressively in some way I’m missing? Would this be balanced with one feature out?

What weapons are subject to ancestries’ weapon familiarity proficiency changes?

Consider Dwarven Weapon Familiarity.

A dwarf that takes it becomes trained in the battleaxe, pick and warhammer. Also from this feat:

You also gain access to all uncommon dwarf weapons. For the purpose of determining your proficiency, martial dwarf weapons are simple weapons and advanced dwarf weapons are martial weapons.

Does this part include the weapons that don’t have the Dwarf trait, but are mentioned above? Or does it only apply to the clan dagger and Dwarven war axe?

If it only applies to weapons with the respective ancestry’s trait, then it seems like certain ancestries have been stiffed by this. The hobgoblin equivalent of this feat, for example, mentions martial hobgoblin weapons being treated as simple, etc. But there aren’t any weapons with the hobgoblin trait, meaning the feat is currently useless (aside from giving the appropriate training in the listed weapons).

tl;dr are the weapons that don’t have an ancestry trait included in the weapons whose proficiency is treated as lower (advanced -> martial, martial -> simple) for a character with the feat?

Is it worth buying the “Super Powers Companion 2nd Edition” if I have 1st Ed. and the free changes supplements?

I own the original SW: Super Powers pdf that came out some years ago, however my group and I have been playing with the PDF that Pinnacle released with the rules for power creation.

I’d like to know if the changes in the second edition are significant enough to consider buying it, since I haven’t been able to find a list of the chapters of the book to know if there’s anything special beyond the rules changes on powers, such campaign creation advice, how to make heroic NPCs and villains, etc.