SqlServer 2016 Virtual Machine Setup In Microsoft Azure.

Azure VMs provide a way to move your on-premises SQL Server workloads and applications to the Cloud.

There are many reasons that you might choose to host your data in Azure. If your application is moving to Azure, it improves performance to also move the data. But there are other benefits. You automatically have access to multiple data centers for a global presence and disaster recovery. The data is also highly secured and durable.

Find step-by-step guidance for this process in the tutorial, Provision a SQL Server virtual machine in the Azure portal.

1.Login on azure portal by using your  Microsoft azure account. if you not have any azure account then you may use Microsoft azure trial.



2. look for virtual machines option from the left blade and and click on it.Now click “Add” option and select sqlserver virtual machine from all available images.A2.PNG

Now All available images will come in new pane and you have select sqlserver 2016 image.


3. Under Select a deployment model, verify that Resource Manager is selected. Resource Manager is the recommended deployment model for new virtual machines. Click Create.


Configure Virtual Machine

There are five important steps to configure the virtual machine as per below:


1.Configure Basic Settings:

Provide following information on basic configure tab:

  • Provide Unique Virtual Machine Name.
  • User name for the local administrator account on the VM.
  • Provide a strong Password.
  • Select Subscription what ever you have.
  • In the Resource group box, type a name for a new resource group. Alternatively, to use an existing resource group click Select existing.To know more about resource group.https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-overview
  • Select a Location for this deployment.
  • Click OK to save the settings.


2. Select Virtual Image Size:

There are lot of virtual images size available on azure portal. Initially most recommended images comes on screen and you can  select any other image size which is most appropriate for you.


3.Configure optional features:

On the Settings blade, configure Azure storage, networking, and monitoring for the virtual machine.A8.PNG

4.Configure sql server settings:

Sql server configurations is important section of virtual machine setup,here you have to configure various type of settings like Authentication,Network connectivity.

  • Public (internet) to allow connections to SQL Server from machines or services on the internet. With this option selected, Azure automatically configures the firewall and the network security group to allow traffic on port 1433.
  • Local (inside VM only) to allow connections to SQL Server only from within the VM.
  • Private (within Virtual Network) to allow connections to SQL Server from machines or services in the same virtual network.
  • If you require SQL Server Authentication, click Enable under SQL authentication.Under Sql authentication you have to specify username and password.

Here i am going with public network with Sql authentication.


5. Summary:

this is last step of virtual machine configuration and here you only have to review all the steps activity from step 1 to step 4.If all the things are good then click ok. Now your Sql Server machine setup is complete and ready to use.


Click again on virtual machine option in left blade of screen and now you can see your newly created sql server machine is listed.


Connect virtual machine with Remote Desktop

Use below steps to connect VM with remote desktop:

  • Click on your new SQL virtual machine. A Virtual machine blade displays your virtual machine details.
  • At the top of the Virtual machine blade, click Connect.
  • The browser downloads an RDP file for the VM. Open the RDP file.


Once you have opened .RDP file,you have to enter your username and password. These are the same username and password which was specified in Sql authentication.


Once you have entered correct username and password then you will navigate to your virtual machine.


After you connect to the SQL Server virtual machine, you can launch SQL Server Management Studio and connect with Windows Authentication using your local administrator credentials. If you enabled SQL Server Authentication, you can also connect with SQL Authentication using the SQL login and password you configured during provisioning.





What is TypeScript and why would we use it in place of JavaScript?


It’s never been a better time to be a JavaScript developer! JavaScript is everywhere now – it’s on the front and back-end of a website, and many desktop text editors are powered by JavaScript. In fact you can build a whole range of desktop applications using web technologies as their foundation.

TypeScript is a Superset of JavaScript.

TypeScript: Making .NET Developers Comfortable with JavaScript

“.TS” is TypeScript File Extension as similar to java script file extension “.Js”.

TypeScript is a free and open-source programming language developed and maintained by Microsoft. It is a strict superset of JavaScript, and adds optional static typing and class-based object-oriented programming to the language.TypeScript may be used to develop JavaScript applications for client-side or server-side (Node.js) execution.

TypeScript is designed for development of large applications and transcompiles to JavaScript.[7] As TypeScript is a superset of JavaScript, any existing JavaScript programs are also valid TypeScript programs.

TypeScript adds common concepts such as classes, modules, interfaces, generics and (optional) static typing to JavaScript. All JavaScript code is valid TypeScript code so it can be added seamlessly to any project. The TypeScript compiler emits JavaScript.

Installing TypeScript

There are two main ways to get the TypeScript tools:

  • Via npm (the Node.js package manager)
  • By installing TypeScript’s Visual Studio plugins

Visual Studio 2015 and Visual Studio 2013 Update 2 include TypeScript by default.

For NPM users:

Open Command prompt and execute below command.It will take some time to download and install all required assemblies.

npm install -g typescript



Now Validate the setup process by executing Tsc command on same command prompt.


Supportive tools for TypeScript:


Benefits of typescript:

  • Due to the static typing, code written in TypeScript is more predictable, and is generally easier to debug.
  • Makes it easier to organize the code base for very large and complicated apps thanks to modules, namespace and strong OOP support.
  • TypeScript has a compilation step to JavaScript that catches all kinds of errors before they reach runtime and break something.
  • The upcoming Angular 2 framework is written in TypeScript and it’s recommended that developers use the language in their projects as well.

For more details please refer https://www.typescriptlang.org/docs/tutorial.html

TypeScript PlayGround:

Type Script Playground is online tool for developing and testing typescript programs without installing any external tools.It automatically translate type script to java script.




Some important features of TypeScript:

  1. TypeScript Code is Converted into Plain JavaScript Code
  2. Data Types
  3. Classes
  4. Access Modifiers and Properties
  5. Static and Instance Members
  6. Function Overloading
  7. Constructors
  8. Inheritance
  9. Interfaces
  10. Modules
  11. Type Annotation
  12. Generics
  13. Type inference
  14. Tuple
  15. Await

Since TypeScript generates plain JavaScript code you can use it with any browser. Overall TypeScript is a promising language  that can certainly help you neatly write and organize your JavaScript code base making it more maintainable and extensible.