SQL Server MI and ADF: Best practices for multiple environments?

%3CLINGO-SUB%20id%3D%22lingo-sub-1001951%22%20slang%3D%22en-US%22%3ESQL%20Server%20MI%20and%20ADF%3A%20Best%20practices%20for%20multiple%20environments%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1001951%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20customer%20which%20will%20implement%20a%20new%20data%20warehouse%20based%20on%20the%20architecture%20of%20an%20existing%2C%20on-premises%20SSIS%20environment.%20However%2C%20this%20warehouse%20will%20be%20setup%20in%20Azure.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat's%20best%20practice%20when%20it%20comes%20to%20Azure%20resources%20and%20instances%3F%20%3CSTRONG%3EHow%20should%20I%20think%20when%20separating%20the%20environments%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EMultiple%20managed%20instances%20are%20expensive!%3C%2FEM%3E%26nbsp%3BIs%20it%20a%20good%20idea%20to%20setup%20different%20ADF%20instances%20for%20dev-%2C%20test-%20and%20production%20environments%2C%20and%20connect%20them%20to%20the%20same%20SQL%20instance%2C%20using%20separate%20databases%20within%20that%20managed%20instance%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EToday's%20on-premises%20setup%20is%20three%20physically%20separated%20environments.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1001951%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20%2B%20Storage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

 

We have a customer which will implement a new data warehouse based on the architecture of an existing, on-premises SSIS environment. However, this warehouse will be setup in Azure.

 

What's best practice when it comes to Azure resources and instances? How should I think when separating the environments?

 

Multiple managed instances are expensive! Is it a good idea to setup different ADF instances for dev-, test- and production environments, and connect them to the same SQL instance, using separate databases within that managed instance?

 

Today's on-premises setup is three physically separated environments.

0 Replies