Choices, choices…On this article, you’ll study 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 normally 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 utilize notebooks, pipelines, Dataflows, or T-SQL. Information transformation wanted? No worries in any respect — once more, you might leverage notebooks, T-SQL, Dataflows…Information processing, you requested? Lakehouse (Spark), Warehouse (SQL), Actual-Time Intelligence (KQL), Energy BI…The selection is yours once more.
In a nutshell, virtually each single job in Microsoft Cloth could be accomplished in a number of methods, and there’s no “proper” or “unsuitable” device, so long as it will get the job completed (after all, 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” means, however reasonably is an summary of the present choices we’ve got at our disposal. The primary motivation for analyzing these choices and writing about them is the query I’ve been incessantly requested in latest months: “Now we have our…