Choices, choices…On this article, you’ll be taught what the chances are for bringing your on-prem SQL Server information to Microsoft Cloth
Choices, choices, choices…Having the likelihood to carry out a sure job in a number of alternative ways is often an awesome “drawback” to have, though fairly often not every possibility is equally efficient. And, Microsoft Cloth is all about “choices”…You wish to ingest the info? No drawback, you should use notebooks, pipelines, Dataflows, or T-SQL. Knowledge transformation wanted? No worries in any respect — once more, it’s possible you’ll leverage notebooks, T-SQL, Dataflows…Knowledge processing, you requested? Lakehouse (Spark), Warehouse (SQL), Actual-Time Intelligence (KQL), Energy BI…The selection is yours once more.
In a nutshell, nearly each single job in Microsoft Cloth will be accomplished in a number of methods, and there’s no “proper” or “unsuitable” software, so long as it will get the job executed (in fact, as effectively as doable).
Due to this fact, this text just isn’t about bringing the on-prem SQL Server information to Cloth within the “proper” approach, however somewhat is an summary of the present choices we’ve got at our disposal. The principle motivation for analyzing these choices and writing about them is the query I’ve been steadily requested in current months: “We now have our…