• ASP.NET Core Web Apps with EF Core | Entity Framework Core 101 [3 of 5]
    Articles,  Blog

    ASP.NET Core Web Apps with EF Core | Entity Framework Core 101 [3 of 5]

    >>Hi, I’m Cam Soper. I’m a Content Developer working on.NetDocs here at Microsoft, and welcome back to Entity Framework Core 101. In this video, I’m going to show you how you can use Entity Framework Core with ASP.NET Core scaffolding to streamline your web development. You can see in Visual Studio, I’ve got a mostly empty web application. This web application, already has ContosoPetsContext DbContext as well as an entity model. The entity model reflects a working database that’s already running in production. The first thing I’m going to do is I’m going to register our ContosoPetsContext with ASP.NET Core’s dependency injection container. The way I do this is by…

  • Adding a Service to an ASP.NET Core Website | ASP.NET Core 101 [4 of 13]
    Articles,  Blog

    Adding a Service to an ASP.NET Core Website | ASP.NET Core 101 [4 of 13]

    >>Hey friends. We’re creating an ASP.NET website. We’re doing it the 101 style, real slow, very deliberately. In the last video, we’re starting to bring in data. We haven’t actually displayed it yet because we want to do this right. We’ve made a little JSON file and that’s our database for this purpose. Then, what we’re going to do is we’re going to add a service, and ASP.NET has this concept of services. We’re going to try to do that in a very deliberate way as well. So you’re clear on how we’re doing.>>So why even make a service to begin with? Why can’t I just take this code wherever…

  • Adding Data to an ASP.NET Core Website | ASP.NET Core 101 [3 of 13]
    Articles,  Blog

    Adding Data to an ASP.NET Core Website | ASP.NET Core 101 [3 of 13]

    >>Hey, we’re making an ASP.NET website in this ASP.NET 101 series, and we did a Hello World.>>Yes.>>I’m feeling pretty successful already.>>That’s pretty great. Self-esteem.>>Self-esteem is an all time high.>>Yes.>>Let’s add some data to our website. Now, when we last left our heroes, we had made the Contoso Crafts website. It’s a local website, and all we did at this point was we successfully changed that code.>>Where are the crafts?>>That’s cool. We have no crafts, that’s a problem. We also have no database.>>Not good.>>So data comes in lots of different forms. We could make a database, we could find a website that would give us database.>>Well. What is a database? Database…

  • Getting Started with Cloud SQL for MySQL
    Articles,  Blog

    Getting Started with Cloud SQL for MySQL

    AASTHA BHARDWAJ: Welcome. My name is Aastha, and I’m an engineer on the Cloud SQL team. In this video, I’ll show you how to create, run, and manage SQL instances using Google Cloud SQL. Cloud SQL helps manage mundane administrative tasks for MySQL and Postgres databases so you can focus on what matters. Let’s walk through how to create a MySQL database on Cloud SQL and connect to it from the Google Cloud shell. You can set up an instance in just a few steps. Let’s go through the basics, and I’ll point out some options for additional configuration along the way. We’ll start by navigating to Cloud SQL in…

  • Installed SQL Server?…Now What? (Getting Started)
    Articles,  Blog

    Installed SQL Server?…Now What? (Getting Started)

    Hi. I’m Jason Roth. In the last video we installed SQL Server 2008 R2. If you’re new to SQL Server, you may be thinking, “Now What?” In this video I’ll show you how to create your first database. We’ll then install a sample AdventureWorks database. And we’ll conclude by importing a spreadsheet into a database. This is not a video on database design, but it should give you some invaluable hands-on experience with the tools. And you can immediately begin using SQL Server. It all starts with a tool called SQL Server Management Studio. On the “Start Menu”, click “All Programs”, expand “Microsoft SQL Server 2008 R2”, and then start…

  • Installing Jenkins on Ubuntu Server 15.10 (Get started with Jenkins part 2)
    Articles,  Blog

    Installing Jenkins on Ubuntu Server 15.10 (Get started with Jenkins part 2)

    Hi everyone and welcome back to the “Get started with Jenkins” series. In this video I’m going to show you can install Jenkins. Just a quick note before I continue: the instructions in this video will only work for Linux distributions that are based on Debian. Jenkins can run on practically all Linux distributions but for this video I will use Ubuntu Server 15.10. If you prefer to use another Linux distribution you can skip this video and checkout the official Jenkins documentation and read the instructions for your distribution. Okay, so with that out of the way, let’s get going! I’ll start by showing you how to install the…

  • Articles

    Getting Started with T-SQL Queries using SQL Server Management Studio

    Hi. I’m Jason Roth. In the previous videos, we installed SQL Server 2008 and began using SQL Server Management Studio. In this video, I’m going to show you how to write basic database queries in SQL Server 2008. I’m also going to provide some tips and tricks along the way. Let’s start by launching SSMS. On the “Start Menu”, expand “Microsoft SQL Server 2008 R2”, and then click “SQL Server Management Studio”. Type the name of your SQL Server instance, and then click Connect. In our first video, “What is a Relational Database?”, we introduced a fictional database that contained experiment data. This database has three tables: Experiements, Runs, and…

  • Hosting a static website on Amazon S3 (AWS howto)
    Articles,  Blog

    Hosting a static website on Amazon S3 (AWS howto)

    Hello everyone! In this video I’m going to show you how you can host static websites on Amazon S3. But before we do that, let’s first take a look at what S3 is. Well S3 is a cloud storage service, built by Amazon, that allows you to store an unlimited amount of files in the cloud. And being the cloud, you of course only pay for what you use. So why would you use S3 instead of a regular webhost? Well first of all S3 has great performance. It’s also very secure since you don’t have PHP or a MySQL database running that can be compromised. It’s low cost in…

  • Getting Started with AWS | Amazon Web Services BASICS
    Articles,  Blog

    Getting Started with AWS | Amazon Web Services BASICS

    Hi. Welcome to the video. My name is xxxx And in this video, I want to introduce you to AWS, the Amazon Web Services. Now if you already know AWS , you know they have a lot of services and getting started can be tough. If you don’t know them, we’ll get to know AWS in this video. By the end of video, we’ll have a very basic website being deployed on AWS so that we can actually visit it in the web. And you will hopefully have a better understanding of what AWS is about how it generally works, and how you can navigate general services they offer. So…