投稿時間:2021-04-10 00:42:35 RSSフィード2021-04-10 00:00 分まとめ(52件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
python	Pythonタグが付けられた新着投稿 - Qiita	Think Python 2e 17	https://qiita.com/JoeB/items/37530f72d5297deee6df	ThinkPythone問題この章のコードをからダウンロードします。	2021-04-09 23:54:42
python	Pythonタグが付けられた新着投稿 - Qiita	Djangoチュートリアル⑤（汎用ビュー）	https://qiita.com/honda28/items/7150a5df0213dc6a3927	はじめてのDjangoアプリ作成、そのでもサーバー側のデータを更新するフォームを作成する場合はpostを指定するように書かれている。	2021-04-09 23:21:55
python	Pythonタグが付けられた新着投稿 - Qiita	PyTorch CNNモデル再現性問題	https://qiita.com/makaishi2/items/1ff89650e3181f95d789	次のように修正する必要があるとの記載が見つかります。	2021-04-09 23:10:00
js	JavaScriptタグが付けられた新着投稿 - Qiita	mobile-drag-dropを使った、HTML5のDrag & Drop API スマホ向けポリフィル（HTML/CSS+JavaScriptのみ）	https://qiita.com/shirokurotaitsu/items/f90a346e7235ccd2c9ea	mobiledragdropを使った、HTMLのDragampDropAPIスマホ向けポリフィルHTMLCSSJavaScriptのみやりたいこと年月現在でHTMLのDragampDropAPIがiOSなどで対応していないので、DragampDropAPIをベースにスマホでもドラッグドロップをできるようにしたい。	2021-04-09 23:57:48
js	JavaScriptタグが付けられた新着投稿 - Qiita	独学でJavascriptを学んだ素人がもう一度1から学びなおす Part1	https://qiita.com/pong109/items/1f1e565ff67f8386ed16	環境OSブラウザWindowsGoogleChrome使用ツールVisualStudioCodeインストールした拡張機能は↓JapaneseLanguagePackforVisualStudioCode→日本語化、普通に読める日本語なので有用LiveSassCompiler→講座で入れろと言われた。	2021-04-09 23:25:46
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	縦もちのデータを横にしたい	https://teratail.com/questions/332492?rss=all	datevalue	2021-04-09 23:51:08
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	複数自動生成されたボタン背景色を一括で変更する(デフォルト色に戻す)仕組みを作りたい。	https://teratail.com/questions/332491?rss=all	前提・実現したいことPythonnbsp実行ボタンを押す事で、複数自動生成された他のボタン背景色を一括で変更するデフォルト色に戻す仕組みを作りたい。	2021-04-09 23:46:56
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	SpringFrameworkを使ってローカル開発後、世に公開する方法	https://teratail.com/questions/332490?rss=all	SpringFrameworkを使ってローカル開発後、世に公開する方法質問内容ヵ月間JavaとSpringFrameworkについておおよそのことを独学で勉強しました。	2021-04-09 23:43:01
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	サーバー移転でwwwのURLだけ「無効なURLです。」となる	https://teratail.com/questions/332489?rss=all	SSLを追加してサイトの引っ越しが完了しましたがhttpsabccomではアクセスできるのに、httpswwwabccomにアクセスすると「無効なURLです。	2021-04-09 23:18:34
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	排他制御でどちらが先か決まる条件	https://teratail.com/questions/332488?rss=all		2021-04-09 23:16:21
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	unity　コードレスIAPのAndroidでの実機課金テストのやり方が分からない	https://teratail.com/questions/332487?rss=all	unityコードレスIAPのAndroidでの実機課金テストのやり方が分からないUnityで課金を実装するためにCodelessIAPを使用することにしました。	2021-04-09 23:04:17
Linux	Ubuntuタグが付けられた新着投稿 - Qiita	ROS1 noeticのセットアップでcatkinがインストールできない	https://qiita.com/zenrshon/items/7581fd8fb19d43229bad	ROSnoeticのセットアップでcatkinがインストールできないsudoaptinstallcatkinした結果パッケージリストを読み込んでいます完了依存関係ツリーを作成しています状態情報を読み取っています完了インストールすることができないパッケージがありました。	2021-04-09 23:36:53
Azure	Azureタグが付けられた新着投稿 - Qiita	AzurePowershell で AccessToken を取得する方法	https://qiita.com/abfly/items/f1d2ab641b9b04b5ee52	調べてみたら、AzAccountsの動作変更により、従来のGetAzContextからアクセストークンを取得する方法が使えなくなった模様。	2021-04-09 23:05:50
技術ブログ	Developers.IO	ファイル直下でexportされている関数にjest.spyOnを使いたい	https://dev.classmethod.jp/articles/jest-spyon-with-export-function/	jestspyon	2021-04-09 14:11:21
海外TECH	Ars Technica	Sex with Neanderthals was common for early Eurasian Homo sapiens, DNA says	https://arstechnica.com/?p=1755625	parents	2021-04-09 14:40:21
海外TECH	Ars Technica	US adds Chinese supercomputing companies to export blacklist	https://arstechnica.com/?p=1755695	china	2021-04-09 14:11:23
海外TECH	DEV Community	Postgres Triggers	https://dev.to/siddhantk232/postgres-triggers-5h0b	Postgres TriggersToday in this blog I want to talk about Postgres triggers I will also go through an example use case to learn how to use it The ScenarioI have an e commerce app to sell books and I am implementing the cart functionality in the database So there is a carts table that stores unique cart entries per user and a books table For cart items we have another table carts books The carts and carts books are using a many to many relation So A cart can have many books and a book can be used in many carts Whenever a row is inserted or updated in the carts books table I want to calculate the total price of the cart used I also want to take the multiplier column of the carts books table into account This multiplier column is the quantity of a single book That means I am allowing a customer to buy many copies of a book Let s use Postgres triggers to solve this problem Before that below is the list of columns of every table discussed so far The schema Table public carts Column Type Collation Nullable Default created at timestamp with time zone not null now updated at timestamp with time zone not null now archived at timestamp with time zone amount numeric not null status text not null ENQUEUED text user id text not null id uuid not null gen random uuid Table public books Column Type Collation Nullable Default created at timestamp with time zone not null now updated at timestamp with time zone not null now archived at timestamp with time zone name text not null price numeric not null user id bigint not null id bigint not null nextval books id seq regclass description text not null Table public carts books Column Type Collation Nullable Default book id bigint not null multiplier integer not null user id text not null cart id uuid not null The SolutionWe want to run a procedure also known as a function after a row in the tablecarts books is INSERTED or UPDATED For this let s create two Postgres triggers one for UPDATE and the other for INSERT CREATE TRIGGER update cart price AFTER UPDATE ON public carts books FOR EACH ROW EXECUTE PROCEDURE public update cart price COMMENT ON TRIGGER update cart price ON public carts books IS update the price of the related cart based on the updated cart item s in relation carts books CREATE TRIGGER calculate cart price AFTER INSERT ON public carts books FOR EACH ROW EXECUTE PROCEDURE public update cart price COMMENT ON TRIGGER calculate cart price ON public carts books IS update the price of the related cart based on the updated cart item s in relation carts books Above is the code that creates two Postgres triggers Let s understand the syntax and what each clause used above means To create a Postgres trigger we want to tell Postgres about the following things Name of the trigger In this case I have used names update cart price and calculate cart price When you want the code to run I want to know the values that are inserted for this I have to use the AFTER INSERT and the AFTER UPDATE clause How do you want to run this trigger There are two options one is to run this trigger for each affected row Another option is to run the trigger per statement What do you want to run I have these triggers to run the procedure called update cart price You must create the function before using it in a function A function must return TRIGGER in order to be used in a trigger The function that I want to run on these triggers is defined as sqlCREATE OR REPLACE FUNCTION public update cart price RETURNS TRIGGER AS DECLARE item record new amount numeric BEGIN FOR item IN SELECT price multiplier FROM carts books JOIN books ON book id books id WHERE cart id NEW cart id LOOP new amount new amount item price item multiplier END LOOP UPDATE carts SET amount new amount WHERE id NEW cart id RETURN new END LANGUAGE plpgsql This function selects the price and multiplier of all the books used inside the cart It then updates the cart s amount column to reflect the updated amount The data of the changed row is made available through the new record Also the function cannot use plain SQL language you must use a procedurallanguage The ConclusionPostgres triggers make it easy to execute small business logic on data changes Also we do not need to care about the network latency that we would face if we execute the same logic in a different service a nodejs app for example Good ReadsIn addition to this post I also recommend reading these to know more about Postgrestriggers Official DocsData visibility in trigger functions	2021-04-09 14:37:43
海外TECH	DEV Community	TUTORIAL: How to use GitHub in Codesphere	https://dev.to/codesphere/tutorial-how-to-use-github-in-codesphere-12b5	TUTORIAL How to use GitHub in CodesphereCodesphere is a simple and powerful development platform that combines a collaborative IDE GitOps and cloud services to streamline the development of scalable web applications Nowadays it s hard to imagine development without using git That s why in today s article we ll show you how to use Github in Codesphere Cloning from GithubOnce you are signed in navigate to the My Apps menu and press the New App button You can then click on Clone Repository where you will be prompted to enter the Repository URL for the Repo you want to clone For GitHub the URL for a repository can be found by clicking on the green Code button and copying the HTTPS URL Simply copy that URL back into Codesphere and press Continue After choosing a name and billing plan Codesphere will clone your GitHub Repository allowing you to use Codesphere to develop and deploy your web application Thanks for reading	2021-04-09 14:21:31
海外TECH	DEV Community	5 React Libraries You Should Be Using in 2021	https://dev.to/reedbarger/5-react-libraries-you-should-be-using-in-2021-4n4f	React Libraries You Should Be Using in This post originally appeared on ReedBarger com Let s take a look at five React libraries that serve as a great addition to any React project you re looking to build in and beyond The libraries I have chosen were selected because not only do they help us build functional and impressive looking applications but they also allow us to do so faster easier and with less code In this guide I m going to show you how to get up and running with each of these libraries from scratch and integrate them into your projects today Looking to build amazing real world React projects with the best libraries Check out the React Bootcamp React QueryTo fetch data with React is generally a process that involves a lot of code You often need to use the useEffect hook in combination with useState to manage the fetched data This requires a lot of boilerplate that we have to write in every component in which we want to fetch data A great library to use to cut down on the code we write for making network requests with React is React Query All of this React code that we had to write before can be replaced with the hook useQuery from which we get back all of the data that we need without having to declare a state variable However making data fetching easier only covers a small slice of what React Query does What makes it a very powerful library is that it caches saves requests that we make so in many cases if we ve requested data before we don t have to make another request we can just read it from the cache This is immensely helpful to cut down repetition in our code in the load we put on our API and in managing our overall app state If you pick any library to start adding to your projects today out of this list make it React Query Ant DesignWhen it comes to making impressive looking React apps there are many helpful component libraries that allow us to quickly style our applications with the help of pre made components There are lots of component libraries out there but few that are as sophisticated and well designed as one called Ant Design If you can think of a type of component to include within your React app interface and design Ant Design almost certainly has it To use a component library like Ant Design speeds up our development time by reducing the amount of often unreliable styles that we have to write ourselves Additionally these pre made components provide functionality that is often redundant to create ourselves such as a common modal or tooltip In most cases we should opt for the reliable proven solution rather than attempting to reinvent the wheel If you re thinking of building an application today and are looking for a solid component library go with Ant Design It has virtually every feature that you would need out of a component library plus great customizability that serves any app feature you might consider implementing ZustandWhen it comes to managing state React developers are often given two familiar choices Redux or React Context Redux has been the go to third party library for React developers to manage state but with the arrival of React Context in React version we have an easier way to manage state by passing it around our component tree If you re looking for a library with all of the functionality and power of Redux with the simplicity of React Context look at the library Zustand It s incredibly easy to get started with as you can see in the example below It involves using the create function to make a dedicated state object that can include any state values and functions to update that state as we need It can all be created within a few lines of code Plus there s no need to use any context provider to pass your state to your app components All you need to do is create a slice of state call that created state as a hook and receive whatever state variables and functions you ve declared on the object within your React components Give Zustand a shot the next time you are looking for a more complex state solution like Redux for your application you ll love it React Hook FormWhen it comes to building forms in React all developers know how tedious it can be to perform basic tasks like validating inputs plus managing all the form and error state Perhaps the most user friendly form library available today is React Hook Form All the functionality that you need in a form library is provided in one simple hook called useForm and enables you to create as sophisticated forms as you like It takes control of managing our form state internally gives us easy helpers to display errors for the appropriate input and applies validation rules without any external libraries such as Yup along with handling submission of our form When it comes to making building functional forms you want a library that s easy to use and does not add too much code to our components According to these two criteria React Hook Form is arguably the best React form library out there React ResponsiveThere s no question every React application should be created for users on different devices and needs to be responsive Meaning it needs to adjust the styles and appearance according to the screen size or device that your users are on While media queries have typically been used in CSS stylesheets to hide and display different elements the best React based library to manage visibility or styles of React components is React Responsive It gives us a convenient useMediaQuery hook that enables us to pass in very precise conditions to determine whether users on a certain type of screen are using a certain device they ll be able to adjust our user interface accordingly For making any React applications responsive without the use of CSS be sure to check out the React Responsive library Enjoy this post Join The React BootcampThe React Bootcamp takes everything you should know about learning React and bundles it into one comprehensive package including videos cheatsheets plus special bonuses Gain the insider information hundreds of developers have already used to master React find their dream jobs and take control of their future Click here to be notified when it opens	2021-04-09 14:21:30
Apple	AppleInsider - Frontpage News	Steve Jobs shot Desktop Pictures for OS X Leopard	https://appleinsider.com/articles/21/04/09/steve-jobs-shot-desktop-pictures-for-os-x-leopard	Steve Jobs shot Desktop Pictures for OS X LeopardAn ex Apple software designer claims that Steve Jobs personally shot several of the images presented as desktop pictures for s Mac OS X Leopard Grass Blades reportedly photographed by Steve Jobs to be a desktop picture in OS X Leopard source TechReflect A new blog post claims that OS X Leopard wallpaper or desktop pictures including Grass Blades Rock Garden and Golden Palace were photographed by Steve Jobs The blogger going only by the name Cricket says he spent nearly years at Apple Read more	2021-04-09 14:51:14
Apple	AppleInsider - Frontpage News	Apple growth will continue in the double digits in Q1 2021, analyst says	https://appleinsider.com/articles/21/04/09/apple-growth-will-continue-in-the-double-digits-in-q1-2021-analyst-says	Apple growth will continue in the double digits in Q analyst saysApple saw remarkable revenue growth during the holiday quarter and throughout the pandemic and according to one analyst that growth will continue through the second quarter of Credit Andrew O Hara AppleInsiderAnalyst Horace Dediu predicts that Apple will see year over year top line growth when it reports its second quarterly earnings later in April Dediu also forecasts earnings per share growth of year over year during the goldilocks quarter Read more	2021-04-09 14:15:41
Apple	AppleInsider - Frontpage News	Verizon issues recall on Ellipsis Jetpack mobile hotspot devices	https://appleinsider.com/articles/21/04/09/verizon-issues-recall-on-ellipsis-jetpack-mobile-hotspot-devices	Verizon issues recall on Ellipsis Jetpack mobile hotspot devicesVerizon s Ellipsis Jetpack mobile hotspots are capable of overheating and could cause burns if handled and pose a fire risk A Model MHSL Ellipsis Jetpack mobile hotspotVerizon and the U S Consumer Product Safety Commission CPSC have discovered that the lithium ion battery in specific models of the Ellipsis Jetpack mobile hotspot can overheat posing as a fire and burn risk Read more	2021-04-09 14:13:31
海外TECH	Engadget	Study suggests Facebook shows users different job ads based on their gender	https://www.engadget.com/facebook-job-ads-men-women-study-144333009.html	netflix	2021-04-09 14:43:33
Cisco	Cisco Blog	Bring Your Broadband Network Gateways into the Cloud	https://blogs.cisco.com/sp/bring-your-broadband-network-gateways-into-the-cloud	Bring Your Broadband Network Gateways into the CloudIt is no longer possible to optimize the user plane and control plane when hosted on the same device It is time to entirely rethink the BNG architecture	2021-04-09 14:49:17
海外TECH	CodeProject Latest Articles	First Cloud Native Steps: Automated Build, Test, and Deploy	https://www.codeproject.com/Articles/5298225/First-Cloud-Native-Steps-Automated-Build-Test-and	First Cloud Native Steps Automated Build Test and DeployThis article will serve as a hands on introduction to Cloud Native development for Node developers Unlike most other introductions we re going to show how to do things in a realistic way using modern tools	2021-04-09 14:20:00
海外TECH	CodeProject Latest Articles	Hierarchy of Categories and Classifying Wikipedia Articles using XML Dump	https://www.codeproject.com/Articles/1100006/Hierarchy-of-Categories-and-Classifying-Wikipedia	articles	2021-04-09 14:10:00
海外科学	NYT > Science	A Tiny Particle’s Wobble Could Upend the Known Laws of Physics	https://www.nytimes.com/2021/04/07/science/particle-physics-muon-fermilab-brookhaven.html	A Tiny Particle s Wobble Could Upend the Known Laws of PhysicsExperiments with particles known as muons suggest that there are forms of matter and energy vital to the nature and evolution of the cosmos that are not yet known to science	2021-04-09 14:23:26
海外科学	NYT > Science	To Speed Vaccination, Some Call for Delaying Second Shots	https://www.nytimes.com/2021/04/09/health/covid-vaccine-second-dose-delay.html	To Speed Vaccination Some Call for Delaying Second ShotsStretching the time between the first and second doses would greatly accelerate the rate at which people get at least partial protection But some experts fear it could also lead to new variants	2021-04-09 14:37:55
金融	RSS FILE - 日本証券業協会	新型コロナウイルス感染症への証券関係機関等・各証券会社の対応について（リンク集）	https://www.jsda.or.jp/shinchaku/coronavirus/link.html	新型コロナウイルス	2021-04-09 14:38:00
金融	金融庁ホームページ	審判期日の予定を更新しました。	https://www.fsa.go.jp/policy/kachoukin/06.html	期日	2021-04-09 16:00:00
金融	金融庁ホームページ	株式会社ゆうちょ銀行における新規業務の認可について公表しました。	https://www.fsa.go.jp/news/r2/yuusei/20210409.html	株式会社ゆうちょ銀行	2021-04-09 16:00:00
金融	金融庁ホームページ	（株）ディー・エル・イーとの契約締結交渉者従業者による内部者取引等に対する課徴金納付命令の決定について公表しました。	https://www.fsa.go.jp/news/r2/shouken/20210409_1.html	内部者取引	2021-04-09 16:00:00
金融	金融庁ホームページ	（株）ディー・エル・イーとの契約締結交渉者従業者からの情報受領者による内部者取引等に対する課徴金納付命令の決定について公表しました。	https://www.fsa.go.jp/news/r2/shouken/20210409_2.html	内部者取引	2021-04-09 16:00:00
金融	金融庁ホームページ	ジョルダン（株）株式に係る相場操縦に対する課徴金納付命令の決定について公表しました。	https://www.fsa.go.jp/news/r2/shouken/20210409_5.html	相場操縦	2021-04-09 16:00:00
金融	金融庁ホームページ	ユー・エム・シー・エレクトロニクス（株）における有価証券報告書等の虚偽記載に対する課徴金納付命令の決定について公表しました。	https://www.fsa.go.jp/news/r2/shouken/20210409_3.html	有価証券報告書	2021-04-09 16:00:00
金融	金融庁ホームページ	富士ソフトサービスビューロ（株）における有価証券報告書等の虚偽記載に対する課徴金納付命令の決定について公表しました。	https://www.fsa.go.jp/news/r2/shouken/20210409_4.html	富士ソフトサービスビューロ	2021-04-09 16:00:00
金融	金融庁ホームページ	ジョルダン（株）株式に係る相場操縦に対する課徴金納付命令の決定について公表しました。	https://www.fsa.go.jp/news/r2/shouken/20210409_6.html	相場操縦	2021-04-09 16:00:00
金融	金融庁ホームページ	アイシン精機（株）との契約締結交渉者社員による内部者取引に対する課徴金納付命令の決定について公表しました。	https://www.fsa.go.jp/news/r2/shouken/20210409_7.html	内部者取引	2021-04-09 16:00:00
金融	ニュース - 保険市場TIMES	損保ジャパン、キーホルダーの贈呈式実施	https://www.hokende.com/news/blog/entry/2021/04/10/000000	損保ジャパン、キーホルダーの贈呈式実施交通事故防止のため損害保険ジャパン株式会社は月日、キーホルダーの贈呈式を実施したことを発表した。	2021-04-10 00:00:00
金融	生命保険おすすめ比較ニュースアンテナ waiwainews	養老保険福利厚生プランの新規お申込み	http://seiho.waiwainews.net/view/12283	newsallrightsreserved	2021-04-09 23:46:55
海外ニュース	Japan Times latest articles	Long road ahead for Toshiba buyout offer, warns board chairman	https://www.japantimes.co.jp/news/2021/04/09/business/corporate-business/toshiba-buyout-osamu-nagayama/	Long road ahead for Toshiba buyout offer warns board chairmanThe statement sent Toshiba shares plunging more than in afternoon trade They had soared as much as when word of the proposal first	2021-04-10 00:47:01
海外ニュース	Japan Times latest articles	Justin Rose fires first-round 65 for four-stroke lead at Masters	https://www.japantimes.co.jp/sports/2021/04/09/more-sports/golf/rose-lead-masters/	brian	2021-04-09 23:54:45
海外ニュース	Japan Times latest articles	Angels rally past Blue Jays after Shohei Ohtani’s game-tying hit	https://www.japantimes.co.jp/sports/2021/04/09/baseball/japanese-baseball/angels-rally-past-blue-jays/	angeles	2021-04-09 23:19:41
海外ニュース	Japan Times latest articles	Tokyo Olympic qualifiers for diving and artistic swimming likely to go ahead in Japan in May	https://www.japantimes.co.jp/sports/2021/04/09/olympics/summer-olympics/qualifiers-diving-artistic-swimming-may/	Tokyo Olympic qualifiers for diving and artistic swimming likely to go ahead in Japan in MayTokyo Olympic Games qualifying events in diving and artistic swimming look likely to go ahead in Japan next month after being threatened with cancellation because	2021-04-09 23:07:34
海外ニュース	Japan Times latest articles	‘Attack on Titan’ manga series concludes run of almost 12 years	https://www.japantimes.co.jp/culture/2021/04/09/entertainment-news/attack-on-titan-manga-ending/	hollywood	2021-04-10 00:31:10
ニュース	BBC News - Home	Prince Philip has died aged 99, Buckingham Palace announces	https://www.bbc.co.uk/news/uk-11437314	queen	2021-04-09 14:46:11
ニュース	BBC News - Home	Prince Philip: Death of the Duke of Edinburgh announced	https://www.bbc.co.uk/news/in-pictures-56692965	floral	2021-04-09 14:37:35
ニュース	BBC News - Home	Prince Philip: Sporting world pays tribute to Duke of Edinburgh	https://www.bbc.co.uk/sport/56692293	philip	2021-04-09 14:28:10
北海道	北海道新聞	トラブル６回　実験成功は「奇跡」　室工大衛星「ひろがり」	https://www.hokkaido-np.co.jp/article/531585/	人工衛星	2021-04-09 23:11:54
仮想通貨	BITPRESS（ビットプレス）	[techcrunch] Robinhoodの暗号資産取引が急増、2021年第1四半期で170万から950万に	https://bitpress.jp/count2/3_9_12414	techcrunchrobinhood	2021-04-09 23:24:40
仮想通貨	BITPRESS（ビットプレス）	[WIRED] 社会貢献のインセンティヴとしての仮想通貨と、思想としてのブロックチェーンの価値：加藤崇	https://bitpress.jp/count2/3_9_12413	wired	2021-04-09 23:19:25
GCP	Cloud Blog	Creating a SQL Server instance integrated with Active Directory using Google Cloud SQL	https://cloud.google.com/blog/topics/developers-practitioners/creating-sql-server-instance-integrated-active-directory-using-google-cloud-sql/	Creating a SQL Server instance integrated with Active Directory using Google Cloud SQLSQL Server instances in Google Cloud SQL now integrate with Microsoft Active Directory AD as a pre GA feature that you can try out for yourself right now This post describes the basic steps required to create a SQL Server instance with this new functionality If you re looking for complete details see the official documentation Create a domain with Managed Service for Microsoft Active DirectoryThe first step is to create a domain with Managed Service for Microsoft AD This can be done easily via the Managed Microsoft Active Directory section in the Google Cloud Console Click the CREATE NEW AD DOMAIN button and enter the following information Specify a Fully Qualified Domain NameExample ad mydomain comSelect a VPC networkExample defaultSpecify a suitable CIDR range for the AD domain Example Select a Region where the AD domain should be locatedExample us centralSpecify an admin name for the AD domain s delegated administratorExample mydomain adminWith all of that information provided it should look something like this Click CREATE DOMAIN to complete the process of creating the AD domain You ll have to be patient for a bit since it can take up minutes for the domain to be available for use Once it is ready it will look like this in the list of domains The final step to configure the AD domain is to set the Delegated admin password Click the domain name in the list of domains to go to its details page On that page click the SET PASSWORD link and make a note of the password which we ll use in a later step of this blog post Create a SQL Server instance with Windows AuthenticationAfter your AD domain is available for use you can start creating SQL Server instances that utilize the AD domain to enable Windows Authentication with AD based identities Go ahead and try out creating a new SQL Server instance by going to the Cloud SQL section of the Google Cloud Console Click the CREATE INSTANCE button Then click Choose SQL Server and enter the following information Specify an Instance IDExample sql server with adEnter a password for the sqlserver user and make a note of this for use in a later step Select a Database version All versions will work with Active Directory I selected  SQL Server Standard Select a Region where the instance should be located It is recommended that you locate the SQL Server instance in the same region as the AD domain for the lowest network latency and the best performance Example us centralSelect whether the instance should be located in a Single zone or Multiple zones For production instances Multiple zones is recommended to achieve high availability which provides automatic failover to another zone within your selected region  Select SHOW CONFIGURATION OPTIONS Click the Connections section to expand it and select both the Private IP and Public IP options  Note if this is the first time creating a Private IP for the Network you select you ll be prompted that a Private service connection is required Click SET UP CONNECTION and select Use an automatically allocated IP range in the Enable Service Networking API dialog that appears  Then click the Continue button to complete the process Back in the instance Configuration Options click the Authentication section to expand it From the dropdown menu for joining a managed Active Directory domain select the domain that you created in the first step of this blog post Cloud SQL will automatically create a Per Product Per Project Service account used for authentication to the instance You will be prompted to grant the service account the managedidentities sqlintegrator IAM role With all of that information provided the create instance form should look something like this Click CREATE INSTANCE to complete the process of creating the instance Once the instance is created you should see the new instance s overview page that should look something like this Well done You now have a SQL Server instance on Google Cloud that you can log into using Windows Authentication with an AD based identity  Connecting to the SQL Server instance using Windows authenticationLet s go ahead and confirm that everything works as expected To do so I ll create a Windows Server VM using Google Compute Engine Using it I can add a new user to the Managed Active Directory give that user access to the SQL Server instance in Cloud SQL and then connect to the SQL Server instance as that user with Windows Authentication Windows Server VM s are easy to create using Google Compute Engine s marketplace Searching for Windows Server in the marketplace returns many options to choose from I ll create a VM using the Secured SQL Server Standard on Windows Server option  After choosing the VM option click the Launch button and you ll be taken to the instance creation page Review the settings of the VM instance to be created especially the Network selection under the Networking section to ensure that the selected Network is a network that is included in your Active Directory domain Then scroll to the bottom of the instance creation page and click the Create button  Once the VM creation process is complete you ll be taken to the instance detail page Click the Set Windows password button to set a password to use for logging into the VM Then use the Remote Desktop Protocol RDP button to login in to the VM Once you are logged into the VM instance you can now join the VM to the Managed Active Directory domain Click the Windows icon on the bottom left of the screen type Control Panel and then press ENTER Navigate to System and Security and then click System Under Computer name domain and workgroup settings click Change settings Then click the Change button in the System Properties dialog box Enter the name of your Managed Active Directory in the Domain input text box and click the OK button A welcome to the domain message should appear that looks something like this Now that we have a Windows Server VM in our Managed Active Directory we can add a User To do so we ll need to install the necessary Remote Server Administration Tools RSAT Open Server Manager and click the Manage menu item and select Add Roles and Features wizard In the wizard advance to the Select features page You can select Features from the sidebar or select Next until you reach it On the Select features page in the Features list expand Remote Server Administration Tools and then expand Role Administration Tools Under Role Administration Tools select AD DS and AD LDS Tools This enables the following features Active Directory module for Windows PowerShellAD LDS Snap Ins and Command Line ToolsActive Directory Administrative CenterAD DS Snap Ins and Command Line ToolsOptional You may also want to enable the following features Group Policy ManagementDNS Server Tools under Role Administration Tools Close the wizard Excellent Now the Windows Server VM is enabled with the tools to add Users to the Managed AD domain Remember the Delegated admin that we specified when we created the AD domain at the beginning of this blog post Well now it s time to use it We ll log out of the Windows Server VM and log back in as the Delegated admin Log out of the Windows VM by clicking the Windows icon at the bottom left of the VM instance screen then clicking the power icon and selecting Disconnect Back on the Google Compute Engine instances page click the RDP button to log back into the Window Server VM but this time do so with the AD domain Delegated admin username and password Once logged in open Server Manager click the Tools menu item and select  Active Directory Users and Computers  In the Active Directory Users and Computers dialog window that appears expand the ad mydomain com item and click the Cloud sub item Then Click the Create a New User in the current container icon to create a new User Enter a First and Last name for the User along with a logon name and click the Next button Enter and confirm a Password for the User then click the Next button again Finally click the Finish button in the confirmation dialog box to create the User Great Now we ve got a new AD domain User But they still need to be granted access to the SQL Server instance on Cloud SQL We can do that with Azure Data Studio Open a browser on the Windows Server VM and go to the Azure Data Studio download page  Click the System Installer link to initiate the download and click the Run button in the download dialog window that appearsAfter the Azure Data Studio installation wizard completes with Launch Azure Data Studio checkbox selected click the Finish button to open the program In the start screen Azure Data Studio click the New Connection link For Server enter the Active Directory FQDN Private value from the Cloud SQL SQL Server instance details page Example  private sql server with ad us central your new project cloudsql ad mydomain comFor Authentication type select SQL Login For the User name enter sqlserver and for Password enter the password for the sqlserver User that you specified when you created the SQL Server instance With all of that information specified the Connection Details should look something like this Click the Connect button to connect to the SQL Server instance Once the connection is made click the New query link and enter the following query CREATE LOGIN ad mydomain com clouduser FROM WINDOWSand click the Run button Wonderful We re completely done with the setup and now it is time for the moment of truth Let s test out connecting to our SQL Server instance as our new AD domain User via Windows Authentication Close the Azure Data Studio Now we ll reopen Azure Data Studio but we ll do so as the new AD domain User Click the Windows icon at the bottom left of the VM instance screen and type Azure Data Studio Right click the Azure Data Studio icon and select Run as a different user Enter the User name and Password for the AD domain User in the dialog box that appears On the Azure Data Studio start page click the New Connection link   For Server enter the Active Directory FQDN Private value from the Cloud SQL SQL Server instance details page Example  private sql server with ad us central your new project cloudsql ad mydomain comFor Authentication type select Windows Authentication Click the Connect button and smile because your SQL Server on Cloud SQL is now integrated with Managed Active Directory Getting startedWindows Authentication for Cloud SQL for SQL Server is available in preview for all customers today   Learn more and get started	2021-04-09 15:57:00