Deprecated: strtr(): Passing null to parameter #1 ($string) of type string is deprecated in /chroot/home/a40b7614/774635bdc8.nxcli.io/html/wp-content/plugins/moosend-email-marketing/vendor/moosend/website-tracking/src/Utils/Encryption.php on line 8 Deprecated: urlencode(): Passing null to parameter #1 ($string) of type string is deprecated in /chroot/home/a40b7614/774635bdc8.nxcli.io/html/wp-content/plugins/moosend-email-marketing/vendor/moosend/website-tracking/src/Payload.php on line 202 Scott Duffy – Page 20 – SoftwareArchitect.ca

Author: Scott Duffy

  • Brand New Course on The New TOGAF 9.2 Standard

    Brand New Course on The New TOGAF 9.2 Standard

    Here’s some brand new content from the SoftwareArchitect,ca YouTube channel that you might find interesting.

    Happy to announce my new TOGAF 9.2 Certification course on Udemy.

    https://www.udemy.com/togaf-part1/?couponCode=NEWLAUNCH

    The Open Group recently released the newest version of the the TOGAF Standard, version 9.2. The new standard makes some subtle changes to the specification. This course is all new, covering the standard from top to bottom. The focus is on the certification, but you do not have to want to get certified to find this course useful for learning TOGAF 9.

    The first version of this course was the most popular training product on TOGAF, with 28,000 students enrolled. Learn the new standard from the leading TOGAF trainer. Of course, since this course is on Udemy, you’ll never pay too much either. Affordable, approachable training.

    Quickstart Series: Windows Web App in Azure

    In this video, I show you how to create a Windows Web App in Microsoft Azure. Windows Web App. We go through the Azure Portal, and see how form fields get filled in. If you can’t afford to create resources in Azure, but want to see how it’s done in 2018, this is the video for you.

    Or you can see the video directly on YouTube.

    Transcript:

    For the first time in six years, The Open Group has released a new version of the TOGAF Standard. The new release is called the TOGAF Standard, Version 9.2. The TOGAF Standard has been restructured, going from a single, large specification to multiple, smaller documents. Here’s now the core framework plus several smaller guides as add-ons. The TOGAF Standard, Version 9.2 adds an additional focus on newer digital trends and business transformation beyond IT. In this course, I’ll prepare you for the TOGAF 9.2 Part 1 Exam by taking you through what you need to know to pass. More than 28,000 students have enrolled in the TOGAF 9.1 version of this course and I am pleased to be one of the first to market the training on this updated Standard. In this course, we’ll go through each of the requirements of the exam one by one. On screen, you’ll see the requirements of the exam and there are videos on each of them inside this course. You’ll learn all about the Architecture Development Method, ADM, which is the heart of the TOGAF Standard. I’ll give you a high-level overview of it to start but then dive deep into each of the phases of this process. You’ll learn about the role of the enterprise architect in an organization, and how we go about our work to get the business in alignment with its own goals. Over 4,000 students have left a four or five-star review on the first version of this course, and this new course has been completely revised and updated to be even better. You’ll get the same great quality you come to expect from me, including high quality video lessons, quiz questions, downloadable audio files, so that you can learn on the go, and lifetime access to materials. TOGAF skills are among the highest paying skills according to regular salary surveys, and so if you want to improve your team’s architecture capability or put yourself in a position for a new job, sign up right now for this groundbreaking new course and put yourself above the pack.

  • Which Azure Certification | 70-532, 70-533 or 70-535

    Which Azure Certification | 70-532, 70-533 or 70-535

    Here’s some brand new content from the SoftwareArchitect.ca YouTube channel that you might find interesting.

    Which Azure Certification Should I Take?

    This is such a common question, and I’ve addressed the answer to this a few different ways. In this video, I should you the real difference between the three Azure certifications you can go for. 70-532 Developing Microsoft Azure Solutions, 70-533 Implementing Microsoft Azure Infrastructure Solutions, and 70-535 Architecting Microsoft Azure Solutions.

    What topics are on each exam? What’s the real difference between the three exam? Which exam should I take? By seeing the topics that each exam covers, maybe the answer becomes clearer to you.

    Quickstart Series: Windows Web App in Azure

    In this video, I show you how to create a Windows Web App in Microsoft Azure. Windows Web App. We go through the Azure Portal, and see how form fields get filled in. If you can’t afford to create resources in Azure, but want to see how it’s done in 2018, this is the video for you.

    Or you can see the video directly on YouTube.

    Transcript:

    Well, hi there. This is Scott Duffy from softwarearchitect.ca. Today I thought I would do something a little different. I’m going to compare the three core Azure certifications which are, 70-532 Developing Microsoft Azure Solutions, 70-533, which is Implementing Microsoft Azure Infrastructure Solutions, and 70-535 Architecting Microsoft Azure Solutions.

    Now, you can do this yourself, going to your search engine of choice and entering the exam code. You’ll find the Microsoft official webpage is one of the top results. Now, on this page, Microsoft lists a number of topic areas, a number of objectives and underneath that you’ll see sort of sub-objectives. Now, today I reviewed this, Microsoft recently changed it as of March 22nd 2018, you can see on all three of these pages that the date updated is at the end of March, March 29th, March 22nd, March 22nd. So I went to each of those pages and I listed the major topics of Microsoft Azure. So as somebody who works with Azure on a day to day basis, you’re going to be working in one of these areas or multiples of these areas.

    You can see here, I put together this comparison of these examples across these various major areas. Now the 70-532 exam, which is the developer exam, doesn’t really touch on networks. It used to but they removed a lot of that content, or really deep security questions. It does talk about storage, of course app services and server list is huge. Virtual machines, 20 to 25% and a little bit about setting up applications that use Azure Active Directory, not for security, but for authentication and authorization, okay? So you can see the breakdowns are pretty straightforward.

    When we move into the 70-533 exam, the 70-533 exam touches a little bit of almost everything. You get lot more networking topics, security topics, virtual machines and infrastructure as a service, of course that’s major and things such as ARM templates, being able to create resources using ARM templates. There are little bits about reporting and automation management and monitoring, Azure Active Directory, less so than a 532 exam in that particular case. So you’ll see there there’s some big focus areas, there’s also some minor focus areas.

    When we move to the architecture test, it’s a little bit of everything. Every single requirement that I’ve listed along the left side, from networking all the way down to ARM templates, has around 10% on this the test. So really Microsoft’s going to ask you, out of 40 questions, three or four questions on each of these so it requires some very broad knowledge of the Azure environment, but not necessarily extremely deep knowledge. In the developer exam, you’re going to be asked programming questions, you’re going to be shown code. In the 533 infrastructure exam, you’re going to be asked about PowerShell and the perimeters that get passed in PowerShell. You’re going to be asked to construct ARM templates, or to be able to read an ARM template and say what it’s doing.

    In the architecture test, the 535 test, you shouldn’t expect any code. You shouldn’t expect to have to go into a simulation of the interface and do any particular work, but you need to understand the entire Azure environment, how things fit together, why you would choose one over another. Why would you choose an Azure SQL Database instead of an Azure SQL Warehouse or a Cosmos DB, what are the benefits of doing that? The architecture test is very much about being able to make the right choice given all of the options that Microsoft Azure has and believe me, they have hundreds of services to offer, whereas the 532 and 533 tests are more about selective application of those skills in terms of being able to go off and do something that’s specifically to that particular job role.

    So the Microsoft exams, you might think 533 and 535 have a lot in common, to me they are more about focus, where this is really security and infrastructure as a service as the two big focuses. 50% of the test have to do with security and infrastructure as a service, whereas in the 535 test, it’s a little bit shallower but across everything. So those are the major differences between the three exams. If you want to join, we have a amazing Facebook group that contains a lot of people and a lot of questions and a lot of knowledge is being shared, we’d love to have you in there. The link is in the description below. Otherwise, I hope this helps you decide which of the following tests would be right for you, based on your job role, based on your level of knowledge or level of interest, where you should start to go and pursue certification within Microsoft Azure.

    Of course, I have training on all of these, so come to softwarearchitect.ca and you’ll be able to see some courses that are available. The courses are really affordable, you get lifetime access, unlike some other people that give you very selective access. So come and check it out but if you’re looking to know where do I start on my Microsoft Azure certification journey? Here’s a good graph that you can start with. Thanks a lot and talk to you again.

  • Which Azure Exam Should I Start With?

    Which Azure Exam Should I Start With?

    Test Support 2

    Test support 1

    I get this question from time to time, and I could have sworn I had written about this somewhere. I looked here, looked on YouTube, and couldn’t find it. So it’s about time I put down in words the answer to the question…

    “I’m wanting to learn Azure for work. Which Azure exam should I start with?”

    I guess the question of “which direction should I go?” should first be answered with, “where do you want to end up?”

    So let’s start there? What is your ultimate goal? What is your purpose for wanting to take certification tests?

    Person A – I want to learn Azure completely. I want to know a little bit about everything when it comes to Azure. Well-rounded generalist.

    Person B – I have a particular job role in mind. I want to excel at that role. I don’t anticipate changing careers in the next little while because I love what I do.

    Person C – Although I currently need to learn Azure for a particular job, I can see myself wanting to learn more than just the tasks for that job. I’m wanting to grow into a new job possibly.

    So depending on the type of person you are, you might want to go a different route when it comes to learning Azure.

    Specialist

    For Person B , the person who has a job and likes their job and isn’t looking to learn more than what it takes to be excellent at their job, then I might suggest you concentrate on one area of study.

    For Person C, the person who starts with a job and is looking to grow from there, they can take a similar approach. Start with what you know, and use that as a base to add more skills and knowledge from.

    For instance, developers might want to start with 70-532 exam. This is a developer focused exam. All you would need to learn is the way that developers interact with Azure – from code, command line, and the developer tools that Microsoft provides.

    Database administrators and data developers might start with 70-473 as a logical place to start. That isn’t a difficult exam, and you might find familiarity with the SQL Server and SQL Database topics based on your existing understanding of how SQL Server works.

    Operations and implementors might want to look at 70-533 exam to start. This exam doesn’t focus on dev tools but does focus on the things that operations team members need to know to set up, manage, and optimize Azure in day-to-day operations.

    And if you’re not a coder, and not really familiar with PowerShell, you might look at 70-535 architecture exam. This exam covers a LOT of ground. There are hundreds of topics covered. But they don’t go into too much coding or implementing detail, just testing your understanding of the services and their purpose.

    So, if you’re trying to become a specialist, I might suggest you go after the area that you already have knowledge in.

    Generalist

    For Person A, the generalist, you have to learn it all eventually.  So it’s makes some sense to be strategic about in what order you learn things.

    I myself took the 70-534 exam (now 70-535) first. It was a tough exam, but I spent the time to learn all of the parts and was able to build a solid general understanding of the different services of Azure and why you’d choose to use them.

    Then when I took 70-532, it was easier. It did not require as much studying. I was able to leverage what I had already learned to take the next exam.

    Some people might want to do that the other way around.

    You can take the 70-533 exam first, which some think is the easiest. Then you can move to 70-532 before taking 70-535. Or skip one of those 3 and add another exam like 70-473 data to the mix.

    So either you take the hardest first, and the next exams don’t require as much effort to study. Or you take the easiest first, and build your confidence up to take the other exams.

    I can’t tell you what to do. I can’t tell you which way will work for you. I can only say what I did, and offer up the pros and cons of each approach.

    Your Heading Here

  • Microsoft Azure Tutorial for Beginners | Free Azure Course

    Microsoft Azure Tutorial for Beginners | Free Azure Course

    Here’s some brand new content from the SoftwareArchitect.ca YouTube channel that you might find interesting.

    Microsoft Azure Tutorial for Beginners. Just launched today is this completely free Azure course for beginners that takes you step-by-step through as I create various resources in Azure to create a complete 3-tier architecture solution.

    FREE [[ https://www.udemy.com/free-azure/ ]]

    In this course, we create a traditional 3-tier application structure inside Microsoft Azure. By the end of the course, you will be able to:

    – Create a Windows VM using the Azure Portal
    – Create a Windows VM using Powershell and ARM Templates
    – Create a Linux VM using the Azure Portal
    – Create a Linux VM using CLI and ARM Templates
    – Create a Public-facing Load Balancer, and configure it to work with web servers
    – Create an Internal-only Load Balancer, and configure it to work with application servers
    – Create an Azure SQL Database
    – Create a Secondary SQL Database, for failover in case the primary goes down
    – Set up Automatic Failover so that Azure monitors the state of your database for you

    There’s a lot going on! And learn it all in around 90 minutes!

    The skills you learn today will stay with you for years to come and help you grow in your career.

    Enroll today!

    FREE [[ https://www.udemy.com/free-azure/ ]]

    Quickstart Series: Windows Web App in Azure

    In this video, I show you how to create a Windows Web App in Microsoft Azure. Windows Web App. We go through the Azure Portal, and see how form fields get filled in. If you can’t afford to create resources in Azure, but want to see how it’s done in 2018, this is the video for you.

    Or you can see the video directly on YouTube.

    Transcript:

    I have something brand new for you. Hey there, are you interested in Microsoft Azure, and you don’t know where to start? I have a free course that you might be interested in. It’s called Create a 3-Tier Application Using Azure Virtual Machines. We can see on screen, a diagram of what you’ll be able to create all by yourself once you’re finished with this course.

    The course itself is only 90 minutes, and we’re going to be creating virtual machines and other resources using the Azure Portal, using PowerShell, and also CLI. And also we’re going to be using ARM Templates. A lot of these things are covered on the certification test, so this kind of free course will be perfect if your eventual goal is to get certified. But even if your goal is not to get certified, doing these resources in all these different ways is going to teach you a lot.

    So in an afternoon, you’re going to be able to sit down, and completely for free, learn lots of stuff about Microsoft Azure. I mean the course is free. Azure has a free trial account. All I ask is if you are able to leave a review, that would be awesome. Free courses, sometimes they get the short end of the stick when it comes to reviews. So take the course, leave a review. That would be great.

    There’s the URL on screen. https://www.udemy.com/azure-free. You can go up today, sign up. It’s going to cost you absolutely nothing, you’ll get 90 minutes of training on Microsoft Azure, creating over eight resources within the Azure Portal. So I hope to see you inside.

  • May 2018 70-533 exam tips | Tips for the Implementing Azure Exam

    May 2018 70-533 exam tips | Tips for the Implementing Azure Exam

    Here’s some brand new content from the SoftwareArchitect.ca YouTube channel that you might find interesting.

    Here are the latest 70-533 exam tips. I recorded this video this afternoon to talk about the latest tips for the 70-533 exam.

    Perhaps you have questions about the 70-533 implementing Microsoft azure infrastructure solutions exam. Well, in this video, I see what students are saying to study for the exam.

    The Unofficial Azure User Group can be found here: https://www.facebook.com/groups/azureusergroupunofficial/

    Quickstart Series: Windows Web App in Azure

    In this video, I show you how to create a Windows Web App in Microsoft Azure. Windows Web App. We go through the Azure Portal, and see how form fields get filled in. If you can’t afford to create resources in Azure, but want to see how it’s done in 2018, this is the video for you.

    Or you can see the video directly on YouTube.

    Transcript:

    Hi, there. My name is Scott Duffy from softwarearchitect.ca. In this video, we’re going to talk about the latest exam tips for the 70-533 exam, which is implementing Microsoft Azure Solutions Certification. These tips come from both my Azure students of my Azure courses as well as the members of the Azure User Group on Facebook. The link is on screen or you can go into Facebook and just search for Azure User Group, and we would love to have you as a member. If you have questions you want to ask about Azure or you want to just participate in discussions or you have resources to share, I would love to invite you to join and we could all learn from each other. Join the Azure User Group.

    Now, these are the latest tips for the 70-533 exam from students who’ve taken that exam in the last couple of months. One student came out of the exam and said that there were way more Azure Automation Desired State Configuration questions than they had expected. Another student talked about OMS, Operations Management Suite, questions and finally kind of related to the Azure Automation part was the ability to read ARM templates was identified as a key skill. If you have time to study before you want to take this test, I would recommend you download ARM templates, start reading through them, modifying them, deploying them, get more familiar with ARM templates.

    Finally, scripting is always important. The last 12 months or so, scripting has been growing in importance within the 70-533 exam so understanding PowerShell, CLI, getting the Azure SDK for those things, adding, removing, managing, maintaining, scaling resources using PowerShell and CLI. Give that a try.

    This is the TL;DR. This is the summary of my latest tips on this exam. If you look at the exam requirements for 70-533, security, backup and recovery and virtual machines make up 50% of the exam these days. Now, you also going to want to know more modern technologies such as containers and ARM templates as well as virtual networks being a foundational technology.

    You’ll want to practice deploying and managing resources using all the Portal as well as PowerShell and CLI, like I said. Finally, these are really two great resources. One is the Azure PowerShell GitHub repository. This is the official Microsoft Azure repository for sample PowerShell scripts is at github.com/azure/azure-powershell. Like I said, there’s over 600 scripts there and if you ever want to play around PowerShell, you can download from there and then modify that and give that a try.

    Another resource that’s coming to light is called Azure Citadel. This is a resource from Microsoft UK and it contains labs and demos and lots of resources for you to teach yourself Microsoft Azure. Go out, check out Azure Citadel as well.

    Now, I said the Azure User Group is a great place. This is where thousands … We got over 8,000 people in there right now, so thousands of people talk about Microsoft Azure and if you want to learn or you want to share your knowledge, I would definitely recommend you sign up for that.

    Finally, please hit subscribe on this YouTube channel if you found this video useful. Also check out my other videos. There’s lots of other videos relating to Microsoft Azure and so if you want to know about the latest information like this exam on exams or on Azure in general, I would love to have you to check out these videos and to hit subscribe. Anyways, I appreciate you viewing and I hope you have a great day.

  • May 2018 70-532 exam tips | Tips for the Azure Developer Exam

    May 2018 70-532 exam tips | Tips for the Azure Developer Exam

    Here’s some brand new content from the SoftwareArchitect.ca YouTube channel that you might find interesting.

    Here are the latest 70-532 exam tips. I recorded this video this afternoon to talk about the latest tips for the 70-532 exam.

    Perhaps you have questions about the 70-532 developing Microsoft azure solutions exam. Well, in this video, I see what students are saying to study for the exam.

    Quickstart Series: Windows Web App in Azure

    In this video, I show you how to create a Windows Web App in Microsoft Azure. Windows Web App. We go through the Azure Portal, and see how form fields get filled in. If you can’t afford to create resources in Azure, but want to see how it’s done in 2018, this is the video for you.

    Or you can see the video directly on YouTube.

    Transcript:

    Well hello there. Thanks for watching. My name is Scott Duffy and this video is on the latest exam tips for the Microsoft 70-532 exam. This video has been updated for May of 2018. These exam tips have been taken from my Azure students as well as members of the Azure User Group on Facebook, so go ahead and use the link that’s in the description or you can type it into Facebook for Azure User Group. If you find this video helpful, I welcome you to subscribe to this channel and you’ll get more videos like this every week in the future.

    One student took the exam and came back and said there were many questions on Azure Service Fabric as well as containers. Another student mentioned containers as well as Kubernetes, YAML, OpenShift, Cloud Foundry, and 3rd Party Platform as a Service. You’ll notice that these topics are the most recent topics added to the exam. Now the exam has been changed again in March of 2018 but the exam was changed in January and a lot of these topics were added to the exam syllabus in January.

    Another student mentions there was a number of questions using C# as a programming language to interact with the Microsoft Azure environment while he also mentioned you have to understanding Coding Workflow and I’ll get into that in a second. Finally, it’s for the last few months, you’ve been having to know PowerShell and Command Line CLI for interacting with Microsoft Azure resources using the Command Line.

    So to summarize this video, this exam over the past year has become a lot more developer-focused. If you are a working developer and you interact with Microsoft Azure every day, using code, using the Command Line, then you might find a lot of these topics much more comfortable. If you don’t actually interact with Microsoft Azure using the Command Line, if you only ever use the portal, then you might find this a bit challenging. It also seems to be tilting more towards the more modern ways of development using the Cloud, so app services, service fabric and containers are much more common questions than things such as virtual machines and virtual networks. So understanding the software is a service, platform is a service, types of models, is going to be key to this exam in the future.

    When you are a working developer, working with Microsoft Azure, there are certain commands that you use all the time. When you’re establishing a blob, you’re establishing a connection to a storage account, you’re using certain C# commands at the Azure SDK level. In PowerShell when you’re creating new resources or modifying resources, you’re using certain commands. Microsoft has established naming conventions and they do a pretty good job of following them. There’s exceptions from time to time, but I look at a Azure SDK, a PowerShell command for Azure and based on its name you get a pretty good idea of what it does. So they follow a certain logical order for naming these scripts.

    Finally, talking about coding workflows. When you are interacting with Microsoft Azure using code, it oftentimes takes several commands in a row in order to get something done. So for example to create a virtual machine, it’s not just one line of code in PowerShell to create a virtual machine, you’re actually going through eight or nine lines of code in order to generate what’s required for a virtual machine. You should be familiar with those scripts, you should be familiar with the order of operations. Before you can create the virtual machine, you have to create the resource group, you have to create the Azure disk, you have to get the Azure image, et cetera, then you get into creating a virtual machine. So if something does require multiple steps, you should study that and then have an idea in your mind of what the order of the steps are in. Microsoft is famous for not relying so much on multiple choice answers as drag and drop answers, things have to be in a certain order. So those types of questions are ripe for when you’ve got things that require multiple steps.

    Anyways, thanks so much for watching this. I hope it was a little bit helpful. If you are interested in talking about Microsoft Azure generally, I welcome you into the Microsoft Azure unofficial user group on Facebook. We also talk about exam topics. If you want to hear the latest tips or you want to provide tips, but welcome to this group, I would love to have you there and if you find this video interesting and you want to learn more, hit subscribe on YouTube and YouTube will notify you the next time that there are videos available. Be sure and check out other videos on this channel that might be relating to Microsoft Azure or topics that you’re interested in. I want to thank you again for watching and have a wonderful day.

  • TOGAF 9.2 What’s New

    TOGAF 9.2 What’s New

    Here’s some brand new content from the SoftwareArchitect.ca YouTube channel that you might find interesting.

    TOGAF 9.2 What’s New

    In this video, we look at the brand new TOGAF® 9.2 standard that was just released in April 2018, and go over the four main differences from the version 9.1 of the standard.

    Quickstart Series: Windows Web App in Azure

    In this video, I show you how to create a Windows Web App in Microsoft Azure. Windows Web App. We go through the Azure Portal, and see how form fields get filled in. If you can’t afford to create resources in Azure, but want to see how it’s done in 2018, this is the video for you.

    Or you can see the video directly on YouTube.

    Transcript:

    Well hi there. My name is Scott Duffy from Software Architect dot ca and in this video I’m going to talk about the brand new TOGAF 9.2 standard and tell you the differences between that and TOGAF 9.1. If you’re not aware the open group just released the TOGAF 9.2 standard in April of 2018. Now I’ve gone through it and I’m highlighting the differences between that and TOGAF 9.1 for you. So you might be wondering what is the difference. Well I’m going to pull out four things specifically that I’ll talk about today. The four things are number one they’re starting to treat the TOGAF standard as a modular standard or a modular structure so the TOGAF 9.1 standard came up to 650 printed pages and so the TOGAF 9.2 standard is now 500 pages. They’ve been able to pull out 150 pages. Some of those pages have just been removed and some of them have put into other documents that are called TOGAF series guides. To give you an example, the TRM which is a technical reference model and the III-RM, are both now in a series guide and is not part of the core specification.

    Now why are they making it modular? Well first of all there were a few things in there that are examples and they were not part of the core standard so they were putting in reference models and some examples with other standards and it wasn’t really contributing to the standard itself. It was just basically extra content, so they started removing some of this extra content and one of the problems they found with the TOGAF 9.1 standard was that it was so big 650 pages it’s hard to make substantive changes to that. Because it a big monolithic document going in there and starting to make changes, there were just pages and pages, hundreds of change requests that were being submitted and they were just not able to go through and deal with all of this and so they’re breaking up the document into the core standard and into series guides and it’s going to make it easier in the future like if they do come out with the major change, if they come out with TOGAF 10, it’ll be easier to create that if things are modular.

    The second difference between TOGAF 9.2 and TOGAF 9.1 is that they’re starting to make some changes to the way that the business phases are handled and so right now in the TOGAF 9.1 standard you go into the architect’s revision phase and you come up with an architect’s revision, but you’re not really dealing with the business problems. So now, in the architect’s revision phase they’re having things about the business model, defining business capability, et cetera. There’s new artifacts being added to the vision phase and so it’s basically pulling forward some of the discussions of the problems of the business from phase B into phase A which makes sense.

    The third thing that I’ll talk about is if you look at the definitions section for 9.1, there’s already lots and lots of pages devoted to terms. Well 9.2 has added a whole bunch of definitions and so now having a standard set of terms is one of those foundational concepts of the TOGAF standard because having a common language allows us to talk about enterprise architecture and when I say, you know talking about the enterprise you’ll know that the definition of the word enterprise is because that’s defined in the standard. So now there are more definitions that are being standardized. Part of this is because the ISO, the international standards organizations are coming up with architecture documents and they’re standardizing terms in there as well and so basically it’s aligning the TOGAF standard with the ISO 42010 standard for 2011.

    And the fourth thing that I’m going to point out to you is the content meta model. If you’ll recall the TOGAF standard has defined … There’s a diagram which I won’t show you right now, but the diagram that defines the content meta model how all the documents, the processes and things relate to each other within the architecture repository, so now because we’re adding new artifacts into phase A and new artifacts into phase B, splitting up things that are treated as one element within TOGAF 9.1, then there’s a basically some additional changes to the content meta model. New entities on the diagram, revisions of existing entities, and new relationships between those entities and for instance they pulled out location into what’s called a global entity and as we get into the course for TOGAF we’ll talk about content meta model.

    So to be honest, looking over these changes majority of the document, of the 500 remaining pages have not changed. A lot of the chapters have no updates or just some reorganization of the content. I think what the open group is doing is setting itself up to be able to make more substantial changes in the future. So the TOGAF 9.2 standard can be treated like a true minor release of TOGAF, cleaning some things up. Again the big changes that I’ve outlined in this video in terms of content meta model, in terms of phase A and phase B, et cetera, definitions, those are basically some things that have been lingering for a while that have needed to change, but as we get into 2019, 2020, 2021 we should expect that there be other changes to TOGAF that are more substantial to address some of the changes of the businesses going into this last seven eight years a lot of businesses have changed, so expect the standard to change more frequently.

    To summarize this whole video. TL-DR basically they’ve cleaned some things up, fixed some bugs, fixed errors, removed unnecessary content, and they’re basically just setting themselves up for some easier things in the future for making changes of this standard. So this is the first few steps for updating the standard.

  • New Azure UI: Choose VM Size

    New Azure UI: Choose VM Size

    Here’s some brand new content from the SoftwareArchitect.ca YouTube channel that you might find interesting.

    Microsoft has revamped the UI around selecting VM sizes, and it’s about time! The information is now much more compact. Way less scrolling. And it’s easier to find a VM size from among the dozens and dozens of options.

    Quickstart Series: Windows Web App in Azure

    In this video, I show you how to create a Windows Web App in Microsoft Azure. Windows Web App. We go through the Azure Portal, and see how form fields get filled in. If you can’t afford to create resources in Azure, but want to see how it’s done in 2018, this is the video for you.

    Or you can see the video directly on YouTube.

    Transcript:

    Well, hi there. This is Scott Duffy from SoftwareArchitect.ca. In this video I want to highlight brand new interface changes that just went live around creating virtual machines, specifically selecting the virtual machine size. Switch over to the portal. And I took the liberty of filling out the form fields for setting up the virtual machine. So step one really hasn’t changed too much. When I click OK button, it’s going to take me to this Choose a Size screen, and we’re going to see all of the options that Microsoft has.

    Now, you’ll recall that this used to be a grid format with boxes and it took forever to scroll through them, and oftentimes you would miss what you were looking for. Now, there’s still a lot of options. So as I go down this list, you can see ten, twenty, thirty, forty, fifty options. And then, there are options that I don’t even qualify for because there’s a ten CPU limit on this test account that I use. But, if I did increase that limit, I could see another ten or twenty options. And then, there’s things that are no longer available. So this version is not available for my subscription. Again, I could probably message Microsoft to open a ticket with them and they would open this up, if I was to request it. So I can see now much clearer what’s available, what’s unavailable, what’s the pricing, et cetera.

    The other advantages of some of these filters up here. So, if you know in advance that you’re looking for compute optimized versions, well that just filters out everything else and you’re left with the F series. So this makes it a lot easier if you’re looking for compute optimized servers to select the one, you can see the pricing, it all lines up together. So kudos to the Azure team for simplifying how easy it is to select the correct size. So, I just wanted to highlight that out to you. Some of this is changed. We’re talking about availability zones now, et cetera. We’ll get into that in new videos. But I wanted to highlight this size screen being a brand new option for creating virtual machines.

  • Azure Virtual Network Step by Step

    Azure Virtual Network Step by Step

    Here’s some brand new content from the SoftwareArchitect.ca YouTube channel that you might find interesting.

    Azure Virtual Network Step by Step. In this tutorial, I show you how to create an Azure Virtual Network setup. I take you through the fields of the Azure Portal create virtual network screen, and tell you why I am choosing the values I did. We also go into detail about subnets, and create multiple new subnets on the virtual network.

    You’ll see an Azure Virtual Network Gateway Subnet being added, as well as the creation of new Network Security groups. NSGs are important for Azure Virtual Network security.

    At the end of the video, I create a Windows VM to add to the network as a connected device.

    Quickstart Series: Windows Web App in Azure

    In this video, I show you how to create a Windows Web App in Microsoft Azure. Windows Web App. We go through the Azure Portal, and see how form fields get filled in. If you can’t afford to create resources in Azure, but want to see how it’s done in 2018, this is the video for you.

    Or you can see the video directly on YouTube.

    Transcript:

    Hi there, this is Scott Duffy from softwarearchitect.ca and in this video we’re going to create a virtual network and I’ll show you how to do that step-by-step. To start off with, we’re going to go to the top left of the Azure portal, this is portal.azure.com. Hopefully, you already have an account and you can sign up for a free account if you don’t have one. And the first thing we want to do is say create a resource. We’re going to go into the marketplace here, it’s organized by category. We’re looking for a virtual network, so we’re going to choose the networking category and we’re going to choose virtual network, which is the first item. I’m going to minimize this menu to get that out of the way.

    Now, the virtual network screen comes up and we have to give our virtual network a name and I’m going to call it AZNewVnet. Now, you can call this whatever you want, it doesn’t have to be unique to all of Azure, just as long as it’s unique to your own Azure subscription, give it a name that means something to you. The most important decision we have to make when we’re creating a virtual network to start is the size of the address space. By default, Microsoft is offering to me 10.0.0.0/16. This is called CIDR notation, and CIDR notation uses this slash with a number to represent a range of IP addresses. So, Microsoft helpfully shows you at the bottom that 10.0.0.0/16, means that it starts at 10.0.0.0 and goes all the way to 10.0.255.255. This encompasses 65,536 IP addresses. Now, that is quite a lot and the chances are excellent that you’re never going to use all of these addresses on a single virtual network.

    So this might be a bit excessive. If you do have plans of growing your Azure account, creating lots of different resources for lots of different projects, you might want to start to think about protecting your private addresses. So, 26 is a bit excessive, if I change this to 24, then you’ll see here that I’m given 256 addresses from 10.0.0.0 to 10.0.0.255. Now, it’s not actually 256 addresses because Microsoft does reserve five addresses for its own purposes. Actually, I’m going to change this to 23 and I’ll give myself a double the amount of addresses which is 512 in this case.

    My subscription is a pay-as-you-go, you may have the free plan or MSDN or any visual studio or any of the other plans that Microsoft has. You have to create your resources in what’s called a resource group. A resource group is a logical grouping of related resources. It’s used for management, security and billing, things like that. So I would create a resource group. I’m going to give it the same name as the virtual network because this is a demonstration. But if you’re going to create a virtual network and you’re going to create public IP addresses and you’re going to create virtual machines, you might want to put them all into the same resource group and give that a logical name that you’ll know on the billing reports, et cetera, what these resources stand for, who’s going to pay for them, et cetera.

    Microsoft now has up to 50 regions around the world that are available for you to create resources in. Now, some of these regions are government regions and so we can’t create resources in government regions, and some of them are in places like China where we can’t create resources in there either without sending up agreement. But the rest of the world, everywhere from Europe, Asia, South America, North America, Canada, all these other places, we have lots of options available for most of the world, in India even.

    I would choose a that is close to where you are, close to where your users are likely to be. The closer it is then the quicker it’s going to be in terms of response times. The only other consideration is if you’ve got regions that don’t have every service and you’re going to need a specific service, then you may want to choose a different region. So I’m going to click East US2.

    Now, the other important part of virtual networks is a concept called subnets. Subnets are a way of splitting up your virtual network into at least one or more sub networks. The default subnet is called default but you can call it whatever you want. So this could be my front-end subnet. In this subnet, I would place all my web servers and all my public facing services. You have to specify an address range which is a subset of your total address space. So, in this case, I created 512 addresses for the network and this first subnet called front-end is going to take half of them. It’s going to take the 10.0.0.0 to 10.0.0.255. That’s great. So I’m basically splitting my networking to half.

    Microsoft’s also now offering what’s called DDoS protection, Distributed Denial-of-Service protection and you get basic protection for free. Now, basic protection basically provides you what Microsoft can do in terms of protecting your network against Distributed Denial-of-Service attacks, and so it basically does some basic level for ipv4 and ipv6. If a single attacker is throwing a lot of garbage traffic at your resources, you can get basic DDoS protection.

    Standard DDoS protection gives you more options in terms of traffic monitoring, there’s machine learning algorithms that is looking at the traffic, it’s going to apply policies to all of your public IP addresses associated with resources. So if you have load balancers or gateways or service fabric running within this network, then it’s going to provide intelligent policies that will monitor the traffic and take appropriate action if it thinks that you’re under attack. I’m going to leave it as basic for now.

    Service endpoints is also a cool new feature that allows this virtual network to be open directly to other Azure services. It’s just basically establishing a private connection between this virtual network and Microsoft storage sequel database, Cosmos DB or sequel data warehouse. So those are the options in terms of having private networking between your resources and these kind of storage accounts. But this will allow you to do then is basically block, if you wanted to open this up to Microsoft storage for instance, you can block external access to your storage account.

    Now, normally storage is provided like platform-as-a-service, the URL is publicly addressable. The only way you can get access to a storage account is if you have the proper security keys. So it is authenticated, it is protected but the URL and the endpoint is still open. If you were to connect your virtual network into a Microsoft storage account, then you can protect traffic coming into that storage account and actually block it. So it’s more of a firewall protection than just relying on authentication. I’m going to leave this off for now. We’re not going to enable service endpoints but it’s a really cool new feature.

    I’m going to pin this to my dashboard. When I click the create button, it’s going to fire off and create me a virtual network. Now, it does this pretty quickly, but I’m going to pause this video for just a second until it’s completed. All right. So that took under 60 seconds and I have a new virtual network. Now, there are no devices, there’s no nodes or anything on this network. It is a completely untouched network but it’s available to me. If I go into the subnets, I can see the front-end subnet that I created, it used to be called default. It takes up one half of the address space, and remember I said that Microsoft takes five IP addresses for its own uses. So out of 256 addresses, you’re only left with 251 that you can do anything with.

    I’m going to create a second subnet and we’re going to call it backend, and this is where I’m going to put my application servers. I’m going to actually only use … So, instead of using all 255, I’ll only use half of the remainder. So, instead of having 128 addresses, there’s 123 net addresses available for me to use. So I’m creating a second subnet and I still have unused IP addresses in my virtual network. You’ll see here that subnets really are a way of breaking out your network into sub-networks.

    Now, you might see there’s this gateway subnet option at the top. Let me tell you a little bit about that. If you’re going to be creating a virtual private network, the virtual private network uses what’s called a network gateway to connect your own network, if you’re on your own corporation or in your own home, into Microsoft Azure but the gateway needs its own subnet. So, if I want to add a virtual private network to my virtual network, then I would have to start by adding a gateway subnet. There’s no really no options here other than choosing this range of address. It doesn’t need that much but /28 is fine. I could say, okay. I’ll do that and it will add a gateway subnet to my network and that way I can connect a private network to it.

    Now, one thing we didn’t talk about is the security aspect of this. Virtual networks and subnets are where you attach your security to your firewalls. Let’s go into the front-end subnet here and we’ll see that there’s a number of options but one of the options says network security group. Now, I don’t have any network security groups to find in East US 2. So why don’t we go, I’m going to say create network security group. I’ll show you how this works. Network security group. Let’s create a network security group in East US 2. Let’s call this front-end network security group and I’m going to use the virtual network resource group that we created our virtual network on, that way it keeps the resources together.

    We’re going to create the front-end network security group and while I’m here, I’m also going to create a back-end network security group, we’ll deal with both. I will go back here and I say network security group. Network security groups are really the firewall setting for networks. Use existing, new virtual network, East US 2. We’re going to go into our resource groups here. Go into our new virtual network resource group and we can see here that besides our virtual network, we have a front-end network security group that’s also been created.

    Now, network security groups are basically firewalls and they have inbound and outbound rules. The rules are processed in order from lowest priority to the highest and it does come with a number of preset rules. I’m going to switch over to the inbound security rules settings so that we can see them clearer. So there are three rules that come built into it. The first rule, basically, allows any other traffic on the virtual network to travel from other virtual network into our virtual network. This also allows the load balancer traffic to travel into our virtual network and then denies all other traffic.

    So, if I was to apply this front-end never security group rule to our front-end subnet, it would deny all public internet traffic by default. Let’s say then I do want to add HTTP traffic over port 80. So let’s go into the basic set up because it has that for me. I can choose HTTP service, it knows that it’s port 80. It will define that in a low priority number, so number 100 is much below the 65,000, and if I add it, this will then allow port 80 traffic to travel from anywhere into this virtual network. So let’s let that do that. I’m also going to have port 443, which is the secure HTTP channel. So let’s add that. It has to … 443.

    Now I’ve added two network security group rules, one for port 80 and one for port 443. Since I didn’t change this name, it’s a little bit confusing. I can’t change the name. So, I’ve allowed two types of ports to travel from anywhere into this network. Now, if I was to go back to my network security group. So let’s go into the virtual network. Let’s go into the subnet. Let’s go into the front-end and let’s choose the front-end network security group to attach it to the front end subnet. And if I save this, now I am allowing port 80 in port 443 traffic to travel from the public internet into any devices that are attached to the front-end subnet. Right now we don’t have any devices attached to the front-end subnet. We can see the security group.

    If I was to attach the backend security group to the back end network, remember it denies all inbound traffic, only allows traffic from other virtual networks, it allows the load balancer traffic. So, by setting up these security group settings, I am severely restricting traffic to the backend and I am allowing traffic over two ports into the front-end. So that’s how you deal with security at the subnet level. Hopefully, you’re getting a better understanding of how Microsoft Azure deals with virtual networks and specifically with subnets. It is the subnet level that we basically attach devices. Right now there are no devices but if we had one, it would tell us what subnet it’s part of.

    Another thing we should talk about is this concept of peering. It’s a primitively new concept as well within Microsoft Azure. But let’s say that we have some resources in another virtual network or in another subscription or another region of the world, and we want to allow traffic to travel between that virtual network and this virtual network. So peering is the ability to connect two virtual networks no matter where they are within Microsoft Azure. So we have this AZNewVnet. If I was to create another virtual network, then I could choose it and I would allow the traffic to travel between two different virtual networks. Or if I again had a specific virtual network in a different account or somewhere else, then I could put the full resource ID in there and that will allow virtual network traffic to travel between those networks. So that’s a new emerging important concept.

    The last thing we probably talked about is how you would add devices here. So let’s go home and we’re going to create a resource for our virtual network. We’re going to try to be very quick with this, right. I’m going to create a new virtual machine, give it a user ID, put it into the existing v-net resource group. It’s important that the resources exists in the same region, under the same subscription in order for us to connect it to our virtual network. So I’m going to choose the simplest. I have a basic B1 option here, it’s only $17 a month. Remember when we’re getting resources that this is paid by the minute, so even if it’s $17 a month, it’s only 50 cents a day, it’s only two cents an hour. So, if I created this for an hour, I would only be charged two cents. I’m going to skip the other options.

    You’ll see here that it’s automatically filled in our AZNewVnet virtual network, it’s chosen the first default subnet, which is front-end. If I want this virtual machine to exist on this other front end, I can just let it or I can choose to add it to the backend. So right in this option here, I get a chance of either assigning it to the front-end or to the backend. This is how we set this up. Now, the machine itself can have a public IP address. We can choose to have none or we can choose to create a new one. And you’ll notice that it’s asking me to create an network security group. We have the network security group assigned to the subnet, we can also optionally have it assigned to the virtual machines NIC, network card. I’m just going to reuse instead of creating a new network security group. It’s a good practice to allow to reuse security groups as a way of it being a good security practice.

    So, if I’m going to put this in the front-end group, then I’m going to … The other option is I can choose no security group because I know that the front-end subnet has one. So remember, there’s basically two ends of this connection. There’s the subnet connection and then there’s the virtual network interface connection, and I don’t have to have the security group on both. If I just say okay and I say create, this is going to create me a new resource onto my virtual network. Now, there’s a few things that it creates including the network card that are more than just the virtual machine, but that’s how you create a virtual network step-by-step and we even went so far as to create security network, security groups and to add a brand-new Windows virtual machine to this existing network. Thanks a lot guys. I would offer it to you to subscribe to this channel. Please hit subscribe if you want more videos like this or hit thumbs up or share this with your friends.

  • Create SQL Server 2016 on Windows Server 2016 on Azure

    Create SQL Server 2016 on Windows Server 2016 on Azure

    Here’s some brand new content from the SoftwareArchitect.ca YouTube channel that you might find interesting.

    In this video, I create a SQL Server 2016 database running inside a Windows virtual machine, using Microsoft Azure. You can see everything that I do to create it, the settings I chose, and I explain why.

    SQL Server in a VM allows an easy transition from hosting your own SQL Server, with an easy migration path to the cloud.

    Quickstart Series: Windows Web App in Azure

    In this video, I show you how to create a Windows Web App in Microsoft Azure. Windows Web App. We go through the Azure Portal, and see how form fields get filled in. If you can’t afford to create resources in Azure, but want to see how it’s done in 2018, this is the video for you.

    Or you can see the video directly on YouTube.

    Transcript:

    Hi there, this is Scott Duffy from SoftwareArchitect.ca. In this video, we’re going to create a SQL server running in a Windows Virtual Machine in Microsoft Azure. I’ve logged into the Azure portal. I’m going to go to the new resources, the plus sign at the top left. Now I’m going to search the marketplace for SQL Server. I know that I’m looking for the developer edition, which is the free edition. You can see that we have a number of options, but we have the free license of SQL Server 2016, on Windows Server 2016. That’s good enough for me, so this is the one we’re going to select.

    We’re always going to deploy new resources, in the resource manager model, there’s really no reason to deploy to the classic model unless you have a whole bunch of classic resources, and you need to maintain that. So the resource manager model is the way to go. Now I got to create a name for the virtual machine, so I’m going to call it aznewsjdvm. I have to give a username. Now this username is what I’m going to be using to log into the virtual machine using Windows Remote Desktop. I’m going to use my existing subscription, which happens to be pay-as-you-go. If you’re running in the free account, you may have a free subscription, if you’re running MSDN, or you’re Enterprise, you’ll have a different value.

    I have to create a resource group. Out of laziness, I’m going to create the same name as the virtual machine, and we get to choose where in the world we want our virtual machine. Everywhere from Korea and Japan, Europe, India, and Canada, and United States. So I’m going to put this in Central US. I do have the choice of using an existing Windows license, but I don’t have one, so I’m going to say leave that at no, and say okay.

    Now Microsoft has come out with this brand new list of virtual machine sizes, so I like it a lot. I think it’s easier to find virtual machines that fit the needs that you’re looking for. For instance, I know I don’t need anything more than four CPUs, and so I can just drag down this slider and get between one and four CPUs. I can also choose everything from general purpose, memory optimized, storage optimized servers. So maybe for a database server, a memory optimized server would be more useful. Then we can see here that the pricing, just sort of eyeball it down from 200 dollars, 400 dollars, a thousand dollars, seventeen-hundred dollars, et cetera. Now because my account is … I have not upgraded my account, that there are some sizes that are just not available to me, if I said, the mouse over says this size currently unavailable in this location for this subscription. So I would have to open a support ticket with Microsoft and get them to open this up if I wanted the GS size, specifically.

    So I want to pick one of the DS sizes. So I’m going to choose DS 11, which is two CPUs, 14 gigabytes of RAM, and eight data disks. Now there is a cost. You see that it runs around $300 a month, but this is just a test, and it’s not going to last more than a day or two, so it’s going to cost me about $10 to do this test, if I leave it all day. I’m not going to set it up in an availability zone, or using availability set right now. This would be more for if you’ve got high availability needs, you need to have multiple sets of VMs running in availability set. I’ll let them use the manage disks, otherwise I’m going to have to choose storage sizes, and manage that. I’ll just let Microsoft take care of the storage stuff for me. The network is set up as a new network for me, so if I had an existing virtual network, I could install this virtual machine on it, but for this testing purpose, I don’t mind leaving the defaults here.

    You’ll see that I have an option for accelerated networking, and that is the high performance, high throughput networking option, that’s actually enabled for this DS 11. I’m not going to install any extensions for the virtual machine. I could use an extension for metrics, guest operating system metrics, et cetera. Well you see I could just turn it on right here. I do want the auto-shutdown, so it’s around, let’s see, what time is it … it’s around 9:00 right now, so why don’t I set this to turn off at eleven. I’m going to tell it my timezone, and so in two hours from now, this machine will shut down by itself, and I don’t need to be notified. We’ve got monitoring, boot diagnostics, and guest OS diagnostics enabled. The guest OS diagnostics is to give you more than just CPU disk rights and network speed. If you want any more performance diagnostics, you have to turn this on to get that service into Azure. It’s going to create a new storage account for my diagnostics. I am not going to hook it up with Azure Active Directory. I’m going to say okay.

    Now we’re getting into the SQL server settings. You’ll see here that this image that I chose, the virtual machine image, has the SQL server built in. I could have chosen a Windows virtual machine, and installed SQL server using a downloadable image, et cetera, but this is way more convenient. Now one of those first decisions I get to make is how secure I want this to be. I could turn off all outside connection from the machine, so that no other machine can connect to this SQL server, I can allow only virtual network, connect computers to connect to it, or I could open it up to the public, which includes myself, and my own computer. I’m going to leave this open to the public. This is typically not a great idea, and you’re going to want to set very specific network security group security on this, maybe specific IP address, or a specific range, but this is just a temporary test. Like we said, it’ll only last for a couple of hours.

    We do need to enable SQL authentication. That’s the only way that we can log into SQL server over the open internet. It does not support Windows authentication over the internet. So that’s turned on. It’s going to take my Windows username and password as the username and password for SQL authentication. We can leave the storage options, the way that it does patching, backups, Azure key vault, et cetera. R Services, which is advanced analytics, typically used in big data, et cetera. So I’m going to leave all the defaults from that point, and say okay.

    Now Microsoft Azure will do the final calculations. It’s telling me that a standard DS 11 V2 plan, with the free version of SQL server, developer edition, will run me 40 cents Canadian per hour. So I know that I’m incurring this charge, as soon as I start it up. This 40 cents per hour is charged to the nearest minute, so rounded down. So if I run it for even just for five minutes, I’m going to get four or five cents charge for this configuration. I can now say create, and Microsoft will go off and create me a new virtual machine running SQL Server 2016, running Windows Server 2016. I’m going to pause the video, and we’ll let this machine boot up.

    All right, well that took a few minutes because Microsoft Azure has a bunch of things to do. Actually, if I go up to the resource group, you’ll remember that we created this resource group brand new, and now we can see that it’s actually created 11 resources within that resource group, so besides the virtual machine itself, it’s created a couple of disks, it’s created the network interface, a storage account for diagnostics, and IP address, and all that wonderful stuff. So let’s go into the virtual machine. We can see here, on-screen, that it has a public IP address. Now it is a SQL server, so I would have to connect to it using SQL Server’s management studio, which I can do, and we can see the overview here, with CPU, Network. This is a fairly powerful box, I mean it’s two CPUs, not a screaming powerful box, but 14 gigabytes of memory. So it didn’t take too long to start up. The CPU is running around 50% average, in this time, so it’s probably still doing some stuff, but right now it’s down in the 6% range.

    So let’s connect to this using SQL Server Management Studio, and show you that we have a database now, running within Microsoft Azure. So I started SQL Server Management Studio on my local machine. This is something that you do have to download and install, if you don’t have. I entered the public IP address of this server, and the username and password based on SQL Server authentication, so I should be able to click connect, and you can see here that it’s connected to the machine, and it successfully logged in. Now I don’t have … this is a brand new machine. There are no user databases. Only the four default system databases that we all know and love. So this is a machine ready for me to start developing against it, or to import my database from another server, et cetera.

    So that’s how you create SQL Server, running within Microsoft Azure, using a Windows Server 2016 virtual machine. Hopefully that was interesting to you. You will see that it wasn’t too difficult. The only painful part, if anything, is having to pay for it, because like we said, it’s going to cost me 40 cents per hour, and that’ll add up to a couple of hundred, almost $300 over the course of a month, so this is for a business purpose, hopefully, and you’re going to save money by not having to purchase a machine, not having to purchase SQL Server, and have that running within your own hosting environment.