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…

0

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…

1

Splitting logs with PowerShell

I did some work to aggregate some logs from a group of servers for the whole month of February. This took a while, but I ended up with a nice CSV file that I was ready to load into Excel to create some Pivot Tables. See more on Pivot Tables at: Using PowerShell and Excel…

3

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…

0

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…

4

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…

7

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…

0

Microsoft SharePoint Server 2013 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…

0

PowerShell script used in the Windows Server 2016 TP2 Storage QoS demo at MSIgnite

  This is the Windows PowerShell script I used in the Microsoft Ignite 2015 session on Storage QoS: Hyper-V Storage Performance with Storage Quality of Service. You can also find that demo video by itself at Windows Server 2016 TP2 Storage QoS: Managing with a PowerShell script.   The script is fairly straightforward, but there…

0