Simone Bizzotto
Simone Bizzotto
BTW, just for fun, did you try $server.ConnectionContext.ExecuteNonQuery() ?
I remember that SMO supported GOs . can you by any chance paste the script you're trying to execute ?
are you missing a declare for some reason ? even in SSMS, this doesn't work.  that being fixed, I don't remember if "gotos" are fine for SMO (such as...
let's put it this way. If it doesn't work in SSMS or invoke-sqlcmd, it won't work in dbatools (which, just exposes what SMO has). Once you get to have it...
are you sure there's only one process open each time and "the older one" isn't there, lurking around with a DAC connection opened ?
hi @maxim-vde, great analysis! Isn't this a problem on sql2022's side rather than dbatools ? Did you try on a SQL2022 which isn't RTM, i.e. maybe a CU fixed the...
lol, @maxim-vde , thanks a lot nonetheless, it was a reaaaally good description of the issue. Glad that a CU fixed it, thanks to Microsoft in this case
point is, IMHO, it's still a performance problem on SQL's side that dbatools can do nothing about ?!
uhm, not convinced by this, 'cause 2016 (and every other except 2022) is "speedy". So either they fix the issue at the root (i.e. the DMV, even if deprecated, is...
yep, it tracks. Point is, those "initializations" on Connect-DbaInstance are what makes dbatools usable. Also, we can't "remove a property": databases in dbatools expose the same properties SMO exposes. But,...