Monthly Archives: May 2019

Azure SQL Data Warehouse:

Category : Uncategorized

This video is talking about “Azure SQL Data Warehouse”
and How to use the Azure portal and SSMS (SQL Server Management Studio) to:
1) Create a data warehouse in the Azure portal
2) Set up a server-level firewall rule in the Azure portal
3) Connect to the data warehouse with SSMS

Azure SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages MPP (Massively Parallel Processing) to quickly run complex queries across petabytes of data.
Use Azure SQL Data Warehouse as a key component of a big data solution.
Import big data into SQL Data Warehouse with simple PolyBase T-SQL queries, and then use the power of MPP to run high-performance analytics.

Watch below video for complete steps of “How to Create SQL Data Warehouse in Azure Portal and Connect to the data warehouse with SSMS”.




SQL Server Always On AG Configuration – Part3- Join Nodes in Domain:

Category : Uncategorized

In this video, we will learn How to join nodes to domain and Enable .Net framework 3.5 & Failover Clustering Features.

There are 2 steps to join nodes in domain:
1) Configure Static IP for Public Network along with Domain Controller IP as DNS server on both nodes:
2) Add nodes in Domain.

Now Enable .Net framework 3.5 & Failover Clustering Features:on node1
Open The Server Manager and Select “Add Roles and Features” option.
On Before You Begin page – do next
In Installation type select default option “Role-based or Feature-based installation and – do next
On Server Selection page “verify Destination server name” and do next
on Server Role page Select Application Server Role and click Next
ON Feature page Select all options under “.NET Framework 3.5 Features” and “Failover Clustering” options and do Add feature.
and click Next
………….

For Complete process and steps watch below video “How to join nodes to domain and Enable .Net framework 3.5 & Failover Clustering Features”


SQL Server Always On AG Configuration – Part2- Create Domain Controller:

Category : Uncategorized

We have created 3 VM servers in Previous video “SQL Server Always On AG Configuration – Part1- VM Creation Steps”.
In this video, we will learn “How to Install Active Directory Domain Services”.

Steps are:
i) Create Active Directory Domain Service.
ii) Create user that you can use as Domain admin.
iii) Create Forward Lookup Zone.
iv) Create Reverse Lookup Zone.

Watch below video for complete all steps about “How to Install Active Directory Domain Services”.



SQL Server Always On AG Configuration – Part1- VM Creation Steps:

Category : Uncategorized

Here I am going to Start a new series “SQL Server Always On Availability group Configuration” . This series will complete in 6 Parts. For SQL Server Always On Configuration, we will going to use : SQL Server 2017 Developer Edition and Windows Server 2012 R2 Standard Edition.

Steps to configure SQL Server Always On Availability group are:
1) Create VM Servers:
2) Install Active Directory Domain Services in Windows server 2012 R2:
3) Join Both nodes to Domain, Enable .Net framework 3.5, Failover Clustering Features and Application Server Role.
4) Install SQL Server 2017 & SSMS:
5) Failover Cluster Validation and Cluster Creation:
6) Then finally Configure SQL Server 2017 Always On Availability Groups:

So in this 1st video we have explained “How to create VM Machine” and create nodes for Always On configuration.
Steps are:
i) Create Virtual Machine node.
ii) Verify Machine Settings and change the few settings.
iii) Install Windows Server 2012 R2.
iv) Install Guest Addition
v) Change Computer Name as meaningful name.
vi)Turn off User Access Control (UAC)
vii) Disable Firewall
viii) Configure IP’s

Watch below video for complete 8 steps about “How to create VM Machine” and create nodes for Always On configuration.




Design a Relational Single database within Azure SQL Database:

Category : Uncategorized

Use the Azure portal and SQL Server Management Studio (SSMS) to:

1) Create a single database using the Azure portal
2) Set up a server-level IP firewall rule using the Azure portal
3) Connect to the database with SSMS
4) Create tables with SSMS
5) Bulk load data with BCP
6) Query data with SSMS

Prerequisites:

We need to download and install SSMS and BCP and SQLCMD tools to complete the configuration of Azure SQL database.
SQL Server Management Studio (18.0 -Latest version):
BCP and SQLCMD (MsSqlCmdLnUtils.msi)

Watch below video for complete 6 steps about “How to Design a Relational Single database within Azure SQL Database”:


How to Create Azure SQL Database:

Category : Uncategorized

Azure SQL Database is a relational database-as-a-service (DBaaS) hosted in the Azure cloud that falls into the category of Platform-as-a-Service (PaaS).


Azure SQL Database is a fully managed Database Engine that handles most of the database management functions such as upgrading,patching, backups, and monitoring without user involvement.

Microsoft Azure provides, three deployment options for an Azure SQL database:
i) Single database:
ii) Elastic pool:
ii) Managed instance:

Login on Azure portal and create a Azure SQL Database:
1) Sign into the Azure portal.
2) Click on Create a resource. Select Databases and then Click on SQL Database.
3) Go to the Basics tab, and Project Details section: Select Subscription and Resource group
4) In the Database Details section:
Choose the database Name
Create new Server:
Select Compute + storage then click Apply
5) Select the Additional settings tab.
In the Data source section, under Use existing data, Choose default ” None” and start with Start with a blank database. 6) When the process completes, click Pin to dashboard to pin your database server to the dashboard so that you have quick access when you need it later.
7) Query the database.

Watch below video for complete steps about “How to Create Azure SQL Database”.



Create a Virtual Machine with SQL Server in Azure:

Category : Uncategorized

SQL Server on Azure Virtual Machine enables you to use full versions of SQL Server in the Cloud without having to manage any on-premises hardware.
Azure virtual machines offer a variety of machine sizes. You can choose machine size as per your workload. 
We will discuss machine size during our virtual machine creation.
The virtual machine image gallery allows you to create a SQL Server VM with the right version, edition, and operating system. 
In this demo we will “Create a SQL Server 2017 Developer Edition on Windows Server 2016 virtual machine in the Azure portal”.

Steps are:

1) Go to Azure portal: https://portal.azure.com and login by using your Microsoft account.
2) In the Azure portal, Click on Create a resource.
3) In the search field, type SQL Server 2017 Developer on Windows Server 2016, and press 
4) Now Select the “Free SQL Server License: SQL Server 2017 Developer on Windows Server 2016” image.
5) Click on Create.
It will create a virtual machine that runs Windows Server 2016.

Then you need to provide the basic details like New Resource Group, Virtual machine name, Azure Region and many others to deploy the SQL Server on Virtual machine.

Watch below video for complete steps to Create Virtual Machine with SQL Server in the Azure portal i.e “SQL Server on Azure Virtual Machine”.


Search

Archives