Configure PSTN Conferencing for Office 365 Skype User - Step by Step Guide

Configure PSTN Conferencing for Office 365 Skype User - Step by Step Guide

• PSTN Conferencing facility allows users to dial in to Skype Conference without the need to have internet access.Users can dial-in from there traditional Phone and attend the Skype Conference.
• Today we will see the step by Step guide to achieve it.

Step by Step:

• Login to Office 365 portal as tenant administrator.

• 
  

Install Bash Shell on Windows to Execute Linux Commands from Windows

Install Bash Shell on Windows to Execute Linux Commands from Windows

• To install Bash,your PC should be running a 64-bit version of Windows 10 Anniversary Update build 14393 or later
• Now Open Settings -> Update and Security -> For developers
• Select the Developer Mode radio button

• Then from Start, search for "Turn Windows features on or off" (type 'turn')
• Select Windows Subsystem for Linux (beta)

• Click OK
• Now Open a PowerShell prompt as administrator and run:

Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Windows-Subsystem-Linux

• Restart your computer when prompted

Install Azure CLI 2.0 on Apple mac OS Step by Step Tutorial

Install Azure CLI 2.0 on Apple mac OS Step by Step Tutorial

• To install Azure CLI on your Mac OS type the following command

curl -L https://aka.ms/InstallAzureCli | bash

• Then restart your command shell for some changes to take effect.

exec -l $SHELL

Create Linux VM Using Powershell in Azure

Create Linux VM Using Powershell in Azure

• Azure is the leading Cloud Platform today.
• Lot of Customers are having a Hybrid setup with Cloud.
• So With power shell now so famous lot of companies have deployed Azure CLI 2.0 to extend thier powershell skill in Cloud.
• In Order to Create a Linux VM in cloud using powershell and CLI2.0 installed on you system use this command

az vm create -n LINUX01 -g LinuxGroup --image UbuntuLTS

• This will create the Linux Machine called "LINUX01" with Ubuntu OS

What is Row Level Security or RLS

1. Row Level Security is a new feature in SQL 2016.

2. It give access control at the Row Level in the Database

3. Now you can store information of different customers using RLS in the same table.

4. This is achieved by SESSION_CONTEXT Column where the User ID is stored.

5. This acts as a filter where User see rows only assigned to his UserID

SCCM Query find All Server count with OS Name

SCCM Query find All Server count with OS Name

• Recently I was asked to count of servers by OS
• It was quite Challenging as we need to understand the SCCM Structure very well to do the SQL Queries.
• Following are the Queries to fin the Server by OS Name and the count of Servers

SELECT VR.operatingSystem0,COUNT(VR.operatingSystem0) FROM v_R_System AS VR

WHERE VR.operatingSystem0 LIKE '%Windows Server%'

GROUP BY VR.operatingSystem0

SQL server is blank while adding Additional Management Server in SCOM 2012 R2

SQL server is blank while adding Additional Management Server in SCOM 2012 R2

• I faced a weird issue today. As i was trying to add additional SCOM management Server , The SQL page where we select the OperationsManger DB was blank.
• After some investigation i found that the Management Server was already showing in the SCOM Management server view as Unmonitored.
• On i deleted it and tried again it worked and was able to see the OperationsManager DB