WEBVTT
NOTE Confidence: 0.8781
00:00:10.110 --> 00:00:12.680
Hello everyone, thank you for tuning in.
NOTE Confidence: 0.8127558
00:00:13.450 --> 00:00:25.720
In this session, I'll take you through an overview or Postgres sequel, and my sequel. Database services on Asher's and also show you some of the capabilities that these services.
NOTE Confidence: 0.8584734
00:00:25.770 --> 00:00:31.790
Bring to you and really help you as you build applications, so let's dive in.
NOTE Confidence: 0.8563319
00:00:33.920 --> 00:00:47.260
The biggest piece really where we focused as we brought these services onto Azure is to make sure that we maintain the familiarity that you have about these services.
NOTE Confidence: 0.7989436
00:00:47.300 --> 00:01:00.960
So both Posca sequel in my sequel database engines on Azure. Our community additions. So these are exactly the database engines that you have been using and therefore you can use your existing tools.
NOTE Confidence: 0.771698
00:01:01.000 --> 00:01:14.200
Uh Petey admin for example, for Postgres be sequel, and therefore just continue with your own style of working without changing that, add the same time because this is in Azure in the cloud.
NOTE Confidence: 0.835511
00:01:14.250 --> 00:01:24.340
You get the advantages of a fully managed service wherein you do not need to be worried about patching about updating we take care of that for you.
NOTE Confidence: 0.8502255
00:01:24.380 --> 00:01:38.270
Cause you have the community addition with here all the languages and frameworks that you have been working with continued to work here now, so the key capabilities. We have now side to bring in on top of these engines.
NOTE Confidence: 0.8576442
00:01:38.310 --> 00:01:52.630
Is really about scalability and high availability so specifically will scalability they ability to really scale to a much higher compute within seconds is there so you don't have to really.
NOTE Confidence: 0.8695415
00:01:52.670 --> 00:02:05.240
We wait for hours when you suddenly have a huge load of customers coming in or do users logging in you can actually scale. The service within seconds and make sure that your customers your users.
NOTE Confidence: 0.8461907
00:02:05.280 --> 00:02:18.600
Are getting the right experience and as I said about high availability as well. High availability comes a built in so you don't need to do any extra configuration replication. It's all built in including the cost as well.
NOTE Confidence: 0.832857
00:02:20.370 --> 00:02:32.140
And be cause these services are on Azure. You get the full advantages of the Azure ecosystem, which effectively means that if you want to. For example, at a cognitive service.
NOTE Confidence: 0.7917418
00:02:32.190 --> 00:02:43.910
That's piece of mission for example, ads search. API all of that is very easily accessible. You don't have to write hundreds of lines of code just had an API of one of the cognitive services.
NOTE Confidence: 0.8569248
00:02:43.950 --> 00:02:52.860
There you go you start making your apps much more intelligent as well as provide newer experiences to your users.
NOTE Confidence: 0.8620646
00:02:52.900 --> 00:03:05.600
Finally, you have got a very simple and flexible pricing model when much of what we talked about like security high availability comes a built in and you can take advantages of that.
NOTE Confidence: 0.8435718
00:03:05.680 --> 00:03:17.170
With no extra cost so now that you have a good idea of what really these services bring in. Let's type in and take a look at a couple of capabilities in action.
NOTE Confidence: 0.8501545
00:03:18.510 --> 00:03:30.790
So let's get started with how to get an Azure account. All you need to do is to get to azure.com and then you can get a free account, which also gets you access to $200 credit.
NOTE Confidence: 0.866224
00:03:30.830 --> 00:03:44.800
This newly once you're online you can also look at the service pages for my sequel as well as Postgres sequel, and once you are on these pages. We have got documentation around how to get started.
NOTE Confidence: 0.8672864
00:03:44.840 --> 00:03:58.310
As well as using many of the popular services and tools that you're used to so once you have an account. You can get into the portal, which I have opened here for myself and here you can see.
NOTE Confidence: 0.8529719
00:03:58.330 --> 00:04:12.530
Why this source is effectively resources is a place where you bring in all the services which are relevant for a particular workload for the benefit of us going to the process share with you? How do you really create?
NOTE Confidence: 0.7732797
00:04:12.570 --> 00:04:24.950
Posca service on Azure. All you need to do is to create a resource and either. You can come down and pick. Both Chris on my sequel or you can go in here and you can search Azure database.
NOTE Confidence: 0.7514845
00:04:25.690 --> 00:04:31.450
For my sequel oppose case. Let's start with Postgres and create a new database.
NOTE Confidence: 0.8078461
00:04:32.400 --> 00:04:40.350
So the key things that you need for this of course, the server name so let's do that connect Postgres 2017.
NOTE Confidence: 0.8475142
00:04:41.020 --> 00:04:53.490
And then you can use an existing research group or a new one. I'll use an existing ones. I've got a research group called education. Let's find it. Let's use it here, you of course need.
NOTE Confidence: 0.8373026
00:04:54.270 --> 00:05:05.140
Login names and let's put connect 2017 and then let's put a password important to remember the password because this will also help you.
NOTE Confidence: 0.8773937
00:05:06.120 --> 00:05:11.900
With the other tools that you have when you try to access this particular database.
NOTE Confidence: 0.8434968
00:05:12.660 --> 00:05:28.200
Choose a location now because we are an Azure. You'll see that you get multiple regions, which are available to choose from. We currently have 16 regions and just over the last couple of months. We have added multiple regions and we will continue to add more details as we go forward.
NOTE Confidence: 0.8401242
00:05:28.240 --> 00:05:43.270
And as I said, we use the community version, so you can see you have the latest 9-point-6 version available here for you to choose and be cause. This is a managed service, you can actually choose multiple skews based on what say for example, a certain amount of.
NOTE Confidence: 0.8640118
00:05:43.580 --> 00:05:56.510
Um started a certain amount of compute and then you have got various kind of performance requirement. You can choose based on what really your application or your workload requires.
NOTE Confidence: 0.85295
00:05:56.560 --> 00:06:09.760
And once you have made that choice. You just say okay and leave it for us to provision. A database for you and you can see that provisioning is already happening let's go through a database, which I created already.
NOTE Confidence: 0.7987598
00:06:09.810 --> 00:06:24.110
Which is disconnect overview database but what I want to show you a couple of things so you use peace equal or used admin now? How do you connect data based period mental and how do you start managing?
NOTE Confidence: 0.7770014
00:06:24.480 --> 00:06:32.080
This actually based database to the PTA admin, so I'm going to be the admin here. I go in here and let's take a look so.
NOTE Confidence: 0.8265473
00:06:32.910 --> 00:06:46.810
Service currently I can create a new server, and connect as you are to this particular tool. So what you see here is currently I've got 3 databases here and let's try to create a new server first of all.
NOTE Confidence: 0.8045315
00:06:46.960 --> 00:06:55.360
Connect this to Azure Database for Postgres sequel that we have so we of course need a name here, so let's write my.
NOTE Confidence: 0.8091469
00:06:56.230 --> 00:07:08.860
Chris sequel database, and let's go into connection and all you need it for the connection and they said earlier our server name that you have here so just copy.
NOTE Confidence: 0.8629655
00:07:09.240 --> 00:07:21.720
And let's get it in here and then what you need is the login name, which you can copy here and then I get it in here and of course, as I said, before they needed to remember the password.
NOTE Confidence: 0.8075716
00:07:21.800 --> 00:07:34.160
Uh for authentication so I get in the password and hopefully everything is right, and hopefully this goes through perfect. So you can see that I'm glad the new database right here and this is connected with the Azure data based.
NOTE Confidence: 0.8221363
00:07:34.270 --> 00:07:47.630
I have now all I need to do actually at a test that is really create a data base in here and see if that comes up when I go down here, so you have got 3 databases here currently.
NOTE Confidence: 0.8531098
00:07:48.100 --> 00:07:53.870
And is it possible for me to directly create a database in here from Fiji Admin Let's test it out.
NOTE Confidence: 0.8063573
00:07:54.850 --> 00:07:59.540
They go into Pete and here let's create a new database.
NOTE Confidence: 0.7296876
00:08:00.670 --> 00:08:07.540
And let's go let's say a new beach, the sequel.
NOTE Confidence: 0.8497314
00:08:10.240 --> 00:08:21.950
Deby okay and let's say, but so while this is happening. Let me also show you how you can also do much of this to the cloud shell that we have here.
NOTE Confidence: 0.8383673
00:08:22.010 --> 00:08:34.530
Okay, so you can just go in here and I've got a couple of commands here. So let me look at my commands and you can actually go in use these commands to actually start looking at hate.
NOTE Confidence: 0.8544859
00:08:35.250 --> 00:08:48.870
Get information about yard database they can just connect here and then all you needed to give was the source group name, which is connect demo here as well as the name of the database, which is.
NOTE Confidence: 0.8327171
00:08:48.930 --> 00:09:02.860
Uh connect overview so it just give these basic information and you are able to get all the necessary information that you need to actually take it to a peace equal auto. Pegi admin to connect it back here so you can work through this stool, as well.
NOTE Confidence: 0.8433245
00:09:02.910 --> 00:09:16.980
And what you can do now is because you have that information. If you are used piece equal all you have to do is actually called apiece equal command here and you can actually connect directly to peace equal so let's try that.
NOTE Confidence: 0.8763153
00:09:17.250 --> 00:09:22.590
So you come here and you have let's use the password that we have.
NOTE Confidence: 0.8014398
00:09:23.990 --> 00:09:35.850
Let's see if it connect it's already connected now so you can see that directly. It's connected to Postgres now when using piece equal come on now. You can actually work through it. Meanwhile, now that we have given some time to be the admin to.
NOTE Confidence: 0.8228366
00:09:36.100 --> 00:09:49.320
To connect the database, Hey, you go so you can see that the new peace equally be databases. Right here, so let's go back in here. Let's look back again and connect overview than when you go in here if you remember, we had 3 databases.
NOTE Confidence: 0.8171108
00:09:49.570 --> 00:10:00.340
And now we have got a fourth one added so you can see here in new Pide Sequel TV, which exactly the database that we created using pegi at MIT and not just that.
NOTE Confidence: 0.8403064
00:10:01.050 --> 00:10:15.040
Admin 2 look and see all these 4 databases that have been created their right here, so that you can go in and you can actually manage these databases right from the tool that you are familiar with the last thing I wanted to call out.
NOTE Confidence: 0.8590371
00:10:15.090 --> 00:10:29.720
Really, in terms of what you can do once you are an Azure is that building new delightful experiences into our applications. Whether it be cognitive. Services like speech or search through APIs without writing many, many lines of code.
NOTE Confidence: 0.8576671
00:10:30.280 --> 00:10:41.940
So I hope you saw how we're bringing the community. Additional post Chris and my sequel together with fully managed capabilities of a service in Azure.
NOTE Confidence: 0.8524834
00:10:42.560 --> 00:10:52.630
As we go forward you will get to see many of these in other deep type sessions on channel line. Thank you so much for tuning in once again, bye bye.