Tag: PowerShell

PowerShell cmdlets and parameters for the SharePoint Online module

This is a simple list of all the cmdlets in the Microsoft.Online.SharePoint.PowerShell module. This is a useful module for an Administrator using SharePoint Online or OneDrive for Business. Here are a few notes: If you don't have the module, you can install it using the following cmdlet: Install-Module -Name Microsoft.Online.SharePoint.PowerShell Before you can use most … Continue reading PowerShell cmdlets and parameters for the SharePoint Online module →

PowerShell Examples in my GitHub Repo

I just uploaded a few of my PowerShell samples to GitHub at https://github.com/Jose-Barreto/PowerShell. Many were mentioned in previous blog posts: PowerShell Examples: Calculating the value of Pi PowerShell Examples: Calculating Prime Numbers PowerShell Examples: Generating Random Names PowerShell Examples: Counting words in a text file PowerShell Examples – Random words and their popularity via Bing PowerShell Examples: Using Bing to … Continue reading PowerShell Examples in my GitHub Repo →

Using PowerShell to generate a large test CSV file with random data

I recently posted a new blog that shows how to load a very large CSV file into Excel, breaking the limit of 1 million rows in a single Excel sheet. If you haven't seen it, you should check it out: Loading CSV/text files with more than a million rows into Excel. One of the challenges for … Continue reading Using PowerShell to generate a large test CSV file with random data →

PowerShell script organizes pictures in your OneDrive camera roll folder

I just published a new PowerShell script that organizes pictures in your OneDrive camera roll folder. It creates folders named after the year and month, then moves picture files to them. Existing files will be renamed in case of conflict. Empty folders left behind after the files are moved will be removed. It defaults to … Continue reading PowerShell script organizes pictures in your OneDrive camera roll folder →

PowerShell for finding the size of your local OneDrive folder

I would just like to share a couple of PowerShell scripts to find the size of your local OneDrive folder. Note that this just looks at folders structures and does not interact with the OneDrive sync client or the OneDrive service. First, a one-liner to show the total files, bytes and GBs under the local OneDrive … Continue reading PowerShell for finding the size of your local OneDrive folder →

Drive Performance Report Generator – PowerShell script using DiskSpd by Arnaud Torres

Arnaud Torres is a Senior Premier Field Engineer at Microsoft in France who sent me the PowerShell script below called "Drive Performance Report Generator".He created the script to test a wide range of profiles in one run to allow people to build a baseline of their storage using DiskSpd.EXE.The script is written in PowerShell v1 and … Continue reading Drive Performance Report Generator – PowerShell script using DiskSpd by Arnaud Torres →

Using PowerShell and Excel PivotTables to understand the files on your disk

  Introduction I am a big fan of two specific technologies that usually don’t get mentioned together: PowerShell and Excel PivotTables. It started when I was explaining PivotTables to someone and the main issue I had was finding a good set of example data that is familiar to everyone. That’s when it hit me. People … Continue reading Using PowerShell and Excel PivotTables to understand the files on your disk →

New PowerShell cmdlets in Windows Server 2016 TP2 (compared to Windows Server 2012 R2)

  1. State the problem   With the release of Windows Server 2016 TP2 a few weeks ago, I was wondering what new PowerShell cmdlets are now included (when you compare to Windows Server 2012 R2). However, the list of cmdlets is so long now that it is hard to spot the differences by hand. … Continue reading New PowerShell cmdlets in Windows Server 2016 TP2 (compared to Windows Server 2012 R2) →

Microsoft SQL Server 2014 PowerShell cmdlet popularity

If you follow the blog, you probably saw a little PowerShell script I published a while back to measure the popularity of the cmdlets in a certain module using a Bing search. As an example, that blog showed the popularity of the cmdlets in the SmbShare module. Now I got curious about how the cmdlets … Continue reading Microsoft SQL Server 2014 PowerShell cmdlet popularity →