Find the best tutors and institutes for Microsoft Training

Find Best Microsoft Training

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Search for topics

Microsoft Training Updates

Ask a Question

Post a Lesson

All

All

Lessons

Discussion

Lesson Posted on 06 Aug IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/SQL Server IT Courses/MS SQL/MS SQL Administration IT Courses/MS SQL/MS SQL Certification +1 IT Courses/MS SQL/MS SQL General less

Troubleshooting SQL Server Agent failed Jobs - Common daily routine work for DBA

Meetopus

Meetopus is into creating talent expert and recruitment business. We have tie up with top Organization...

If you are lazy and not intended to do repetitive manual work at a routine time, then SQL Server Agent job help you achieve this. SQL Server agent jobs help to automate the execution of the recurring task in the SQL Server database at a scheduled time. It is important that DBA should have a clear idea... read more

If you are lazy and not intended to do repetitive manual work at a routine time, then SQL Server Agent job help you achieve this. SQL Server agent jobs help to automate the execution of the recurring task in the SQL Server database at a scheduled time. 

It is important that DBA should have a clear idea about how to troubleshoot when the job gets failed.

SQL Agent can automate the execution of multiple tasks in a single or by creating multiple jobs. Below are few things which SQL Agent job can handle or categorise. 

1. Execute TSQL Query

2. Execute Maintenace Plan (SSIS) 

3. SSIS Package 

4. Execute Powershell script.

5. Database Integrity check

6. Replication agent

7. Log-shipping

 

How DBA can help resolve or troubleshoot the failure of SQL Jobs?

  1. DBA should use Job activity
  2. Check for last run status 
  3. Find out the error resulting in failure. 

 

Some common reason for job failure

1. Insufficient Permission provided to the job owner.

2. Script error / Incorrect syntax /Object missing/ Source file missing

3. Primary foreign key relation error 

4. Deadlock/Blocking 

5. Insufficient space on the drive

6. Restricted growth of database (data, Log file)

7. Linked server permission issue

8. LSN mismatch in case of log shipping

 

If you are not able to find the error, you should add logging to the job which can be done in advance setting on job steps. Apart from the listed error, DBA should check the SQL Server Error log to find the RCA.

read less
Comments
Dislike Bookmark

Lesson Posted on 06 Aug IT Courses/MS SQL/MS SQL Administration IT Courses/MS SQL/MS SQL Certification IT Courses/MS SQL/MS SQL General +2 IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/SQL Server IT Courses/MS SQL less

What is database backup? How backup works in SQL Server?

Meetopus

Meetopus is into creating talent expert and recruitment business. We have tie up with top Organization...

Database Backup in normal terms can be said as a copy of data which can be used in a situation when the things go wrong with your system/server. If your role is IT/Database Administrator, then it is your responsibility to safeguard the data from any disaster apart from critical security. MS SQL Server,... read more

Database Backup in normal terms can be said as a copy of data which can be used in a situation when the things go wrong with your system/server. If your role is IT/Database Administrator, then it is your responsibility to safeguard the data from any disaster apart from critical security.

MS SQL Server, unlike another database system, has the ability to take the backup which can be used during disaster recovery. SQL Server allows the database user to decide and take backup based on the business strategy (RPO) Recovery point objective and (RTO) Recovery Time Objective. 

Based on the fact to recover the database till the point of recovery SQL Server has a different type of database recovery model and backup type.

  • Full or Database
  • Differential or Incremental
  • Transactional Log or Log.

Full database backup – Backs up all the data and objects in the data file(s) for a given database.

Differential database backup – Backs up any data and objects in the data file(s) for a given database that have changed since the last full backup. Remember that a differential backup backs up data since the last full backup, even if there have been intervening differential backups.

Transaction log backups – Copy into a backup file all the log records inserted into the transaction log LDF file since the last transaction log backup.

Apart from above type of backup. SQL Server has below backups 

  • File and filegroup backups - File and filegroup backups back up individual database files and filegroups rather than performing a full database backup. This method backs up very large databases. You must back up the transaction log when performing a file and filegroup backup. You cannot use this method if the Truncate Log On Checkpoint option is enabled.
  • Copy-only backups - Copy-only backups are functionally the same as a full database or transaction log backups but do not affect the backup sequence. For example, if you took a full backup, a copy backup, and then a transaction log backup, all the transaction logs since the full backup would be backed up, and the existence of the copy backup would be ignored. Copy backups cannot be used as the basis for a differential backup or transaction log backup.

