投稿時間:2022-05-07 05:19:57 RSSフィード2022-05-07 05:00 分まとめ(22件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
AWS	AWS Database Blog	Convert database schemas and application SQL using the AWS Schema Conversion Tool CLI	https://aws.amazon.com/blogs/database/convert-database-schemas-and-application-sql-using-the-aws-schema-conversion-tool-cli/	Convert database schemas and application SQL using the AWS Schema Conversion Tool CLIDatabase migration is a multi step process comprised of assess mobilize and modernize phases with different tools and technologies involved You can use tools such as AWS Schema Conversion Tool AWS SCT and AWS Database Migration Service AWS DMS to accelerate each of these phases In this post we demonstrate how to use the AWS SCT …	2022-05-06 19:58:22
海外TECH	MakeUseOf	4 Mobile Apps to Practice Mindful Eating	https://www.makeuseof.com/mobile-apps-practice-mindful-eating/	practice	2022-05-06 19:30:13
海外TECH	DEV Community	Create and connect to an Azure SQL DB	https://dev.to/azure/create-and-connect-to-an-azure-sql-db-9k0	Create and connect to an Azure SQL DBThere are many ways in which an Azure SQL database can be created and if you are new to the development all those different options can be quite intimidating Let me show you in just a few steps how easy it is instead This is what we are going to do Create a resource groupCreate an Azure SQL logical serverCreate an Azure SQL database Configure the firewallCreate a user Get the connection stringI ll be using the Azure Shell portal as it provides a full experience without the need to install anything on your machine The only thing you must have ready is an Azure subscription Open a browser and point to and let s get started Create a Resource GroupA resource group is a container of Azure resources It is needed as it simplifies quite a lot the management of those resources Let s create one in the East US region and name it dev demo az group create n dev demo l eastus Create an Azure SQL logical serverAn Azure SQL logical server is needed to make it easier to manage many databases A logical server administrator can automatically access any database in the server Let s create a server named dev demo sql srv and create an administrator The administrator user should NEVER be used to allow applications to connect to any database hosted in that server It is for administrative tasks only az sql server create g dev demo n dev demo sql srv admin user devdemoadmin admin password SomeVery STRONG Passwrd Create an Azure SQL databaseNow that you have a server you can create databases in it The database will be named db and it will be using a serverless I know it s fun We had to create a server before model so that you ll pay on for when you use it auto pause is set by default after hour of no activity az sql db create g dev demo n db s dev demo sql srv service objective GP S Gen Configure the firewallIf you plan to use the created database with some other Azure services like for example Azure Functions or Web Apps or Containers and you don t have extremely high security policies you can allow Azure services to connect to your database by creating this firewall rule az sql server firewall rule create g dev demo s dev demo sql srv n AllAzureServices start ip address end ip address Now you need to allow your development machine to connect to Azure SQL Since you re using the cloud shell this is really not needed for now but I m pretty sure at some point you ll want to use Azure Data Studio or SQL Server Management Studio to connect and manage the database from your machine and so you need to make sure the firewall will allow such connection Open a browser and go to and get your IP address and then create a firewall rule using the reported IP for start and end address az sql server firewall rule create g dev demo s dev demo sql srv n MyIP start ip address end ip address Create a database userYou learned before that the administrative account should never be used to allow applications we create or work with to connect to the database so we need to create a dedicated user It s easy You need to connect to Azure SQL database using the sqlcmd tool as you notice you ll be using the administrator login here sqlcmd S dev demo sql srv database windows net d db U devdemoadmin P SomeVery STRONG Passwrd once you are logged in into the database you ll see a gt prompt you can create a user create user app user with password pplication Passwrd goOnce the user has been created you need to give it enough permission to work with the data in the database If it just needs to read and write from tables you can assign it the db reader and or db writer roles If it also needs to create tables or objects you may want to add it to the db owner role alter role db owner add member app user goYou can exit from the sqlcmd prompt just by executing the quit command Please note that users in the db owner group are basically local administrator so they can do pretty much everything on the database Security is a complex but extremely important topic make sure you check the basics out here An overview of Azure SQL Database and SQL Managed Instance security capabilities Get the connection stringTo get the connection string that you need to use in your application to connect to Azure SQL you can just use the following AZ command where you can also specify for which language or library you want to connection string az sql db show connection string s ddev demo sql srv c ado netThe command will print out the connection string You just have to replace the values in the angular brackets for example lt databasename gt with your values Make sure to use the application user you create in the step above and you ll be good to go Want to learn more If you want to learn what are the other ways using the Portal Powershell or AZ CLI here you can find a detailed article Quickstart Create an Azure SQL Database single databaseAnd if you are wondering why you should be looking at Azure SQL this post is for you reasons to use Azure SQL in your next projectPhoto by Pixabay	2022-05-06 19:56:45
海外TECH	DEV Community	What technologies are you currently learning ?	https://dev.to/hacker4world/what-technologies-are-you-currently-learning--5a7a	What technologies are you currently learning There is countless tools frameworks and languages available out there share with me what are you currently learning or what you wanna learn in the future i d love to know what the community has to learn	2022-05-06 19:53:52
海外TECH	DEV Community	Developer shortage? No, just bad interviews.	https://dev.to/jssantana/developer-shortage-no-just-bad-interviews-1cpa	Developer shortage No just bad interviews Probably many of you are beginners that is trying to have your first job or change carreer or even you are a mid level or senior Probably you got some interviews and also probably you were rejected because you coudn t pass on the live code interview phase You know how much good you on what you do and you know that if you were hired you could bring great results for that company but you don t get the job because of a failed method and the company directors keep saying that the market have a developers shortage and can t hire good devs but the truth is They are hiring wrong Why Because when they come with whiteboards and memory based tests they are just testing if you can remeber some syntax or how much you have practicized some specific algo but they are not testing your real world problem solving capability or if you can build something valuable The scenario behind it is even worst the companies that are applying these test are startups and many not FAANG companies and is almost certain that the seniors that is doing your interview didn t even faced this kind of test when they were hired they just keep repeating this without even make a reflection on it is aways the same thing everybody is doing so is right let s replicate EXPECTATION Based on your experience Questions Our product need a page that user can see the products from our database how we can do that We trying to create a simple online store what steps the app sould have to allow the user buy some product The user from our app would like to see his orders history what we need to implement this feature We have this any feature how do you think we could improve that Can you explain how this any feature works REALITY Use only your memory you have minutes Questions Invert a binary tree Do this array loop and transform it into this object What this method you never used before do Well I have a JavaScript solution for ANY test interviews like this one above just copy amp paste Check this out const getNervous true Almost everybody get nervousconst minutesTheyGiveMe const minutesINeed let interviewerEgo Yeah probably they come with morelet candidateStatus confident const whatIAm developer full stack experienced good team mate fast learner anything you really are const whatCompanyWant a machine documentation head guy experience on interviews experience on specific algo let myMind previous experience I can learn let result we have many scenarios to call this functionfunction interviewerEgoBooster candidateStatus if candidateStatus struggling interviewerEgo interviewerEgo return interviewerEgo function techInterview let neverUsedThisShtBefore true if getNervous myMind null candidateStatus struggling interviewerEgoBooster candidateStatus if neverUsedThisShtBefore amp amp minutesTheyGiveMe lt minutesIneed amp amp myMind null result fail interviewerEgoBooster candidateStatus He will not be replaced by you if result fail let meAfterThis whatIAm reduce function whatImNot whatIhave if whatCompanyWant includes whatIhave whatImNot impostorSyndrom true uncapable true selfSteem horrible expLevel not a dev return whatImNot focuse on REDUCE function bc this is what they are doing reducing you whatIAm push meAfterThis return result console log techInterview If tech interviews were honest	2022-05-06 19:05:47
海外TECH	DEV Community	Cryptography for beginners	https://dev.to/vaultree/cryptography-for-beginners-3joh	Cryptography for beginnersFor a long time human beings have been concerned with protecting information ensuring that other people do not see the content of the message to be transmitted Various methods have been created over time to achieve this goal and ensure the confidentiality of information in general Encryption is the study and practice of principles and techniques for secure communication in the presence of others That is in practice any technique that ensures that a third party does not have access to your information or cannot read or understand the true meaning of the message PrinciplesUntil recently cryptography was synonymous with encryption which is the process of converting plain text to ineligible text or cipher Today it has more goals and principles Confidentiality only the authorized recipient of the message is able to extract the content and understand the message In a simple analogy it s like a safe Only those who have the key have access to the contents inside the safe Integrity The recipient can verify that the message has been changed during its transmission This ensures that someone malicious does not send some correct but old message that is no longer valid The recipient will be able to open the message and verify its content to see if it is no longer valid Authenticity the recipient is able to verify that the message was actually sent by the person claiming to be sent It s like signing a contract or a check Irreversibility the sender of the message cannot deny the authorship of the message sent That is once the message is published or sent the sender cannot retract or say that he did not send it since only he can have the knowledge or the key to generate the message It is good to highlight that not all systems or algorithms cover all these principles at the same time and that in most applications it is necessary to apply one more algorithm together to meet all requirements Encryption TechniquesThere are several encryption techniques and hence algorithms that are used today but the main ones are secret key cryptography public key cryptography and hashing We ll talk about each of them below Secret Key EncryptionAlso known as symmetric encryption This type of encryption uses only one key to both encrypt and decrypt a message hence the symmetric name Thus both parties must have a copy of the key in order to exchange the message This mode is used for the confidentiality principle This type can have algorithm modes Block The message is encrypted in blocks of specific sizes Examples DES AES etc In stream the message is encrypted by taking the information byte by byte Examples RC Salsa etc Because the same key is used at both ends of the process it must be securely shared between the parties This can cause problems if not done carefully Public key encryptionIn public key cryptography also known as asymmetric cryptography two different keys are used in the process one for encryption and one for decryption The key used for encryption is also known as the public key and can normally be known by anyone The key used to decrypt is known as a private key and is kept secret by only one party This mode is used for confidentiality and authenticity principles For the case of authenticating or signing a message the order is reversed The private key is used to sign the message while the public key is used to verify it This mode is also used for secure symmetric key exchange A good example of this is SSL used in HTTPS which uses symmetric and asymmetric cryptography together to encrypt and authenticate a website HashingThis technique does not involve any keys It sets a fixed size and the value changes according to the message Any small change in the message whatever a bit causes the final value to change drastically This mode is used to verify the integrity of the sent message as it works as a fingerprint of the message to be sent The hash is a one way function that is it is not possible to recover the original message from only the final value Examples of algorithms MD SHA Whirpool etc Why methods Why use methods Why not just use one that covers all the basics The answer is that each technique is optimized for a specific application In realapplications to ensure all principles a combination of the techniques is used For example you can use symmetric mode to encrypt the message confidentiality and send together the hash integrity and signature authenticity with the asymmetric mode ApplicationsWith the increasing use of the internet and cloud systems encryption has been increasingly used to secure the principles shown above Digital signature a way of sending documents and assuring the recipient that this document is authentic Normally you acquire a private key from an authority and with that key you can sign documents At the other end the recipient has a public key of the same authority and is able to verify the validity of the signature and consequently the authenticity of the document This often eliminates the use of physical signatures and avoids unnecessary paper printing Email encryption sending emails with sensitive data can be dangerous and easilyintercepted by third parties potentially causing business damage There are ways to encrypt the data sent for example using OpenPGP Encryption of sensitive data Saving business sensitive data such as passwords or financials must be done carefully There are some practices on how to save this safely like here which uses various techniques shown in this article HTTPS SSL Right now you are using encryption to read this article A combination ofhashing encryption and signing is used in the HTTPS protocol which is present on most websites today if not be suspicious This ensures that the website you are accessing really is from the one you expect and that the information transmitted is secure such aspassword personal data etc Blockchain This technology has been quite in vogue lately and makes heavy use of cryptography principles to store the data and also verify its authenticity among other uses ConclusionEncryption has been studied and used for a long time by human beings and with each passing day with the greater connectivity of people and data greater security and reliability of your data is required which are both stored and transported by the system This article was a brief introduction to the terms used and the main applications in the world In the next article we will talk about hash functions and their applications	2022-05-06 19:04:06
Apple	AppleInsider - Frontpage News	Apple TV+ shares a behind-the-scenes look at 'The Essex Serpent'	https://appleinsider.com/articles/22/05/06/apple-tv-shares-a-behind-the-scenes-look-at-the-essex-serpent?utm_medium=rss	Apple TV shares a behind the scenes look at x The Essex Serpent x Apple TV drama The Essex Serpent gets a behind the scenes trailer showing actors explaining their character s motivations in searching for the mythical creature The Essex Serpent premieres on May on Apple TV The Essex Serpent is a drama series based on the novel by Sarah Perry The behind the scenes trailer explains the show s conflict and how it attempts to subvert stereotypes set in other period pieces Read more	2022-05-06 19:43:47
Apple	AppleInsider - Frontpage News	How to install and manage apps for Messages on iOS 15 and iPadOS 15	https://appleinsider.com/articles/21/11/10/how-to-install-and-manage-apps-for-messages-on-ios-15-and-ipados-15?utm_medium=rss	How to install and manage apps for Messages on iOS and iPadOS Messages apps on iOS and iPadOS allow you to collaborate with others share interesting finds play games and decorate your chat with stickers Here s what you need to know to get started using them Apple introduced Messages specific apps in with the advent of iOS Since then the Messages App Store has seen the addition of thousands of apps ranging from games stickers collaboration features payment apps and more Getting started with Messages specific apps is easy and AppleInsider is here to teach you how to add remove and manage your Messages apps Read more	2022-05-06 19:13:00
海外TECH	Engadget	Amazon fires senior managers from unionized Staten Island warehouse	https://www.engadget.com/amazon-fires-senior-managers-from-unionized-staten-island-warehouse-193119240.html?src=rss	Amazon fires senior managers from unionized Staten Island warehouseAmazon fired a number of senior managers from its JFK warehouse in Staten Island on Thursday only a month after workers voted to unionize The New York Times reported that the company axed more than half a dozen senior level workers on Thursday many of who were involved in union organizing A number of anonymous employees told the NYT that they believed the firings were retaliatory JFK is the first and currently the only unionized Amazon warehouse in the US In a statement to Engadget Amazon said the workers were fired as a result of “management changes “Part of our culture at Amazon is to continually improve and we believe it s important to take time to review whether or not we re doing the best we could be for our team Over the last several weeks we ve spent time evaluating aspects of the operations and leadership at JFK and as a result have made some management changes Other Amazon workers have recently gotten the pink slip allegedly due to their union involvement Just a couple of weeks ago four recently terminated Amazon employees filed charges with the NLRB alleging that they were being punished for supporting a union Last month the NLRB ordered Amazon to reinstate Gerald Bryson a worker at the JFK facility who was fired due to what Amazon alleged was his violation of a company language policy But the NLRB s judge was not convinced by this argument and accused Amazon of performing a “skewed investigation of Bryson and retaliating against him for his union work Just yesterday Amazon Labor Union president Chris Smalls testified before the Senate Budget Committee and met with President Joe Biden The Biden administration has expressed reserved support for unionization efforts by Amazon Starbucks and other workers In his testimony before the Senate Smalls argued that the federal government should avoid awarding Amazon contracts due to its labor practices “We cannot allow Amazon or any other employer to receive taxpayer money if they engage in illegal union busting behavior and deny workers rights said Smalls	2022-05-06 19:31:19
海外TECH	WIRED	How a Telemedicine Abortion Provider Is Bracing for Post-Roe Life	https://www.wired.com/story/telemedicine-abortion-post-roe-future	How a Telemedicine Abortion Provider Is Bracing for Post Roe LifeThe CEO of digital abortion clinic Hey Jane discusses the grim future of reproductive rights in the US and the clinic s plans to keep providing access	2022-05-06 19:14:39
ニュース	BBC News - Home	McColl's: Billionaire Issa brothers near deal to rescue chain	https://www.bbc.co.uk/news/uk-61351412?at_medium=RSS&at_campaign=KARANGA	chain	2022-05-06 19:15:54
ニュース	BBC News - Home	County Championship: Watch Ben Stokes hit 34 off an over in epic Durham innings	https://www.bbc.co.uk/sport/av/cricket/61358196?at_medium=RSS&at_campaign=KARANGA	County Championship Watch Ben Stokes hit off an over in epic Durham inningsWatch as Ben Stokes hits off a single over as he reached his century in balls during his innings for Durham at Worcester	2022-05-06 19:32:58
ニュース	BBC News - Home	Election results 2022: When to expect them and what to look out for	https://www.bbc.co.uk/news/uk-politics-61306099?at_medium=RSS&at_campaign=KARANGA	election	2022-05-06 19:46:43
ビジネス	ダイヤモンド・オンライン - 新着記事	事業承継「バブル時代」に失敗しない3つの鉄則と、頼れる専門家選びの極意【動画】 - 事業承継の新常識！後悔しないための完全マニュアル	https://diamond.jp/articles/-/302537	鉄則	2022-05-07 04:50:00
ビジネス	ダイヤモンド・オンライン - 新着記事	常識破りのダイバーズウォッチ、時計の天敵・水を取り込み水深計機能を実現 - 男のオフビジネス	https://diamond.jp/articles/-/302504	防水	2022-05-07 04:50:00
ビジネス	ダイヤモンド・オンライン - 新着記事	「あおられ運転」なる新語の危うさ、あおり運転を正当化する人の本音 - 井の中の宴 武藤弘樹	https://diamond.jp/articles/-/302597	運転	2022-05-07 04:45:00
ビジネス	ダイヤモンド・オンライン - 新着記事	東北の格式が高い神社「一宮」3選、春の東北へ参拝の旅に出よう！ - 地球の歩き方ニュース＆レポート	https://diamond.jp/articles/-/302467	地球の歩き方	2022-05-07 04:40:00
ビジネス	ダイヤモンド・オンライン - 新着記事	コロナ禍でも自殺者が減少、「ある行動」のおかげ？日本医科大が調査 - ヘルスデーニュース	https://diamond.jp/articles/-/302528	コロナ禍でも自殺者が減少、「ある行動」のおかげ日本医科大が調査ヘルスデーニュース国内の自殺者数は、新型コロナウイルス感染症の影響という不確定要素はあるものの近年、減少傾向にある。	2022-05-07 04:35:00
ビジネス	ダイヤモンド・オンライン - 新着記事	上にゴマすり部下に厳しい「腰巾着上司」の哀れな末路とは - 「超」戦略的に聴く技術	https://diamond.jp/articles/-/302144	食べるラー油	2022-05-07 04:25:00
ビジネス	ダイヤモンド・オンライン - 新着記事	腸にやさしくストレス軽減！ やみつきになる長寿サラダとは？ - 認知症専門医が毎日食べている長寿サラダ	https://diamond.jp/articles/-/301840	腸にやさしくストレス軽減やみつきになる長寿サラダとは認知症専門医が毎日食べている長寿サラダ世界最先端の革命的認知症治療に取り組む、認知症研究年超の医学博士。	2022-05-07 04:15:00
ビジネス	ダイヤモンド・オンライン - 新着記事	「ベトナムってどんな国？」2分で学ぶ国際社会 - 読むだけで世界地図が頭に入る本	https://diamond.jp/articles/-/302024		2022-05-07 04:05:00
ビジネス	東洋経済オンライン	レンタカーより楽しい､｢沖縄路線バス｣の世界 路線図を見ていると｢ちむどんどん｣してくる？ | ローカル線･公共交通 | 東洋経済オンライン	https://toyokeizai.net/articles/-/584638?utm_source=rss&utm_medium=http&utm_campaign=link_back	交通機関	2022-05-07 04:30:00