Makes sense, thanks for clarifying.

I don't see that. If I run the following, it executes just fine.

DECLARE @Language NVARCHAR(10) = N'en';

DROP TABLE IF EXISTS #Temp;

CREATE TABLE #Temp
(
    TestName...

I shall address the...

Looking on the bright side, maybe the Dark theme would have been officially implemented in that...

SSMS keyboard shortcuts (built-in and custom) are working as usual for me in 20.1.

What do you mean by the following, exactly?

It seems to always wait for the second character in...

Not exactly by hand. Intellisense identifies them.

June 12, 2024 at 2:46 pm

#4428030

didnt know.  so answer #2,  kind of piling on answer #1 is that the users who pivot would need minimally a pbi pro license.   i dont think we want...

There is no column ZZZZ in table a. The only column in table a is a

create table a (a int) would need to change to create table a (ZZZZ...

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.