You can download any of the MSFT databases (AdventureWorks etc) from Github.

See this article: https://learn.microsoft.com/en-us/sql/samples/sql-samples-where-are?view=sql-server-ver16

I'd go the backup file (.bak) route. Super easy.

A thousand years ago, I tried doing this in SSIS, but the PowerQuery source works like... well, not at all. =(

Here's the beginning of the conversation: SSIS task that...

• This reply was modified 9 hours, 23 minutes ago by  pietlinden.

I was basically just playing with DAX Studio when I discovered it could export the result of my PowerQuery.

I suppose I could just copy and paste my PowerQuery into Excel...

Okay, just a quick update... I got the PowerQuery working (Text.Combine in PowerQuery is my new best friend!!!) Here's the PowerQuery:

let
    Source = Folder.Files("C:\Users\User\OneDrive\Documents"),
...

Sounds like a hideous design.

Why not just put all the data in the same database with a foreign key column to the server name? Then you don't need any dynamic...

Okay. The other way I was thinking of doing it was to write a query to find changed prices each week (since he only sells cnce a week) and then...

To quote Gene Wilder in "Charlie and the Chocolate Factory", "Wait a minute, Strike that! Reverse it! Thank you."

The trick is to avoid SSIS altogether. If you have DAX Studio...

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

Martin,

I'm trying to work out options. Would you use something like a system-versioned table to handle the ingredient slowly changing dimension? Or can I just use a few fairly simple...

Sounds like you're missing the other table, Student.

Student(StudentID (PK),...)

StudentTest(StudentID (PK1), TestID (PK2), TestScore)

Test(TestID (PK), TestDate...)

if you allow nulls in StudentTest(Score), then you can just cross join a filtered view of...

I'm trying to simulate price changes of some of my ingredients over time. (Not really necessary to change the prices of more than just some of the most commonly used...

Thanks Steve! Like I said, I felt like I was missing something that should have been blatantly obvious! Thanks for clarifying!

So this is my plan (after staring at this for...

Why not just script out all the objects and then run all that in a separate database?

Otherwise, you could make a copy of your database and then use dynamic SQL...

Apparently Imke Feldmann wrote some code that does it... but by the looks of it, you have to configure everything just right:

Export data from Power BI using Python

"Re-search. It...

So essentially you're grouping islands together. (The island consists of consecutive months of data). Fancy that! I found an old Dwain Camps article! (I miss his posts... he could...

Pretend I'm dumb as a rock and explain how your result is correct and how you got there.

Are you talking about something like the "Islands Question" discussed by Itzik Ben-Gan...

• This reply was modified 1 month, 1 week ago by  pietlinden. Reason: clarification