Happy Learning

Meetopus

read less
Comments
Dislike Bookmark

Lesson Posted on 06 Aug IT Courses/MS SQL/MS SQL Administration IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/SQL Server IT Courses/MS SQL/MS SQL Certification +1 IT Courses/MS SQL/MS SQL General less

Why Windows Administration knowledge is required for SQL DBA.

Meetopus

Meetopus is into creating talent expert and recruitment business. We have tie up with top Organization...

As the RDBMS system runs on the windows server operating system and for most of its function is depended on windows OS. Hence SQL DBA should know the basic windows to review various services, events and errors. Below are the some Windows components you should know if you are starting your career as... read more

As the RDBMS system runs on the windows server operating system and for most of its function is depended on windows OS. Hence SQL DBA should know the basic windows to review various services, events and errors.

Below are the some Windows components you should know if you are starting your career as SQL Server DBA.

  • Remote Desk Top
  • Windows Service
  • File System
  • Active Directory
  • Managing Local Users and Group
  • Local Security Policy
  • Disk Management
  • ODBC Administration
  • Event Viewer

Happy Learning

Meetopus

read less
Comments
Dislike Bookmark

Looking for Microsoft Training

Find best Microsoft Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 13 Jul IT Courses/Microsoft Training/Microsoft Azure Training

Azure Course Content

Shubham Garg

I am giving online tuition in various subjects from past 2 years. Knowledge is biggest assets of any...

Microsoft Azure Course Content Lesson 1: Introduction to Azure Overview of On-premise infrastructure The transition from On-premise to datacenter housing & managed data centres and finally to cloud Overview of Cloud deployment models Overview of Azure accounts and subscriptions Overview... read more

Microsoft Azure Course Content

 

Lesson 1: Introduction to Azure

  1. Overview of On-premise infrastructure
  2. The transition from On-premise to datacenter housing & managed data centres and finally to cloud
  3. Overview of Cloud deployment models
  4. Overview of Azure accounts and subscriptions
  5. Overview of different admin roles - Account admins, Service admins and Co-Admins
  6. Overview of different Azure portals
  7. Azure account creation through Microsoft or Organization account.
  8. Managing Azure through the Azure portal
  9. Managing Azure through Azure Powershell
  10. Azure Powershell basics

 

Lesson 2: Implementing and Managing Azure Networking

  1. Overview of Azure networking and Vnet solutions
  2. VNET implementation using the Azure portal
  3. Network COnfiguration file
  4. Affinity group and regional VNET
  5. Azure DNS and its requirement
  6. Azure Addressing
  7. Cross-premises connectivity overview
  8. Implementing Point to Site VPN gateway
  9. Implementing Site to site VPN gateway using VNET to VNET gateway
  10. VNET Peering
  11. Express routing in Azure
  12. VPN vs IP VPN

 

Lesson 3: Planning and implementing Azure Data services - Storage, Backup and Recovery

  1. Overview of Azure Data services.
  2. Azure storage account and creation
  3. Azure storage account Redundancy models
  4. Azure Storage account types
  5. Overview and Implementation of Blob Storage through portal and PowerShell
  6. Overview and Implementation of Table Storage through portal and PowerShell
  7. Overview and Implementation of Queue Storage through portal and PowerShell
  8. Overview and Implementation of File Storage through portal and PowerShell
  9. Overview of Azure Backup and Backup Vault
  10. Azure Backup components and differences between these components
  11. Implementing Azure Site Recovery

 

Lesson 4: Planning and implementing Azure SQL database

  1. Overview of Relational database.
  2. Types of RDP service offering from Azure - IAAS and PAAS based
  3. Azure SQL Database - Service Tiers
  4. Overview of performance metrics
  5. Implementing the Azure SQL database - Creation, security and monitoring\
  6. Migration of MS SQL server database to Azure SQL database
  7. Restoring a database
  8. The provision, configure and manage the Azure SQL Database data­management service.
  9. Manage data recovery and availability for Azure SQL Database.

 

Lesson 5: Implementing Azure Cloud service

  1. Overview of Azure ASM model/Classic model
  2. Planning and deploying Azure cloud services
  3. Managing and maintaining cloud services
  4. Configuring deployment slots and Remote Desktop Protocol.
  5. Monitoring Cloud service
  6. Configure PaaS cloud services by using configuration files or the Azure portal.
  7. Differences between ARM and ASM deployment models

 

