Enterprise TechHow to Migrate SQL Server to Cloud for BI Workloads April 10, 20164718 views0Share By IG ShareHow to Migrate SQL Server to Cloud for BI Workloads you ask? The short answer to this is “It Depends“.Note: If you buy something from our links, we might earn a commission. See our disclosure statement.On a broader level, there are primarily three different ways solutions available today.Lift & shift or “Move”Migrating application with no changesReducing infrastructure cost (CAPEX), not willing to invest in applicationMoving packaged app not certified for AzureOne or small number of applicationsIT controlled and managedNeed to control OS and instanceSolution: SQL Server in a VM on AzureLift & port or “Remodelling”Modernizing applicationLeveraging scale, reducing infrastructure management overhead (OPEX)One or many applicationsIT controlled and managedSolution: SQL Server in a VM on Azure or Azure SQL Database using the SAAS ModelBuild for cloud or “New construction”New modern applicationsLarge scaleAbility to start small and grow very largeBuilding SaaS applicationsMoving to devOps modelUnpredictable growthLarge number of databasesSolution: SQL Server in a VM on Azure or Azure SQL Database using the SAAS ModelWhat Common Cloud Application Patterns for development today? Cloud-born SaaSCurrently have the ability to disrupt traditional apps and business models in the market.Enterprise apps serving customersEither Create new or re-architect existing apps with the ability to meet customer needs to augment their products and services.ISVs going SaaSRe-architect for cloud to transition like Sage, Salesforce and others. Transitioning from selling software licenses to subscription based SaaS provider model.Enterprise apps serving employeesIn most cases, they are on-premise apps. Create or re-architect apps to cloud for internal use, moistly built by internal development staff.Azure SQL Database Use cases:Scales on the flyRedefines multi-tenancyLearns & adapts based on Workload patters.Works in your Environment with most deployment modelsSecures and protects with Row Level Security, Encryption options, Secure Endpoints Protection and much more. 25% OFF, Use Promocode: APRIL25OFFBusiness Intelligence on AzureIf the data is born in the cloud. it can be captured and pre-aggregated in Azure, globally at scale. Extracting the data on-premises and creating Data Model is more expensive.Power BI consumes data from everywhere and hosts it on the Microsoft Cloud Infeastructure.PolyBase in APS and SQL Server 2016 can push / pull data between Azure Blobstorage after processing in HDInsight.Users can connect Excel to BI data sources running Azure workloads like Blobs, Hadoop, SSAS Cubes etc.IaaS is a great solution for lift-shift migrations and in some cases, for new builds too.Why Azure Cloud and IaaS is a great solution for BI deployments?You can shutdown the ETL server do after the database is loaded and you will not be charged it anymore.Your customer does not need the Data Warehouse once the cube is processed. Shutdown the VM once the Data is loaded on the Cube.Can you hub-spoke the Data Warehouse / Data Marts between different size VM’s for performance and scale. See Azure Virtual Machines.Use Azure Resource Manager to enable rapid development and deployment.I hope that gives you a good enough reason to move to the cloud! Affiliate Disclosure: Faceofit.com is a participant in the Amazon Services LLC Associates Program. As an Amazon Associate we earn from qualifying purchases. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0
Enterprise TechList of the Best Threadripper Pro Workstations – W-3100 Xeon W-3200 & W-1200 Alternatives By IGMay 25, 2021
Enterprise TechList of the Best HPTX Cases – Huge PC Cases for Large BuildsThe computer cases have been one of the essential aspects when it comes to enjoying ...
AzureBest Industrial IoT Routers & Gateways For AWS and Azure IoT ServicesIn this article, we are going to list out the Best Industrial IoT Routers for professional ...
Enterprise TechWhat Is A DataCenter Power Distribution Unit (pdu) Server Rack CabinetsNo matter whether you call it a server closet or server room or a cabinet, ...
Storage SystemsWD SE vs WD Red Pro Specifications Comparison – Enterprise Class NASThe HDDs or the Hard Disk drives are slowly moving into oblivion with the advancements ...