thx phil, yes we already use an azure vm machine 2022 as a dev box.   And have exercised everything but ssas on that box to this point.

a few words of caution to the community...

1. use this link as a guide, it has info you wont figure out yourself https://www.sqlshack.com/how-to-create-and-configure-a-linked-server-to-connect-to-mysql-in-sql-server-management-studio/ .  I think that nested...

thx phil, thats what i thought.   without data factory which i saw last time can "call" ssis, its not happening.   we dont pay for data factory.

i did once before on this very subject but its been a while.   and sometimes things change.   and sometimes the ms documentation is so geared to selling and filled with...

• This reply was modified 1 week, 2 days ago by  stan.

no we believe saas is simply the service (eg sql server) without the maintenance (eg throwing additional resources like space etc at it when necessary).

• This reply was modified 1 week, 2 days ago by  stan.

this seems to answer the question if that provider mentioned previously is the/a right path...  https://stackoverflow.com/questions/66213672/import-active-directory-to-sql-server   .

• This reply was modified 3 weeks, 3 days ago by  stan.
• This reply was modified 3 weeks, 3 days ago by  stan.

i see an approach here that leverages the script task but not being that good at .net dont see how it can be limited to a specific domain controller

i see an odbc driver at this site but still wonder if our existing sql drivers cant establish this kind of communication?  this looks like an open source product.

this article describes the crazy workaround where you attach a guid to each record on the 2nd thru nth params to make  them refresh.  https://bpmsbi.wordpress.com/2011/04/23/ssrs-cascading-parameters-refresh-solved/    .

as for...

• This reply was modified 1 month ago by  stan.

i'd rather have it for each statistical population.   I see you are saying stdev isnt like sum where "group by" limits what you see.  I think i understand.  since i...

that is the question.   what are you suggesting?  how is what you are suggesting done?  are you suggesting 6 selects?  the number of statistical populations varies based on the filter...

• This reply was modified 1 month ago by  stan.
• This reply was modified 1 month ago by  stan.

thx jeff.   eventually i did do the divide and conquer thing.  it took the query down from 6 minutes to 19 seconds.   i turned it over in that state to...

thx adi, didnt find the word trivial in the xml version of the plan.

thx frederico.   i never take those suggestions seriously until i should.

i profiled the volumes on each table and view next looking for a silver bullet.

i went to the plan next...

• This reply was modified 1 month, 1 week ago by  stan.

thx scott that approach gives the same results (ie no suggestion) i got clicking the "display estimated execution plan" icon upper left in ssms.