Microsoft Technologies Articles - Page 155 of 204

Let us understand the concepts of OneDrive and ZumoDrive before learning the differences between them.OneDriveOneDrive is a Microsoft cloud service which connects all your files. It helps us to store and protect our files, share them with others and we can access them from anywhere. It is a file hosting service available in 107 languages.It was launched in 2007 by Microsoft as a web version of office. It offers 5GB of storage space for free and a paid version if it offers a space of 100 GB, 1 TB, and 6 TB available either separately or with Office 365 subscriptions.FeaturesThe ... Read More

Let us understand the concepts of Microsoft Excel and Microsoft Access before learning the differences between them.Microsoft AccessIt is a database management system offered by Microsoft which puts together the relational Microsoft Jet Database Engine with a graphical user interface and software development tools.AdvantagesThe advantages of Microsoft Access are as follows −Table structure and normalization through multiple tables − In a database you can store more information in one place and you use the address as a reference in many places.Records are free − The major difference between Microsoft excels and Microsoft access is that in a database records are ... Read More

Microsoft Team is a business communication platform which is developed by Microsoft team as a part of the Microsoft 365 family of products. It offers workspace chat, video conferencing, file storage and application integration.Skype is a Microsoft product which offers free video and audio calling which also has the ability to call landlines and smartphones with paid services anywhere in the world. It has a first mover advantage. It came into existence before the Facebook messenger.DifferencesThe major differences between Microsoft Team and Skype are as follows −Microsoft TeamsSkypeThis is a video conferencing and collaboration tool which exists in 2017, Now ... Read More

What is Azure State DSC?Azure State DSC is nothing but the DSC (Desired State Configuration) for the Azure VMs and can be configured from the Azure Automation Account. For the DSC there are two methods Push and Pull configuration but Azure is by default using the Pull server which constantly polls the target nodes and sends the configuration to the nodes.Azure DSC is itself a vast topic, in this article we will try the below configuration using PowerShell.Compose / Upload Node Configuration file.Compile node configuration.Attach compiled node configuration to the nodes.PrerequisiteAzure SubscriptionAzure Automation AccountConfiguration file (That we will create in ... Read More

OverviewPowerShell DSC is different than PowerShell scripting which ensures the remote windows systems are in the desired state and it is the declarative method unlike PowerShell Scripting and other programming languages which are considered imperative methods.In this article, we will go through the Push Method of the DSC which is a commonly used method for beginners and doesn’t require the Pull server. Pull server which polls the remote servers at some intervals and set the desired configuration for them and it is kind of automated.For the Push configuration, we will consider the below aspects.Get the DSC resource to Configure.Create the ... Read More

In this article, we will work with CSV files in PowerShell which is considered one of the most efficient ways to deal with data.We have considered the below points for this article.Exporting data to the CSV file using PowerShell.Importing data from the CSV file using PowerShell.Let’s get started.Exporting data to the CSV file using PowerShellUsing Direct command outputTo export data to the csv file in PowerShell we can use Out-File which is the common cmdlet for storing the output to the file. The below command will get the top 10 CPU-consuming processes in the csv file.ExampleGet-Process | Sort-Object CPU -Descending ... Read More

In this article, we will go through the below points.What is an Exception in PowerShell?Terminating and Non-Terminating errors.Using Try / Catch block.Converting Non-Terminating error to Terminating Errors.Handling actual exception messages.What is the exception in PowerShell?Exception in PowerShell or other programming languages is the error or unexpected result that can be handled. For example, File not found while executing, dividing a number by zero.The exception can stop script execution if not handled properly.Terminating Errors and Non-Terminating ErrorsNon-Terminating errors don't halt script execution and it continuously runs script even if it is detected in the script. Below is an example of the ... Read More

DescriptionOut-GridView in a PowerShell is the output format in the GUI format. Generally, we get the output on the console using the Format-Table or Format-List command. Similarly, Out-GridView is also the output format but we can interact with it because of the GUI format.Moreover, it provides us options to select single or multiple rows and we can store the selected output and can utilize them in the script.Out-Gridview with PipelineYou can pipeline output to the Gridview in a similar way as Format-Table or Format-List commands.Example1 − With Pipeline outputGet-Service | where{$_.StartType -eq 'Disabled'} | Out-GridViewOutputThe above command will get all ... Read More

To get the Azure VM sizes available for the availability set, we can use the Get-AzVMSize command with the availability set name. Before running this command make sure that you are connected to the Azure Cloud (if not use Connect-AzAccount) and proper azure subscription (Set-AzContext to set the Azure subscription)Get-AzVMSize `    -ResourceGroupName MYRESOURCEGROUPAVAILABILITY `    -AvailabilitySetName myAvailabilitySetHere the Resource Group name is MyResourceGroupAvailability and the Availability set name is MyAvailabiltyset.Output

There are two ways to retrieve the availability set tags. Using the Tags property inside the availability tag and the second by using the Get-AzTag command.Before running this command make sure that you are connected to the Azure Cloud (if not use ConnectAzAccount) and proper azure subscription (Set-AzContext to set the Azure subscription).First, we will get the availability set properties and retrieve the tag property as shown below.$availablityset = Get-AzAvailabilitySet -ResourceGroupName MYRESOURCEGROUPAVAILABILITY -Name myAvailabilitySet $availablityset.TagsOutputTo get the tags using resource ID, we need to retrieve the resource ID using the Get-AvailabilitySet command.$availablityset = Get-AzAvailabilitySet -ResourceGroupName MYRESOURCEGROUPAVAILABILITY -Name myAvailabilitySet Get-AzTag ... Read More