I'd tackle this as you've suggested in terms of three initial tables (but would need to understand their functionality).

To parse the main table, I'd denormalise each row into staging table,...

Microsoft themselves have loads of documentation, from overviews to technical examples:

https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-overview?view=azuresql

That's strange, it should run in less than a second.

Do you have a DBA to refer this to or are you the DBA for this?

Do you have a message broker running? Have the messages stopped being consumed?

The query below might shed some light on it for you:

 SELECT sch.[name], obj.[name], ISNULL(obj.[type_desc],...

Hi Chris, bit late to the party on this, but price is an attribute of the ingredient.

DimIngredient would have a surrogate key as well as a general business key to...

Why are you converting everything to NVARCHAR(4000) in the first place?

What does the actual source look like?

There's a solution for this posted on the Power BI community forum:

https://community.powerbi.com/t5/Desktop/unable-to-connect-to-the-data-source-using-an-encrypted/m-p/459538#M213132

1 SSMS is free. They can download that. Set up the appropriate privileges so that they have db_datareader with execute of stored procedure as an addition.

2 This should go hand...

A...

You have to be careful when using words like 'never'! In my opinion, there is nothing wrong with using SELECT...

Another RedGate fan here.

More importantly, though, are there any SQL standards in your organisation already?

Anything and everything from naming conventions for tables, what capitalisation to use (e.g. camel case, kebab...

Write your query, then in your where conditions use:

([Date] = CAST(GETDATE() as DATE) OR [Date] = DATEADD(month, DATEDIFF(month, 0, CAST(GETDATE() AS DATE)), 0))

No worries, just making sure you're not going...

How are leave cancellations handled?

Just checking that you're not including any future leave that could be cancelled.

For example, before today, it's regarded as booked and taken, whereas after today, it's...

That will get them for all months of...