Lesson 6: Implementing and managing Virtual machines

  1. Overview of IaaS v2 virtual machines
  2. Planning and deploying for Azure virtual machines
  3. Authoring Azure Resource Manager templates
  4. Using Azure PowerShell and an Azure Resource Manager template to deploy virtual machines
  5. Implementing desired state configuration.
  6. Implementing storage space–based volume
  7. Implementing Azure load balancers]

 

Lesson 7: Implementing Azure App services

  1. Introduction to App Service
  2. Planning app deployment in App Service
  3. Implementing and maintaining web apps
  4. Configuring web apps
  5. Monitoring web apps and WebJobs
  6. Overview and implementation of Traffic manager
  7. Select an App Service plan and deployment method for apps in Microsoft Azure
  8. Use Microsoft Visual Studio, File Transfer Protocol (FTP) clients, and Azure PowerShell to deploy web and mobile apps to Azure
  9. Configure web apps and use the Azure WebJobs feature to schedule tasks.
  10. Use Azure Traffic Manager to distribute requests between two or more app services.

 

Lesson 8: Implementing the Azure Active Directory

  1. Creating and managing Azure AD tenants
  2. Configuring application and resource access with Azure AD
  3. Overview of Azure AD Premium
  4. Administering Active AD
  5. Configuring SSO
  6. Configuring Multi-Factor Authentication
  7. Configuring SSO from a Windows 10–based computer that is joined to Azure AD
  8. Extending on-premises Active Directory domain to Azure
  9. Implementing directory synchronisation by using Azure AD Connect
  10. Implementing federation
  11. Configuring directory synchronisation

 

read less
Comments
Dislike Bookmark

Lesson Posted on 13 Jun IT Courses/Microsoft Training/Microsoft Azure Training IT Courses/Microsoft Dynamics Course IT Courses/MS Dynamics CRM

OAuth Authentication (without using ADAL) to Dynamics 365 using Azure Apps

Jayakar Reddy

? Implementation of MSCRM 2011, 2013, 2015,2016 and Dynamics 365 ? Customizing MSCRM 2011, CRM 2013,...

Here I am going to show without using ADAL(active directory authentication library) how to get the authentication token and how to connect to CRM from a standalone HTML Page using the web-API. I will not explain in detail about how to register an APP in azure and give it access to Dynamics CRM. Use... read more

Here I am going to show without using ADAL(active directory authentication library) how to get the authentication token and how to connect to CRM from a standalone HTML Page using the web-API.

I will not explain in detail about how to register an APP in azure and give it access to Dynamics CRM.

Use below code to get the OAuth token once you’re done with Azure app registration

var microsoftTokenUrl = "https://login.microsoftonline.com/4060bfe9-7199-xxxxxxx-xxxxxxx/oauth2/token"; //Add your endpoint URL
var clientId = "xxxxxxxx-9715-xxxx-xxxx-3a1fac0cc5fe"; // Add your app ID
var clientSecret = "xxxxxxMJTQmtu4V73cRyduZ6vS40AlkAtSxxxxxxx";//Add your Secret Key
var resource = "https://xxxxxxx.crm5.dynamics.com";//Add your CRM Url
var grantType = "client_credentials";
function GetAuthroisationToken() {
var token=null;
$.ajax({
url: microsoftTokenUrl,
type: "POST",
contentType: "application/x-www-form-urlencoded",
crossDomain: true,
dataType: "json",
async: false,
data: {
'resource': resource,
'client_id': clientId,
'client_secret': clientSecret,
'grant_type': grantType
},
beforeSend: function (XMLHttpRequest) {
XMLHttpRequest.setRequestHeader("Accept", "application/json");
},
success: function (data, textStatus, xhr) {
token= data.access_token;
},
error: function (xhr, textStatus, errorThrown) {
alert(textStatus);
}});
return token;
}

Here is the sample code to create the lead in CRM (Design your HTML as your wish)

