You've got some fun R&D lined up.

This won't be a password thing. Instead you'll be using OAUTH2 to gain access and messing about with ClientIds, ClientSecrets and Access Tokens, I...

loaded question but i'll try.  for starters we plumb more than just pbi to cubes.  for example excel pivots.   i understand there is an extension to excel called power...

Hi

I am New To Azure Sql.  Can some one please share

•  If we can migrate sql 2017 db with symmetric key and certificate in it on Prem to Azure...

As the term 'perfect' is poorly defined in the context of software, one person's 'perfect' is another person's 'not bad'.

I don't remember ever using software that I didn't think could...

It is, indeed, a tricky one. Surrogate keys + date logic looks like the way forward.

It's not an elegant star schema model.

I hope that others respond with their ideas.

I notice that there's no mention of product sales … hence your reference to 'factless', I assume.

Are you therefore simply building a 'Product cube'?

What sort of reporting/analysis are you intending...

This article is a bit terse.

... it seems that this functionality was broken starting with v18 - see https://blog.sqlauthority.com/2020/04/23/ssms-bug-execution-time-out/%5B/quote%5D

Tested and still broken on V20.1

The best type of solution 🙂

Have you tried putting the script task outside of the sequence container?

Interestingly, the desired output is however considered valid JSON, at least according to https://jsonlint.com/

I've just been trying a few things and couldn't make it work.

It seems that the T-SQL JSON functions deem any string containing a single / character as invalid and escape...

I tried to follow your logic for the row where ID = 5.

- IN --->> 2024-12-16
- (4 AMOUNT * 85 PRICE)+(5 BALANCEO * 85 )/ (BALANCE  9) ...

It would be interesting to understand what this data represents.

As all of the rows have Code 0001, do they all refer to the same object? And yet the price changes...

Try surrounding the server name with double quotes