[et_\u200bpb_\u200bsection fb_built=\u201c1\u201d _builder_version=\u201c4.16\u201d _module_preset=\u201cdefault\u201d da_disable_devices=\u201coff|off|off\u201d global_\u200bcolors_\u200binfo=\u201d{}\u201d da_is_popup=\u201coff\u201d da_exit_intent=\u201coff\u201d da_has_close=\u201con\u201d da_alt_close=\u201coff\u201d da_dark_close=\u201coff\u201d da_not_modal=\u201con\u201d da_is_singular=\u201coff\u201d da_with_loader=\u201coff\u201d da_has_shadow=\u201con\u201d][et_pb_row _builder_version=\u201c4.16\u201d _module_preset=\u201cdefault\u201d global_colors_info=\u201d{}\u201d][et_pb_column type=\u201c4_4\u201d _builder_version=\u201c4.16\u201d _module_preset=\u201cdefault\u201d global_colors_info=\u201d{}\u201d][et_pb_text _builder_version=\u201c4.17.4\u201d _module_preset=\u201cdefault\u201d text_orientation=\u201cjustified\u201d global_colors_info=\u201d{}\u201d]<\/p>\n
Nowa\u00addays, data ware\u00adhous\u00ading solu\u00adtions large\u00adly rely on cloud resources. At Islet, a large por\u00adtion of new solu\u00adtions are imple\u00adment\u00aded as Lake\u00adhouse solu\u00adtions, either on top of Synapse Ana\u00adlyt\u00adics or Data\u00adbricks. The imple\u00admen\u00adta\u00adtion is deter\u00admined based on require\u00adments, and the data ware\u00adhous\u00ading solu\u00adtion is cho\u00adsen based on which tech\u00adnol\u00ado\u00adgy best ful\u00adfills these requirements.<\/p>\n
In rare cas\u00ades, the use of cloud ser\u00advices is ini\u00adti\u00adat\u00aded by bring\u00ading along part of the old solu\u00adtion. These few cas\u00ades are, for exam\u00adple, those where the orig\u00adi\u00adnal solu\u00adtion is so broad or impor\u00adtant to main\u00adtain con\u00adti\u00adnu\u00adity of oper\u00ada\u00adtions. We will go through the ways in which the tran\u00adsi\u00adtion to the cloud can be made by bring\u00ading along part of the old solution.<\/p>\n
<\/p>\n
In this post, we will go through ways to start using Microsoft\u00ad\u2019s cloud ser\u00advices eas\u00adi\u00adly and effort\u00adless\u00adly in scope of data and ana\u00adlyt\u00adics. Cloud ser\u00advices offer sev\u00ader\u00adal ben\u00ade\u00adfits, such as flex\u00adi\u00adbil\u00adi\u00adty, per\u00adfor\u00admance, and cost-effectiveness.<\/p>\n
Flex\u00adi\u00adbil\u00adi\u00adty is one of the most sig\u00adnif\u00adi\u00adcant ben\u00ade\u00adfits of cloud ser\u00advices. Microsoft offers var\u00adi\u00adous ser\u00advices and solu\u00adtions that can be scaled accord\u00ading to your needs. You can eas\u00adi\u00adly increase or decrease capac\u00adi\u00adty and resources in line with your busi\u00adness require\u00adments. This gives you flex\u00adi\u00adbil\u00adi\u00adty and the abil\u00adi\u00adty to adapt quick\u00adly to rapid\u00adly chang\u00ading busi\u00adness conditions.<\/p>\n
Per\u00adfor\u00admance is anoth\u00ader impor\u00adtant advan\u00adtage that cloud ser\u00advices pro\u00advide. Microsoft\u00ad\u2019s cloud ser\u00advices are designed to pro\u00advide high per\u00adfor\u00admance and effi\u00adcient use of resources. You can lever\u00adage the scal\u00ada\u00adbil\u00adi\u00adty and per\u00adfor\u00admance offered by cloud ser\u00advices when deal\u00ading with large amounts of data or per\u00adform\u00ading heavy com\u00adpu\u00adta\u00adtion tasks. This ensures the effi\u00adcien\u00adcy and speed of your busi\u00adness operations.<\/p>\n
Cost-effec\u00adtive\u00adness is the third crit\u00adi\u00adcal fac\u00adtor that attracts busi\u00adness\u00ades to use cloud ser\u00advices. Microsoft\u00ad\u2019s cloud ser\u00advices offer flex\u00adi\u00adble pric\u00ading mod\u00adels where you pay only for the resources used. You don\u2019t need to invest a large ini\u00adtial cap\u00adi\u00adtal or main\u00adtain expen\u00adsive infra\u00adstruc\u00adtures. Along with scal\u00ada\u00adbil\u00adi\u00adty, cloud ser\u00advices also offer the oppor\u00adtu\u00adni\u00adty to opti\u00admize costs and pay only for the ser\u00advices you need.<\/p>\n
A tra\u00addi\u00adtion\u00adal data ware\u00adhouse solu\u00adtion imple\u00adment\u00aded with Microsoft prod\u00aducts is usu\u00adal\u00adly based on the SQL Serv\u00ader, SSIS pack\u00adages for data trans\u00adfer, and sched\u00adul\u00ading with SQL Serv\u00ader Agent.<\/p>\n
SQL Serv\u00ader is a well-known and reli\u00adable data\u00adbase solu\u00adtion that pro\u00advides an effec\u00adtive foun\u00adda\u00adtion for a data ware\u00adhous\u00ading environment.<\/p>\n
SSIS (SQL Serv\u00ader Inte\u00adgra\u00adtion Ser\u00advices) is an ETL (Extract, Trans\u00adform, Load) tool pro\u00advid\u00aded by Microsoft, which sim\u00adpli\u00adfies data trans\u00adfer between dif\u00adfer\u00adent systems.<\/p>\n
Sched\u00adul\u00ading with the SQL Serv\u00ader Agent pro\u00advides automa\u00adtion and sched\u00adul\u00ading in the data ware\u00adhous\u00ading environment.<\/p>\n
This com\u00adbi\u00adna\u00adtion of SQL Serv\u00ader, SSIS pack\u00adages, and SQL Serv\u00ader Agent has pro\u00advid\u00aded a sol\u00adid foun\u00adda\u00adtion for data man\u00adage\u00adment and analysis.<\/p>\n
The first step is to decide which parts of the cur\u00adrent data ware\u00adhouse you want to bring to the cloud. You can choose a cer\u00adtain or all parts depend\u00ading on your needs and busi\u00adness objec\u00adtives. It\u2019s impor\u00adtant to ensure and dou\u00adble check that the solu\u00adtions to be trans\u00adferred to the cloud are com\u00adpat\u00adi\u00adble with the new envi\u00adron\u00adment so that the tran\u00adsi\u00adtion is seamless.<\/p>\n
A tra\u00addi\u00adtion\u00adal data ware\u00adhouse solu\u00adtion imple\u00adment\u00aded with Microsoft prod\u00aducts is well-suit\u00aded for a lift-and-shift type of cloud migration.<\/p>\n
By mov\u00ading an SQL Serv\u00ader data ware\u00adhouse locat\u00aded on your own servers, as well as the SSIS runs, to the Microsoft\u00ad\u2019s Azure SQL Man\u00adaged Instance, the old solu\u00adtion can be migrat\u00aded with as lit\u00adtle effort as pos\u00adsi\u00adble, while also enabling the devel\u00adop\u00adment of new cloud-native solutions.<\/p>\n
Azure SQL Man\u00adaged Instance pro\u00advides near\u00adly 100% com\u00adpat\u00adi\u00adbil\u00adi\u00adty with local SQL Serv\u00ader, which facil\u00adi\u00adtates the tran\u00adsi\u00adtion from local data ware\u00adhous\u00ades to the cloud. In addi\u00adtion, exe\u00adcut\u00ading SSIS pack\u00adages in Azure Data Fac\u00adto\u00adry allows exist\u00ading ETL process\u00ades to be used with min\u00adi\u00admal changes.<\/p>\n
Cloud-based data ware\u00adhous\u00ades offer a more cost-effec\u00adtive way to scale resources as need\u00aded. Cus\u00adtomers can reduce costs by mov\u00ading from acquir\u00ading hard\u00adware used by the data ware\u00adhouse to only pay\u00ading for the resources used in the cloud. This avoids com\u00admit\u00adting sig\u00adnif\u00adi\u00adcant costs\u2026 for exam\u00adple every four years, and costs can be mon\u00adi\u00adtored and adjust\u00aded accord\u00ading to the resources used. Most resources in the Azure cloud offer scal\u00ada\u00adbil\u00adi\u00adty, as well as the option to shut down resources when they are not in use.<\/p>\n
Azure SQL Man\u00adaged Instance pro\u00advides scal\u00adable per\u00adfor\u00admance com\u00adpared to a local data ware\u00adhouse. Scal\u00adable resources ensure that sys\u00adtem capac\u00adi\u00adty adapts to cus\u00adtomer needs and enables effi\u00adcient work with large amounts of data. Rarely there are sit\u00adu\u00ada\u00adtions where the resources offered by Azure would no longer pro\u00advide scal\u00ada\u00adbil\u00adi\u00adty. The archi\u00adtec\u00adture must always con\u00adsid\u00ader the nature of dif\u00adfer\u00adent resources, the usage require\u00adments of the solu\u00adtion, and there\u00adby make the right resource choices.<\/p>\n
With cloud ser\u00advices, cus\u00adtomers can take advan\u00adtage of advanced resource secu\u00adri\u00adty that are con\u00adtin\u00adu\u00adous\u00adly updat\u00aded along with the ser\u00advice. In this case, the upkeep of keep\u00ading updates up to date is trans\u00adferred to the cloud ser\u00advice provider. Too often, local solu\u00adtions have lagged in updates or have even fall\u00aden out\u00adside of updates due to out\u00addat\u00aded oper\u00adat\u00ading systems.<\/p>\n
<\/p>\n
The solu\u00adtion does\u00adn\u2019t usu\u00adal\u00adly stop when moved to the cloud. This is only the first step towards cloud-native devel\u00adop\u00adment. To enable fur\u00adther devel\u00adop\u00adment, you can cre\u00adate new envi\u00adron\u00adments and use the ser\u00advices offered by the cloud even more efficiently.<\/p>\n
When cloud migra\u00adtion reach\u00ades the point where rapid tran\u00adsi\u00adtion to the cloud has been achieved based on the orig\u00adi\u00adnal solu\u00adtion, then we need to con\u00adsid\u00ader how the devel\u00adop\u00adment of the new solu\u00adtion will be imple\u00adment\u00aded. In this case, it makes sense to con\u00adtin\u00adue with a cloud-native solu\u00adtion, which means grad\u00adu\u00adal\u00adly mov\u00ading away from an SQL Serv\u00ader and SSIS-based solution.<\/p>\n
Below is an exam\u00adple of the ben\u00ade\u00adfits of resources used for cloud-native devel\u00adop\u00adment, for exam\u00adple if Azure Synapse<\/strong> is cho\u00adsen for cloud-native development.<\/p>\n <\/p>\n To enable cloud-native devel\u00adop\u00adment, it is cru\u00adcial to cre\u00adate new envi\u00adron\u00adments and uti\u00adlize cloud ser\u00advices such as Azure Synapse and Data Lake. With these, you can con\u00adtin\u00adue to devel\u00adop your solu\u00adtion, scale resources as need\u00aded, and lever\u00adage the full ben\u00ade\u00adfits offered by the cloud.<\/p>\n Microsoft also offers oth\u00ader cloud-native devel\u00adop\u00adment mod\u00adels to sup\u00adport data and ana\u00adlyt\u00adics solu\u00adtions. You might see some\u00adthing about those in our Islet blogs\u2026 stay tuned!<\/p>\n <\/p>\n Best regards,<\/p>\n Mikko and Ilkka<\/p>\n <\/p>\n PS. If inter\u00adest\u00aded, read more about our Data & Ana\u00adlyt\u00adics ser\u00advices here<\/a><\/strong><\/p>\n <\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n #Islet\u00adGroup #data #ana\u00adlyt\u00adics #Pow\u00ader\u00adPlat\u00adform #Dat\u00ada\u00adPlat\u00adform #Microsoft #ware\u00adhous\u00ading #cloud<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Nowa\u00addays, data ware\u00adhous\u00ading solu\u00adtions large\u00adly rely on cloud resources. At Islet, a large por\u00adtion of new solu\u00adtions are imple\u00adment\u00aded as Lake\u00adhouse solu\u00adtions, either on top of Synapse Ana\u00adlyt\u00adics or Data\u00adbricks. The imple\u00admen\u00adta\u00adtion is deter\u00admined based on require\u00adments, and the data ware\u00adhous\u00ading solu\u00adtion is cho\u00adsen based on which tech\u00adnol\u00ado\u00adgy best ful\u00adfills these require\u00adments. In rare cases, [\u2026]<\/p>\n","protected":false},"author":20,"featured_media":230504,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":" [et_pb_section fb_built=\"1\" _builder_version=\"4.16\" _module_preset=\"default\" da_disable_devices=\"off|off|off\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_row _builder_version=\"4.16\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_column type=\"4_4\" _builder_version=\"4.16\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_text _builder_version=\"4.17.4\" _module_preset=\"default\" text_orientation=\"justified\" hover_enabled=\"0\" global_colors_info=\"{}\" theme_builder_area=\"post_content\" sticky_enabled=\"0\"]<\/p> T\u00e4ss\u00e4 postauksessa k\u00e4ymme l\u00e4pi tapoja aloittaa Microsoftin pilvipalveluiden k\u00e4ytt\u00f6 helposti ja vaivattomasti datan ja analytiikan n\u00e4k\u00f6kulmasta. Pilvipalvelut tarjoavat useita etuja, kuten joustavuutta, suorituskyky\u00e4 ja kustannustehokkuutta.<\/strong><\/p> Joustavuus on yksi merkitt\u00e4vimmist\u00e4 pilvipalveluiden eduista. Microsoft tarjoaa useita erilaisia palveluita ja ratkaisuja, jotka voidaan skaalata tarpeen mukaan. Voit helposti lis\u00e4t\u00e4 tai v\u00e4hent\u00e4\u00e4 kapasiteettia ja resursseja yrityksesi tarpeiden mukaisesti. T\u00e4m\u00e4 antaa sinulle joustavuutta ja mahdollisuuden sopeutua nopeasti muuttuviin liiketoimintaolosuhteisiin.<\/p> Suorituskyky on toinen t\u00e4rke\u00e4 etu, jonka pilvipalvelut tarjoavat. Microsoftin pilvipalvelut ovat suunniteltu tarjoamaan korkeaa suorituskyky\u00e4 ja tehokasta resurssien k\u00e4ytt\u00f6\u00e4. Voit hy\u00f6dynt\u00e4\u00e4 pilvipalveluiden tarjoamaa skaalautuvuutta ja suorituskyky\u00e4 esimerkiksi k\u00e4sitelless\u00e4si suuria datam\u00e4\u00e4ri\u00e4 tai suorittaessasi raskaita laskentateht\u00e4vi\u00e4. N\u00e4in voit varmistaa yrityksesi toiminnan tehokkuuden ja nopeuden.<\/p> Kustannustehokkuus on kolmas t\u00e4rke\u00e4 tekij\u00e4, joka houkuttelee yrityksi\u00e4 siirtym\u00e4\u00e4n pilvipalveluiden k\u00e4ytt\u00f6\u00f6n. Microsoftin pilvipalvelut tarjoavat joustavat hinnoittelumallit, joissa maksat vain k\u00e4ytetyist\u00e4 resursseista. Sinun ei tarvitse investoida suurta alkup\u00e4\u00e4omaan tai yll\u00e4pit\u00e4\u00e4 kalliita infrastruktuureja. Pilvipalvelut tarjoavat skaalautuvuuden my\u00f6t\u00e4 my\u00f6s mahdollisuuden optimoida kustannuksia ja maksaa ainoastaan tarvitsemistasi palveluista.<\/p> Perinteinen Microsoftin tuotteilla toteutettu tietovarastoratkaisu perustuu yleens\u00e4 SQL Server -palvelimeen, SSIS-paketteihin tiedonsiirtoon sek\u00e4 ajastuksiin SQL Server Agentin kanssa.<\/p> SQL Server on tunnettu ja luotettava tietokantaratkaisu, joka tarjoaa tehokkaan perustan tietovarastointiymp\u00e4rist\u00f6lle.<\/p> SSIS (SQL Server Integration Services) on Microsoftin tarjoama ETL (Extract, Transform, Load) -ty\u00f6kalu, joka helpottaa tiedonsiirtoa eri j\u00e4rjestelmien v\u00e4lill\u00e4.<\/p> Ajastukset SQL Server Agentin kanssa tarjoavat automaatiota ja aikataulutusta tietovarastointiymp\u00e4rist\u00f6ss\u00e4.<\/p> T\u00e4m\u00e4 yhdistelm\u00e4 SQL Serveri\u00e4, SSIS-paketteja ja SQL Server Agenttia on tarjonnut vankan perustan tiedonhallinnalle ja analysoinnille.<\/p>\n
\n
\u00a0<\/h3>
Perinteinen tietovarastoratkaisu<\/strong><\/h3>
\u00a0<\/h3>
Ty\u00f6nkulun luonti ja riippuvuuksien hallinta<\/strong><\/h3>