投稿時間:2022-02-17 02:28:57 RSSフィード2022-02-17 02:00 分まとめ(30件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	気になる、記になる…	ソフトバンク、端末代が21,600円オフになるオンライン限定キャンペーン｢web割｣の対象範囲を期間限定で拡大	https://taisy0.com/2022/02/17/152164.html	対象機種	2022-02-16 16:16:58
AWS	AWS Architecture Blog	Multi-Region Migration using AWS Application Migration Service	https://aws.amazon.com/blogs/architecture/multi-region-migration-using-aws-application-migration-service/	Multi Region Migration using AWS Application Migration ServiceAWS customers are in various stages of their cloud journey Frequently enterprises begin that journey by rehosting lift and shift migrating their on premises workloads into AWS and running Amazon Elastic Compute Cloud Amazon EC instances You can rehost using AWS Application Migration Service MGN a cloud native migration tool You may need to relocate instances and workloads to …	2022-02-16 16:35:26
AWS	AWS Big Data Blog	Export JSON data to Amazon S3 using Amazon Redshift UNLOAD	https://aws.amazon.com/blogs/big-data/export-json-data-to-amazon-s3-using-amazon-redshift-unload/	Export JSON data to Amazon S using Amazon Redshift UNLOADAmazon Redshift is a fast scalable secure and fully managed cloud data warehouse that makes it simple and cost effective to analyze all your data using standard SQL Amazon Redshift offers up to three times better price performance than any other cloud data warehouse Tens of thousands of customers use Amazon Redshift to process exabytes of …	2022-02-16 16:23:08
AWS	AWS Machine Learning Blog	Prepare time series data with Amazon SageMaker Data Wrangler	https://aws.amazon.com/blogs/machine-learning/prepare-time-series-data-with-amazon-sagemaker-data-wrangler/	Prepare time series data with Amazon SageMaker Data WranglerTime series data is widely present in our lives Stock prices house prices weather information and sales data captured over time are just a few examples As businesses increasingly look for new ways to gain meaningful insights from time series data the ability to visualize data and apply desired transformations are fundamental steps However time series data …	2022-02-16 16:35:24
AWS	AWS Media Blog	Haydenfilms Institute builds Cemboo video platform on AWS	https://aws.amazon.com/blogs/media/haydenfilms-institute-builds-cemboo-video-platform-on-aws/	Haydenfilms Institute builds Cemboo video platform on AWSNew solution simplifies access to live and on demand video distribution and archiving using Amazon IVS and AWS Elemental Media Services Multi faceted non profit Haydenfilms Institute HFI is dedicated to advancing the art of filmmaking through education and innovative technology applications Partnering with universities around the U S the organization provides hands on production experience for students and offers …	2022-02-16 16:58:49
python	Pythonタグが付けられた新着投稿 - Qiita	Python 2次元リストをsetに変換する	https://qiita.com/3w36zj6/items/8e595dd658effd92e866	Python次元リストをsetに変換する問題以下の例のような次元のリストlistinlistはsetに変換することができません。	2022-02-17 01:21:43
AWS	AWSタグが付けられた新着投稿 - Qiita	AWS Certified Solutions Architect Associateの試験対策	https://qiita.com/juno_rmks/items/18c4756475c243e07b0d	各カテゴリの概要を読んでいて理解できない用語やテクノロジーがあった場合は、別途学習してください。	2022-02-17 01:04:52
技術ブログ	Mercari Engineering Blog	Android Office Hours〜2022年の技術トレンド大予想！〜を開催しました！ #android_oh	https://engineering.mercari.com/blog/entry/20220216-cc6ac2d3c4/	hellip	2022-02-16 17:30:14
海外TECH	Ars Technica	RIP Virtual Console: Nintendo will shut off Wii U, 3DS game downloads	https://arstechnica.com/?p=1834718	lifecycle	2022-02-16 16:36:51
海外TECH	MakeUseOf	ClickUp Views: What They Are and How to Use Them	https://www.makeuseof.com/clickup-views-how-to-use/	clickup	2022-02-16 16:31:12
海外TECH	MakeUseOf	How to Fix DirectX Function GetDeviceRemovedReason Failed Error on Windows	https://www.makeuseof.com/windows-directx-function-getdeviceremovedreason-failed-error-fix/	failed	2022-02-16 16:16:12
海外TECH	DEV Community	Configure secret-less connection from App Services to Azure Sql via terraform	https://dev.to/maxx_don/configure-secret-less-connection-from-app-services-to-azure-sql-via-terraform-2jbg	Configure secret less connection from App Services to Azure Sql via terraformIt s been a while since we can connect App services to Azure Sql in a secret less fashion using managed service identity MSI for brevity from now onwards The configuration is a bit more complicated than connecting to other Azure services e g Azure Storage Account because it involves running some queries on the Azure Sql database in order to create the user and grant them the required privileges for more info see the tutorial here In order to be able to connect to Azure Sql with MSI we need to configure few things Grant database access to Azure AD usersTurn on MSI on the App ServiceCreate a user for the service principal and grant the required privileges in the database s Change the connection string to use the new authentication modeThis is quite easy to do manually but if you are using IaC then manual changes are a no go Configure all of this in terraform was a non trivial task and took me quite a bit to understand the ins and outs and since I wasn t able to find much documentation online I decided to put together this blog post Step Grant database access to Azure AD usersIn order to be able to connect to Azure Sql with a managed identity we need to configure the Azure Sql Server to allow Azure AD authentication you can read more on the subject here Via terraform we can configure it adding the azuread administrator block on the Azure Sql Server resource as shown below resource azurerm mssql server sql azuread administrator login username var sql server ad admin username object id var sql server ad admin object id Here we re passing in the user name and the object id of the Azure AD User or Azure AD Group that we want to configure as the server admin Step Turn on MSI on the App ServiceIn order to create a MSI for our App Service we need to configure the identity block to SytemAssigned as shown below Please note that there s a small catch in terraform about turning on managed identity for an existing App Service essentially you can t use it until it s there so you may need to run terraform apply twice one to turn on MSI and then the second time to grant some privileges to it You can find more details on an issue I opened in the azurerm terraform provider here resource azurerm app service web name var prefix web backend var env location azurerm resource group backend location resource group name azurerm resource group backend name identity type SystemAssigned Step Create a user for the service principal and grant the required privileges in the database s This is the tricky part that I struggled to automate because it requires running a couple of sql commands in the Sql Server database as suggested in this article here The sql you need to run creates a user and grants it the required privileges as shown below CREATE USER ServicePrincipalName FROM EXTERNAL PROVIDER GOALTER ROLE db datareader ADD MEMBER ServicePrincipalName ALTER ROLE db datawriter ADD MEMBER ServicePrincipalName The point of this article though is to take care of this via terraform in order to do so we need to Get the current Azure tenant idRead the App Service service principal from Azure ADCreate the user and grant it required privileges in the databaseLet s see how we can achieve this with terraform Get current tenant idThis is easy we can use a built in terraform data source to access it data azurerm client config current Read the App Service service principal from Azure ADHere we can once again use a terraform data source to get access to the application id property of the generated MSI as follows data azuread service principal web managed identity object id azurerm app service web identity principal id Create the user and grant it required privilegesIn order to achieve this step we need to use a rd party provider called mssql user you can find it on the terraform registry hereThe only catch here is that you need to specify an Azure AD credential to connect to the Azure Sql database so you can use the user we configured in the step above If you used an Azure AD group instead you may create a service principal add it to the group in Azure AD and use it s client id client secret to connect to the database resource mssql user web server host azurerm mssql server sql fully qualified domain name azure login tenant id data azurerm client config current tenant id client id var sql sp client id client secret var sql sp client secret object id data azuread service principal web managed identity application id database var database name username azurerm app service web name roles db datareader db datawriter Here we need to specify few things The FQDN name of the Azure Sql ServerHow to login to the database I m using a service principal that s been added to the Azure AD group that s set as the Azure Sql Admin What s the object id of the service principal we are granting access toWhat s the name of the service principalWhat roles we want to assign to it Step Change the connection string to use the new authentication modeNote that you need to reference System Data SqlClient version or greater for dotnet core older versions doesn t support Authentication Active Directory Defaultlocals connection string Server var prefix sql var env database windows net Authentication Active Directory Default Database var database name MultipleActiveResultSets False Encrypt True TrustServerCertificate False Connection Timeout Persist Security Info False and then we just need to set this new connection string on the App Service as follows resource azurerm app service web app settings ConnectionStrings Database local connection string As a last step I m showing the terraform configuration to include all the required providers used to achieve this terraform required providers azurerm source hashicorp azurerm version gt azuread source hashicorp azuread version gt mssql source betr io mssql version Nothing else needs to change in your code given you were reading the connection string from the configuration I hope you find this useful	2022-02-16 16:49:24
海外TECH	DEV Community	Day 6 of Studying LeetCode Solution until I Can Solve One on My Own: Problem#1534.Count Good Triplets(Easy/JavaScript)	https://dev.to/corndog_com567/day-6-of-studying-leetcode-solution-until-i-can-solve-one-on-my-own-problem1534count-good-tripletseasyjavascript-2feo	Day of Studying LeetCode Solution until I Can Solve One on My Own Problem Count Good Triplets Easy JavaScript Intro I am a former accountant turned software engineer graduated from coding bootcamp in January Algorithms and Data Structure is an unavoidable part of interviews for most of the tech companies now And one of my friends told me that you need to solve a medium leetcode problem under seconds in order to get into the top tech companies So I thought I d start learning how to do it while job searching Since I have no clue on how to solve any of the problems even the easy ones I thought there is no point for me to waste hours and can t get it figured out Here is my approach Pick a leetcode problem randomly or Online Assessment from targeted companies Study solutions from Youtube or LeetCode discussion section One brute force solution another one more optimal Write a blog post with detailed explanation and do a verbal walk through to help understand the solutions better Code out the solution in LeetCode without looking at the solutionsCombat the forgetting curve Re do the question for the next three days And come back regularly to revisit the problem Problem Count Good TripletsDifficulty Easy Language JavaScript Company IBM Backend Developer OA not exactly see note Given an array of integers arr and three integers a b and c You need to find the number of good triplets A triplet arr i arr j arr k is good if the following conditions are true lt i lt j lt k lt arr length arr i arr j lt a arr j arr k lt b arr i arr k lt cWhere x denotes the absolute value of x Return the number of good triplets Example Input arr a b c Output Explanation There are good triplets Example Input arr a b c Output Explanation No triplet satisfies all conditions Constraints lt arr length lt lt arr i lt lt a b c lt Solution var countGoodTriplets function arr a b c let output create an empty array to store the triplets for i i lt arr length i for j i j lt arr length j for k j k lt arr length k loop note through three letters in the given arr if Math abs arr i arr j lt a amp amp Math abs arr j arr k lt b amp amp Math abs arr i arr k lt c use if statement note Logical AND amp amp note andabsolute value note to find the triplets meets the conditions output push arr i arr j arr k Once triplets are found push note it to the output array return output length return length note of the output array Solution Submission detail as of Data below could vary since there are new submissions daily Runtime msMemory Usage MBTime complexity Time complexity of the method is O n whichis for sorting Once the array of intervals is sorted mergingtakes linear time Space complexity O Solution improve run time by half and space by just changing lines var countGoodTriplets function arr a b c let count Since the problem is asking for the length and not the actualarray of the triplets In this solution we will use count instead of create an actual array to improve runtime and space for i i lt arr length i for j i j lt arr length j for k j k lt arr length k if Math abs arr i arr j lt a amp amp Math abs arr j arr k lt b amp amp Math abs arr i arr k lt c count while previous steps are the same as solution one we willincrease count note for every triplet found return count Solution Submission detail as of Data below could vary since there are new submissions daily Runtime msMemory Usage MBTime complexity Time complexity of the method is O n whichis for sorting Once the array of intervals is sorted mergingtakes linear time Space complexity O References LeetCode Problem LinkNote IBM Back End Developer OA Fall Note for loopNote Math abs Note if statementNote Logical AND amp amp Note Array pushNote Array lengthNote Increment Blog Cover Image Credit	2022-02-16 16:01:35
Apple	AppleInsider - Frontpage News	CalDigit TS4 Thunderbolt hub review: The dock of our dreams	https://appleinsider.com/articles/22/02/16/caldigit-ts4-thunderbolt-hub-review-the-dock-of-our-dreams?utm_medium=rss	CalDigit TS Thunderbolt hub review The dock of our dreamsThe new CalDigit Thunderbolt Station ーor TS ーconnects ports to your Mac and delivers plenty of power The all new CalDigit TS Thunderbolt hubThis new dock is one of few Thunderbolt hubs to come to market Apple s just started to adopt Thunderbolt and we re sure to see an influx from major accessory makers soon Read more	2022-02-16 16:36:23
Apple	AppleInsider - Frontpage News	Reports of TikTok shattering iOS & Android security are overblown	https://appleinsider.com/articles/22/02/16/reports-of-tiktok-shattering-ios-android-security-are-overblown?utm_medium=rss	Reports of TikTok shattering iOS amp Android security are overblownReports about TikTok bypassing device security for access to Full User Data are both an exaggeration and a misunderstanding about Apple s privacy technologies but there are still privacy issues associated with the service TikTok isn t great for your privacy but it isn t a threat to your device security eitherTwo white hat security studies surrounding TikTok and its code have surfaced some concerns surrounding privacy and security with the app However reporting based on these studies have taken the available information and warped it into something that sounds much scarier to the average reader Read more	2022-02-16 16:28:14
金融	金融庁ホームページ	金融庁職員の新型コロナウイルス感染について公表しました。	https://www.fsa.go.jp/news/r3/sonota/20220216.html	新型コロナウイルス	2022-02-16 18:00:00
金融	金融庁ホームページ	貸金業者に対し、若年者への貸付けに当たっては貸金業協会(自主規制機関)の自主ガイドラインを遵守するよう要請しました。	https://www.fsa.go.jp/ordinary/chuui/seinen.html#guideline	自主規制	2022-02-16 17:59:00
金融	金融庁ホームページ	金融審議会「市場制度ワーキング・グループ」（第15回）　議事次第について公表しました。	https://www.fsa.go.jp/singi/singi_kinyu/market-system/siryou/20220217.html	金融審議会	2022-02-16 17:00:00
金融	金融庁ホームページ	「企業内容等の開示に関する留意事項について（企業内容等開示ガイドライン）」の改正（案）について公表しました。	https://www.fsa.go.jp/news/r3/sonota/20220216/20220216.html	開示	2022-02-16 17:00:00
ニュース	ジェトロ ビジネスニュース（通商弘報）	外国人の指紋登録、モスクワ市内の登録所は混雑なし	https://www.jetro.go.jp/biznews/2022/02/ea77534bc229f725.html	登録	2022-02-16 16:40:00
ニュース	ジェトロ ビジネスニュース（通商弘報）	「脱炭素」達成に向け、原発6基以上を建設へ	https://www.jetro.go.jp/biznews/2022/02/844cd1422c279609.html	達成	2022-02-16 16:30:00
ニュース	ジェトロ ビジネスニュース（通商弘報）	日本産米粉でドイツ伝統のケーキ開発、ワークショップでベーカリー関係者に訴求	https://www.jetro.go.jp/biznews/2022/02/e00efb34700df55c.html	関係	2022-02-16 16:20:00
ニュース	ジェトロ ビジネスニュース（通商弘報）	2021年のGDP成長率、前年比7.5％で記録的な増加	https://www.jetro.go.jp/biznews/2022/02/e55ebc2aee6960ff.html	記録	2022-02-16 16:10:00
ニュース	BBC News - Home	Prince Andrew: Where does he get his money from?	https://www.bbc.co.uk/news/uk-60401663?at_medium=RSS&at_campaign=KARANGA	legal	2022-02-16 16:20:43
ニュース	BBC News - Home	Fishlock double helps Wales down defending champions Scotland in Spain	https://www.bbc.co.uk/sport/football/60338566?at_medium=RSS&at_campaign=KARANGA	Fishlock double helps Wales down defending champions Scotland in SpainJess Fishlock inspires Wales as they end Scotland s Pinatar Cup defence with Pedro Martinez Losa s side now competing for fifth place	2022-02-16 16:31:36
ニュース	BBC News - Home	Murray wins only one game in Qatar Open last-16 defeat	https://www.bbc.co.uk/sport/tennis/60397796?at_medium=RSS&at_campaign=KARANGA	qatar	2022-02-16 16:34:30
ニュース	BBC News - Home	What does Putin want?	https://www.bbc.co.uk/news/world-europe-56720589?at_medium=RSS&at_campaign=KARANGA	ukraine	2022-02-16 16:32:53
北海道	北海道新聞	ラオスで３種の類似ウイルス　新型コロナ、コウモリから	https://www.hokkaido-np.co.jp/article/646654/	新型コロナウイルス	2022-02-17 01:17:00
北海道	北海道新聞	Ｇ７首脳会合　２４日軸検討　１９日にはドイツで外相会合	https://www.hokkaido-np.co.jp/article/646651/	首脳	2022-02-17 01:01:00
GCP	Cloud Blog	Helping the state of Ohio build a digitally skilled workforce	https://cloud.google.com/blog/topics/public-sector/helping-state-ohio-build-digitally-skilled-workforce/	Helping the state of Ohio build a digitally skilled workforceDigital skills training is critical to the future of work and economic mobility in Americaー of jobs that require less than a bachelor s degree while paying a living wage are described as “digitally intensive Burning Glass but almost one third of U S workers lack digital skills National Skills Coalition This growing divide between demand for digital skills and the supply of trained workers has encouraged states like Ohio to consider new approaches to closing the skills gap  Like many states Ohio has a large number of open jobs that require digital skillsーthere have been over new cloud IT Support user experience UX design data analyst and project management jobs posted in the state of Ohio in the past months Burning Glass These new jobs need trained technical workers and local employers across the government health retail and financial sectors are searching for talent with the skills needed to fill them To help address this growing challenge Google is partnering with Ohio to provide fundamentaldigital skills Google Career Certificates professional Google Cloud certifications and more  Google is enabling Ohio s workforce system to support jobseekers in five key ways Google Cloud Skills Boost is open to anyone and free to startState employees and residents of Ohio alike are successfully using Google Cloud Skills Boost to grow their cloud skills Hundreds of Ohio learners have successfully accessed Google Cloud Skills Boost Google Cloud s library of labs and courses to help simplify cloud skills Right now Google has made this library free for the first days enabling residents to start working toward certifications they need to fill cloud based roles without added cost Learners in Google Cloud Skills Boost can earn certifications or simply brush up on skills they need professionally Entirely online the pace of learning is up to the user and covers everything from cloud basics to more advanced skills  Accessible Career Certificates and job opportunities for residentsWe re making Google Career Certificates more accessible to Ohioans and the public and private sector community partners that serve and employ them Thousands of Ohio based learners are using Google Career Certificates to gain the skills they need to start careers in the career fields of data analytics IT support and project management and user experience UX design These are in demand well paying career fields that employers and workforce development institutions across the public and private sectors are hiring for The Certificates do not require prior experience or a degree and of graduates nationally report a positive career impact in their career trajectory e g new job raise or promotion within six months of completion Google has partnered with non profit organizations and local education partners to increase awareness of Google Career Certificates and help Ohio residents take advantage of the courses which are free for Community College and Career and Technical Education CTE high schools Additionally  through our Employer Consortium which includes Expedient Pep Promotions and many employers that hire within Ohio we re connecting Google Career Certificate program graduates who have job ready skills with more than employers across a diverse range of industries Partnerships with schoolsIn Ohio colleges and universities offer training and certifications through our Google Cloud Career Readiness Program and free Google Cloud Computing Foundations curriculum By bringing Google Cloud into the classroom we re helping expose students to the cloud technology they ll encounter in the workforce We ve also enabled faculty at Ohio institutions to help their students access Google Cloud by issuing more than of Google Cloud teaching credits Additionally Google Career Certificates are free for all community colleges and career and technical CTE high schools to include in their curriculum The American Council on Education ACE has recommended each certificate for up to college credits which gives Ohioans who have some post secondary education but no college degree an affordable on ramp to earning their diploma Tech skills don t have to start at the university level either We ve partnered with Ohio and several other states to help build digital skills for the future by bringing programs like Google Workspace into K classrooms and helping teachers build lessons around digital literacy coding and more Government employee trainingWith the move to remote work becoming permanent for some employers need to go beyond ensuring new hires have the skills needed to manage a digitally connected workplace  Agencies also want to be sure that their current employees have the skills they need to manage and make the most of cloud capabilities One example the Ohio Department of Jobs and Family Services secured licenses for their staff to get full access to on demand Google Cloud training for months enabling their staff to build cloud skills on a flexible timeline And anyone State of Ohio employee or otherwise can access Google Cloud Skills Boost for free for the first days to build their own cloud skills Investing in a talent ecosystemIn Governor Mike DeWine and Lt Governor Jon Husted launched the State of Ohio s TechCred program This program gives Ohio employers the chance to upskill current and future employees and two pathways already available through TechCred are Google s Cloud certifications and the Google IT Support Certificate Ohio employers who enroll their eligible employees in Google Cloud training or Google Career Certificates can be reimbursed up to per credential once employees complete a Google Cloud certification or the Google IT Support Certificate What s great about TechCred is that employers can continually apply for funding Funding rounds are typically held every other month and employers can receive up to per round and up to per year “Innovation and technology are changing what skills we need to start and lead a successful career and we must help people efficiently earn the skills they need to succeed said Ohio Lt Governor Jon Husted Director of the Governor s Office of Workforce Transformation “This requires new ways to deliver education and skill development and TechCred has proven to be an effective way to up skill tens of thousands of Ohioans Google is also investing in expanding its data center and Google Cloud region presence in central Ohio These investments bring job opportunities as well as skilled workers to the state and help grow the local talent pipeline further See how we re helping build an empowered workforceWhat is happening in Ohio can happen in other states too  As Ohio builds new training pathways to grow the local labor pool other states can pick up their playbook To learn more about how we re helping create a more skilled workforce visit the Google Learning page Source Burning Glass Data Based on program graduate survey responses United States	2022-02-16 17:00:00