var entity = {};
entity.subject = $("#subject").val();
entity.firstname = $("#fname").val();
entity.lastname = $("#lname").val();
var salutation = $("#title option:selected").val();
entity.address1_postalcode = $("#postalcode").val();
entity.address1_city = $("#city").val();
entity.address1_stateorprovince = $("#state").val();
entity.address1_country = $("#country").val();
entity.address1_line1 = $("#address").val();
entity.emailaddress1 = $("#email").val();
entity.telephone1 = $("#phone").val();
entity.companyname = $("#company").val();
entity.jobtitle = $("#function").val();
entity.leadsourcecode = 8;
var token = GetAuthroisationToken();
if(token!=null)
webApi_Create("leads", entity, false,token);
function webApi_Create(entityName,entityObject,isAsync,token)
{
var newEntityId = null;
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
datatype: "json",
url: resource + "/api/data/v8.2/" + entityName,
data: JSON.stringify(entityObject),
beforeSend: function (XMLHttpRequest) {
XMLHttpRequest.setRequestHeader("OData-MaxVersion", "4.0");
XMLHttpRequest.setRequestHeader("OData-Version", "4.0");
XMLHttpRequest.setRequestHeader("Accept", "application/json");
XMLHttpRequest.setRequestHeader("Authorization", "Bearer " + token);
},
async: isAsync,
success: function (data, textStatus, xhr) {
var uri = xhr.getResponseHeader("OData-EntityId");
var regExp = /\(([^)]+)\)/;
var matches = regExp.exec(uri);
newEntityId = matches[1];
if (newEntityId !== null)
alert("Record Created!");
},
error: function (xhr, textStatus, errorThrown) {
alert(textStatus + " " + errorThrown);
}
});
return newEntityId;
}

 
 
read less
Comments
Dislike Bookmark

Answered on 26 Jun IT Courses/Microsoft Training/Microsoft Azure Training IT Courses/Microsoft Training/Windows IT Courses/VMware Training

People who are eagarly looking to scale up your skills with "Microsoft Azure". Please connect with me. I... read more
People who are eagarly looking to scale up your skills with "Microsoft Azure". Please connect with me. I will get you a way how to approach, how to study, how to build a home lab, Live migrations, Complete Azure Infra with PaaS, trust me I will give remarkable corporate training. Many thanks and looking forward to meeting you guys! read less

Gyanvriksh

Thank you Mr. Surya for your interest. Please contact our Institute Director Mr. Sunil directly to discuss. Thank you
Answers 1 Comments
Dislike Bookmark

Looking for Microsoft Training

Find best Microsoft Training in your locality on UrbanPro.

FIND NOW

Asked on 31 May IT Courses/Microsoft Training/Microsoft Dynamics NAV

Sec (90×1+30)

= - Cosec30

= - 2

Answer

Answered on 31 May IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft SharePoint

I want to know the difference between SharePoint designer and SharePoint administrator. Please, can... read more
I want to know the difference between SharePoint designer and SharePoint administrator. Please, can anyone explain me the difference? read less

Chandra Moorthy D

Trainer

SharePoint designer is the person who determines the branding of the whole site.. mostly developer does this job. SharePoint admin is the person who maintains the environment on which SharePoint is installed, server maintenance, health monitoring and so on.. Microsoft designer is also a name of... read more

SharePoint designer is the person who determines the branding of the whole site.. mostly developer does this job.

SharePoint admin is the person who maintains the environment on which SharePoint is installed, server maintenance, health monitoring and so on..

 

Microsoft designer is also a name of the tool for SharePoint.. but that is a different cade

read less
Answers 1 Comments
Dislike Bookmark

Answered on 09 Jun IT Courses/Microsoft Training/Microsoft Azure Training IT Courses/IT Automation/Ansible

I am looking for Hashicorp Terraform training for Azure.

Surya

Please contact me
Answers 1 Comments
Dislike Bookmark

Looking for Microsoft Training

Find best Microsoft Training in your locality on UrbanPro.

FIND NOW

Answered on 19 Apr IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI

Ramesh KN

Corporate Trainer

No need to have SSAS knowledge Kumar, but you need to have good knowledge of Excel operations and Pivot table, chart creations as Power BI uses lot of Excel features. Additional knowledge of any RDBS(though not mandatory) will be an added plus. Ramesh (Power BI Consultant)
Answers 9 Comments 1
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best Microsoft Training in India. Post Your Requirement today and get connected.

Overview

Questions 45

Lessons 50

Total Shares  

+ Follow 4,464 Followers

Related Topics

Top Contributors

Connect with Expert Tutors & Institutes for Microsoft Training

x

Ask a Question

Please enter your Question

Please select a Tag

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more