投稿時間:2023-05-04 07:18:18 RSSフィード2023-05-04 07:00 分まとめ(18件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] 地域の足はどう変わるのか　赤字鉄道の存廃を巡って	https://www.itmedia.co.jp/business/articles/2305/04/news036.html	itmedia	2023-05-04 06:30:00
Google	カグア！Google Analytics 活用塾:事例や使い方	フィッシング詐欺にひっかかりそうになった話	https://www.kagua.biz/social/risk/20230504a1.html	違和感	2023-05-03 21:00:10
AWS	AWS DevOps Blog	Integrating DevOps Guru Insights with CloudWatch Dashboard	https://aws.amazon.com/blogs/devops/integrating-devops-guru-insights-with-cloudwatch-dashboard/	Integrating DevOps Guru Insights with CloudWatch DashboardMany customers use Amazon CloudWatch dashboards to monitor applications and often ask how they can integrate Amazon DevOps Guru Insights in order to have a unified dashboard for monitoring nbsp This blog post showcases integrating DevOps Guru proactive and reactive insights to a CloudWatch dashboard by using Custom Widgets It can help you to correlate trends …	2023-05-03 21:31:48
AWS	AWS	Amazon Inspector: How to use Lambda Code Scanning (In preview) | Amazon Web Services	https://www.youtube.com/watch?v=VjIhTXeIgM0	Amazon Inspector How to use Lambda Code Scanning In preview Amazon Web ServicesAmazon Inspector now supports code scanning of Lambda functions expanding the existing capability to scan Lambda functions and associated layers for software vulnerabilities in application package dependencies With this expanded capability Amazon Inspector now also scans the custom proprietary application code within a Lambda function for code security vulnerabilities such as injection flaws data leaks weak cryptography or missing encryption based on AWS security best practices When code vulnerabilities are identified in the Lambda function or layer Inspector generates actionable security findings along with impacted code snippets and remediation guidance All findings are aggregated in the Amazon Inspector console routed to AWS Security Hub and pushed to Amazon EventBridge to automate workflows During the preview period Lambda code scanning is available in five AWS Regions US East N Virginia US East Ohio US West Oregon Europe Frankfurt and Europe Ireland at no additional cost to customers Learn more at Subscribe More AWS videos More AWS events videos Do you have technical AWS questions Ask the community of experts on AWS re Post ABOUT AWSAmazon Web Services AWS is the world s most comprehensive and broadly adopted cloud platform offering over fully featured services from data centers globally Millions of customers ーincluding the fastest growing startups largest enterprises and leading government agencies ーare using AWS to lower costs become more agile and innovate faster AmazonInspector CodeScanning AWSLambda vulnerabilityscanning Inspector AWS AmazonWebServices CloudComputing	2023-05-03 21:15:08
AWS	AWS	Migrate at Scale with AWS Application Migration Service | Amazon Web Services	https://www.youtube.com/watch?v=8w-Ks_GEGPw	Migrate at Scale with AWS Application Migration Service Amazon Web ServicesIn this video you ll see how to migrate at scale with AWS Application Migration Service AWS MGN Using the service s import export feature you can import an inventory of servers applications and waves from a CSV file export an existing inventory to a CSV file for offline review and implement bulk modifications by editing and reimporting an exported inventory file For more information on this topic please visit the resource s below Subscribe More AWS videos More AWS events videos Do you have technical AWS questions Ask the community of experts on AWS re Post ABOUT AWSAmazon Web Services AWS is the world s most comprehensive and broadly adopted cloud platform offering over fully featured services from data centers globally Millions of customers ーincluding the fastest growing startups largest enterprises and leading government agencies ーare using AWS to lower costs become more agile and innovate faster AWS AmazonWebServices CloudComputing	2023-05-03 21:15:06
js	JavaScriptタグが付けられた新着投稿 - Qiita	金額をカンマ区切りで表示したい	https://qiita.com/satsuki_higuchi/items/f215f7e5b8ba49203e30	toloca	2023-05-04 06:59:18
Ruby	Rubyタグが付けられた新着投稿 - Qiita	RubyでAtCoder ABC268(A, B, C)を解いてみた	https://qiita.com/shoya15/items/8c7246d574d0fa204504	atcoder	2023-05-04 06:20:14
海外TECH	DEV Community	Connecting an App Service to Azure SQL Database and Storage Account using Azure CLI	https://dev.to/danielfavour/connecting-an-app-service-to-azure-sql-database-and-storage-account-using-azure-cli-1on6	Connecting an App Service to Azure SQL Database and Storage Account using Azure CLIEffective data management is crucial for optimal application performance and SQL databases and storage accounts play a critical role in streamlining data storage and access SQL databases provide a reliable and scalable method of storing and managing data in a structured manner making it easier to search retrieve and analyze while storage accounts offer a secure and scalable platform for storing and accessing large amounts of unstructured data By combining these technologies developers can create a robust data management strategy that meets their app s unique needs In this article we will explore how to connect an App Service to an Azure SQL database and Storage Account using Azure CLI a command line tool that allows you to manage and interact with Azure resources using a shell or command line interface PrerequisitesBefore we get started ensure that you have the following in place An active Azure SubscriptionAzure CLI installedBasic knowledge of Azure Connect to our Azure AccountTo connect to our Azure account we can use the Azure CLI to sign in by running the command below subscription lt subscriptionId gt add subscription hereaz account set s subscription or use az login Run the below command to obtain your subscription ID if you are unaware of itaz loginUpon executing the command a prompt will appear requesting login credentials for your Azure account After successful authentication your terminal should display an output similar to the one below cloudName AzureCloud homeTenantId dbs frn zzq qq ljf id hgg d bh jc ckv isDefault true managedByTenants name Visual Studio Enterprise Subscription state Enabled tenantId dbs frn zzq qq ljf user name username gmail com type user The id value is your subscription ID Create a Resource GroupIn Azure all resources created are tied to a Resource Group A Resource Group is a logical container that holds related Azure resources such as virtual machines storage accounts and virtual networks To create a Resource Group run the below scriptexport location east us export resourceGroup DemoRG export tags connect to sql echo Creating resourceGroup in location az group create name resourceGroup location location tag tagEnvironment variables are dynamic values that can affect the behavior of programs and scripts They can be referenced by using their name in dollar signs In the Azure CLI exporting variables allows us to reference them using a dollar sign instead of giving the name directly in the command Exported variables are available to all processes launched from the current shell session but need to be re exported if the shell or terminal is changed In the above script we exported the environment variables location resourceGroup and tags which are used in creating the resource group Because these variables have been exported into the system we can able to reference them when needed You can choose a different Resource group name a different location and tag as well After running the previous script you should get the below outputCreating DemoRG in east us id subscriptions hgg d bh jc ckv resourceGroups DemoRG location eastus managedBy null name DemoRG properties provisioningState Succeeded tags type Microsoft Resources resourceGroups This shows that the Resource Group was successfully created You can still check directly in your Azure portal to be sure Create an App Service PlanIn Azure an App Service Plan is a logical container for hosting Azure App Service apps It defines the underlying virtual machine instance and resources that are required to host the apps You might confuse this for Azure App Service itself Azure App Service is a Platform as a Service PaaS offering in Microsoft Azure that enables developers to quickly build deploy and manage web apps mobile app backends and RESTful APIs It provides a fully managed platform for hosting and scaling web applications without the need to manage the underlying infrastructure An Azure App Service Plan on the other hand is a logical container for hosting one or more Azure App Service apps It provides the necessary infrastructure resources such as virtual machines memory and storage to run and scale the apps The resources allocated to an App Service Plan determine the capacity and performance of the apps hosted in that plan To create an App Service plan run the below command export appServicePlan demo app service echo Creating appServicePlan az appservice plan create name appServicePlan resource group resourceGroup location location From the above we exported an appServicePlan variable which the command will reference to create the App Service Plan You can check your Azure portal to see the Azure app service plan created Create a Web AppRecall that an App Service Plan is used to host one or more App Services while an App Service itself is used to deploy and manage web apps When you create a Web App from the Azure CLI it is automatically associated with an App Service This is because a Web App needs a platform to run on and an App Service provides that platform It is created within an App Service as a child resource An App Service Plan is needed in Azure to allocate and manage the computing resources required for hosting one or more App Services It defines the underlying infrastructure resources needed to run and scale your Web Apps such as CPU memory disk space and network bandwidth You must choose an App Service Plan when creating an App Service which allows you to scale up or down the resources allocated to your App Service based on demand An App Service Plan ensures that your Web Apps have the necessary resources to operate efficiently and can easily scale resources up or down to meet changing demands To create a Web App run the below command export webapp FavourWebApp echo Creating webapp az webapp create name webapp plan appServicePlan resource group resourceGroupAgain we exported a variable webapp which the command referenced in creating the Web App As you can see previous exported variable didn t need to be referenced again since it was done previously The web app is then created under the same Resource Group and location as the App Service Plan NB If you encounter an error message similar to the one below it indicates that another user has already created or deployed a web app with that name When you create a Web App it will have a subdomain of azurewebsites net If the name you have chosen is already being used you will need to select a different name to proceed For instance when I used the name DemoApp it returned an error because the name was already in use Creating DemoAppWebapp DemoApp already exists The command will use the existing app s settings Unable to retrieve details of the existing app DemoApp Please check that the app is a part of the current subscriptionAfter successfully deploying the web app you can check it on the Azure Portal It can be found under App Services You can also load the url on your browser to see it Create an SQL ServerAn SQL Server is a software program that provides a platform for creating managing and accessing databases using a structured query language SQL It is a necessary component for managing databases because it provides the infrastructure to store manage and secure data A database must be attached to a SQL Server in order to access and manage the data it contains Without a SQL Server a database cannot be accessed or managed Before we create the SQL database we need to create a SQL Server that the database will run on To do this run the below command export server favourdemo export login favour export password yourpassword echo Creating server az sql server create name server resource group resourceGroup location location admin user login admin password passwordIn the above configuration you can choose a different server name to be exported a login name and a password of your choice Similar to how a subdomain is created for a Web App creating an SQL Server on Azure results in a subdomain of database windows net If the chosen name for the SQL Server is already taken an error message will be displayed The rules for choosing a password areYour password must be at least characters in length Your password must be no more than characters in length Your password must contain characters from three of the following categories English uppercase letters English lowercase letters numbers and non alphanumeric characters etc Your password cannot contain all or part of the login name Part of a login name is defined as three or more consecutive alphanumeric characters NB If you do not follow the password rules you will get an error You can check your Azure portal to see the created SQL Server Configure Access to the SQL ServerAfter creating the SQL Server we need to configure a firewall for access to control access to the server This is important for security reasons as it allows only authorized users or applications to access the SQL Server Without proper firewall configuration the server may be vulnerable to unauthorized access and potential security breaches To do this run the below command export startIp export endIp echo Creating firewall rule with starting ip of startIp and ending ip of endIpaz sql server firewall rule create server server resource group resourceGroup name AllowYourIp start ip address startIp end ip address endIpFrom the above configuration we are exporting a start IP and an End IP which refer to the range of IP addresses that are allowed to connect to the server The start IP is the first IP address in the range of allowed addresses while the end IP is the last IP address in the range Any IP address outside this range will be blocked from accessing the SQL Server NB Because both startIP and endIP are set to “ it means we are opening the firewall to allow access from anywhere This is strictly for demo purposes It is unsafe for production environments so always ensure to restrict access to your server Create an Azure SQL DatabaseAn SQL database is a type of relational database management system RDBMS that stores data in a structured format using tables consisting of rows and columns It uses SQL Structured Query Language to manage the data and allows for easy retrieval insertion and modification of data When an App Service app is connected to a database it typically stores structured data that can be queried and manipulated using SQL or other database management tools Examples of this type of data include user information product catalogs and transaction logs To create an Azure SQL database in Azure run the below command export database demodatabase echo Creating database az sql db create server server resource group resourceGroup name database service objective SThe above configuration export the database variable name and creates the database using the variable on the SQL Server we previously created under the same Resource Group service objective S is a parameter used in the Azure CLI command to set the performance level of the Azure SQL Database when it is created or updated In this case S is the service objective which represents the Standard service tier of Azure SQL Database Get Connection String for the DatabaseA connection string for a database is a text string that contains the information required to establish a connection to a database server It typically includes the name and location of the database the name of the server hosting the database and authentication information such as a username and password The connection string is required by applications or programs to establish a connection to the database server To get the connection string for the just created database run the below command connstring az sql db show connection string name database server server client ado net http ado net output tsv client ado net This specifies the client driver to use for the connection string In this case we are using the NET client driver output tsv This specifies that the output of the command should be in TSV tab separated values format which is a type of text format that is easy to parse programmatically connstring This assigns the output of the command to a shell variable called connstring The syntax allows you to execute a command and capture its output The command az sql db show connection string is used to retrieve the connection string for the Azure SQL database that was just created The output of this command is a string that contains information such as the server name database name login credentials and other settings required to connect to the database as seen below Server tcp favourdemo database windows net Initial Catalog demodatabase Persist Security Info False User ID lt username gt Password lt password gt MultipleActiveResultSets False Encrypt true TrustServerCertificate False Connection Timeout By assigning the output of the command to a variable named connstring using the syntax connstring az sql db show connection string name database server server client ado net output tsv the connection string can be referenced later in the script Add your Credentials to ConnstringAfter getting the connection string using the command az sql db show connection string the resulting string will contain placeholders for the user ID and password indicated by lt username gt and lt password gt respectively We need to replace these placeholders with our actual login credentials to be able to connect to the database Therefore we need to add our credentials to the connection string to establish a successful connection to the Azure SQL Database To do this run the below connstring connstring lt username gt login connstring connstring lt password gt password Assign the Connection String to an App Setting in the Web AppApplication settings are configuration values that are stored within the App Service and can be accessed by the application code at runtime These settings can include things like database connection strings API keys and other configuration values specific to your application Assigning the connection string to an app setting in the web app makes it easy to manage and update the connection string without having to modify the code of the web app By storing the connection string as an app setting the web app can access it at runtime and establish a connection to the database without exposing sensitive information like usernames and passwords in the code This also makes it easier to switch between different databases or servers as the connection string can be updated in one central location the app settings rather than having to update it in multiple places in the code To do this run the below command az webapp config appsettings set name webapp resource group resourceGroup settings SQLSRV CONNSTR connstring Create a storage accountA storage account in Azure is a secure and scalable cloud based storage solution that allows users to store and access various types of data such as files blobs queues tables and disks among others Connecting an App Service app to a storage account allows the app to access and store data in the storage account which can be used to store unstructured data such as files images videos and other data that the app may require To create a storage account run the below command export storage favourdemostore echo Creating storage az storage account create name storage resource group resourceGroup location location sku Standard LRS sku Standard LRS is a parameter used in the Azure CLI command to set the pricing tier and replication scheme of the Azure Storage account being created In this case Standard LRS represents the Standard pricing tier and the Locally Redundant Storage LRS replication scheme NB The storage account name must be between and characters in length and use numbers and lower case letters only Retrieve the storage account connection stringThe connection string here is a string that contains all the necessary information to connect to a storage account This includes details like the storage account name access key and endpoint The connection string allows you to access and manage the data stored in the storage account To connect an app service app to a storage account in Azure we need to obtain the storage account connection string This connection string is crucial because it enables the app to access and manipulate the data stored in the storage account such as uploading and downloading files accessing and modifying blobs and more Without the connection string the app will not be able to communicate with the storage account and perform these actions To retrieve the connection string run the below command connstr az storage account show connection string name storage resource group resourceGroup query connectionString output tsv Assign the connection string to an App setting in the Web appNow we will set the connection string as a value for an App Setting in the configuration of a Web app deployed on Azure This allows the Web app to access the storage account as it can now retrieve the connection string from its configuration settings Assigning the connection string to an App Setting ensures that the connection string is securely stored and not exposed in the application code It also provides an easy way to update the connection string if needed as it can be modified in the Web app configuration without having to redeploy the application code To do this run the below command az webapp config appsettings set name webapp resource group resourceGroup settings STORAGE CONNSTR connstr After carrying out the above processes check the configuration settings under the Web App in App Services you should see the applications settings connection strings we have configured ConclusionThis article provided a comprehensive guide on how to connect an App Service app to both an SQL Database and a Storage Account SQL Databases are essential for storing structured data such as user information while Storage Accounts are used for storing unstructured data like media files or logs By following the steps outlined in this article you can easily establish a connection between your App Service app and these services allowing your app to access and manipulate data in a secure and efficient manner	2023-05-03 21:39:41
Apple	AppleInsider - Frontpage News	With iPhone divorce in full swing, Qualcomm bets future on other product segments	https://appleinsider.com/articles/23/05/03/with-iphone-divorce-in-full-swing-qualcomm-bets-future-on-other-product-segments?utm_medium=rss	With iPhone divorce in full swing Qualcomm bets future on other product segmentsQualcomm is counting down the days to when it loses Apple as a modem customer guiding weak for Q as orders slow Qualcomm may lose Apple s businessThe second quarter results for Qualcomm were within expected guidance ranges but forward looking statements show uncertainty for the company The global economy continues to have an adverse effect on premium smartphone sales which is one of many problems Qualcomm cites Read more	2023-05-03 21:20:49
海外TECH	Engadget	Scientists observe elusive missing step in photosynthesis’ final stage	https://www.engadget.com/scientists-observe-elusive-missing-step-in-photosynthesis-final-stage-214947146.html?src=rss	Scientists observe elusive missing step in photosynthesis final stageResearchers at the SLAC National Accelerator Laboratory and Lawrence Berkeley National Laboratory along with collaborators in Sweden Germany and the UK have shed new light on the final step of photosynthesis They observed in atomic detail how Photosystem II a protein complex found in plants undergoes a transformation that leads to the loss of an extra oxygen atom Scientists believe the discoveries will help provide a roadmap for optimizing clean energy sources “It s really going to change the way we think about Photosystem II said Uwe Bergmann scientist and professor at the University of Wisconsin Madison who co authored the paper Researchers took “extremely high resolution images of different stages of the process at room temperature giving them new insight into specifically how and where the oxygen is produced Baseball can provide a simple if somewhat forced metaphor to illustrate the process “The center cycles through four stable oxidation states known as S through S when exposed to sunlight SLAC explains “On a baseball field S would be the start of the game when a player on home base is ready to go to bat S S would be players on first second and third Based on this metaphor a batter making contact to advance the runners signifies the complex absorbing a sunlight photon “When the fourth ball is hit the player slides into home scoring a run or in the case of Photosystem II releasing one molecule of breathable oxygen It s that final stage S between third base and sliding home in our metaphor that they imaged for the first time where two oxygen atoms bond to release an oxygen molecule revealing additional steps previously unseen The video below illustrates the team s process and discoveries “Most of the process that produces breathable oxygen happens in this last step said Vittal Yachandra a scientist at Berkeley Lab and co author of the paper published inNature “But there are several things happening at different parts of Photosystem II and they all have to come together in the end for the reaction to succeed Just like how in baseball factors like the location of the ball and the position of the basemen and fielders affect the moves a player takes to get to home base the protein environment around the catalytic center influences how this reaction plays out The researchers expect an X ray upgrade later this year to shed more light on the process It will use a repetition rate of up to a million pulses per second up from the per second used in this experiment “With these upgrades we will be able to collect several days worth of data in just a few hours Bergmann said “We will also be able to use soft X rays to further understand the chemical changes happening in the system These new capabilities will continue to drive this research forward and shed new light on photosynthesis The team believes the results will help them “develop artificial photosynthetic systems that mimic photosynthesis to harvest natural sunlight to convert carbon dioxide into hydrogen and carbon based fuels Jan Kern another co author and scientist at Berkley Lab said “The more we learn about how nature does it the closer we get to using those same principles in human made processes including ideas for artificial photosynthesis as a clean and sustainable energy source This article originally appeared on Engadget at	2023-05-03 21:49:47
海外科学	NYT > Science	Eli Lilly Trial Finds Alzheimer’s Drug Can Slow Progress of Disease	https://www.nytimes.com/2023/05/03/health/alzheimers-drug-eli-lilly-trial.html	Eli Lilly Trial Finds Alzheimer s Drug Can Slow Progress of DiseaseDonanemab is not a cure and comes with significant side effects but patients had longer periods of independent living while on the drug	2023-05-03 21:57:12
金融	ニュース - 保険市場TIMES	ニッセイ・ウェルス生命保険、HDI格付けベンチマークで三つ星を獲得	https://www.hokende.com/news/blog/entry/2023/05/04/070000	ニッセイ・ウェルス生命保険、HDI格付けベンチマークで三つ星を獲得コールセンター対応品質で三つ星ニッセイ・ウェルス生命保険株式会社は、HDIJapanによる「年度HDI格付けベンチマーク」のクオリティ格付けで、コールセンター対応品質について最高評価となる三つ星を獲得したと年月日に発表した。	2023-05-04 07:00:00
ニュース	BBC News - Home	Haaland breaks Premier League goal record	https://www.bbc.co.uk/sport/football/65474843?at_medium=RSS&at_campaign=KARANGA	season	2023-05-03 21:14:45
ニュース	BBC News - Home	New mums missing out on mental health services, report finds	https://www.bbc.co.uk/news/health-65473737?at_medium=RSS&at_campaign=KARANGA	findsa	2023-05-03 21:40:48
ニュース	BBC News - Home	Sudan: Dozens on last UK evacuation flights to leave the country	https://www.bbc.co.uk/news/uk-65476769?at_medium=RSS&at_campaign=KARANGA	final	2023-05-03 21:15:26
ニュース	BBC News - Home	Manchester City 3-0 West Ham: Erling Haaland breaks Premier League goals record	https://www.bbc.co.uk/sport/football/64929885?at_medium=RSS&at_campaign=KARANGA	Manchester City West Ham Erling Haaland breaks Premier League goals recordErling Haaland scores a record breaking th Premier League goal of the season as Manchester City beat West Ham to return to the top of the table	2023-05-03 21:19:50
ニュース	BBC News - Home	Liverpool 1-0 Fulham: Mohamed Salah scores for eighth straight Anfield game	https://www.bbc.co.uk/sport/football/64923724?at_medium=RSS&at_campaign=KARANGA	Liverpool Fulham Mohamed Salah scores for eighth straight Anfield gameLiverpool s outside hopes of qualifying for next season s Champions League remain alive after Mohamed Salah continues his remarkable Anfield scoring form to help sink Fulham	2023-05-03 21:14:56
ニュース	BBC News - Home	Chelsea 2-1 Liverpool: Women's Super League title hopes boosted by Sam Kerr winner	https://www.bbc.co.uk/sport/football/65475104?at_medium=RSS&at_campaign=KARANGA	Chelsea Liverpool Women x s Super League title hopes boosted by Sam Kerr winnerChelsea s Women s Super League title hopes remain in their own hands after Sam Kerr s late goal gives them victory over Liverpool	2023-05-03 21:24:43