Loading CSV/text files with more than a million rows into Excel

1. The Problem If you usually load a very large CSV (comma-separated values) file or text file into Excel, you might run into the dreaded “File not loaded completely” message: As the message explains, the file you are trying to load is too large for Excel to handle. For me, it typically happens with large…

9

SNIA’s SDC 2016: Public slides and live streaming for Storage Developer Conference

SNIA’s Storage Developer Conference (SDC 2016) is happening this week in Santa Clara, CA. This developer-focused conference cover several storage topics like Cloud, File Systems, NVM, Storage Management, and more. You can see the agenda at http://www.snia.org/events/storage-developer/agenda/2016   However, there a few thing happening differently this time around. First, most of the slides are available…

0

Visuality Systems and Microsoft expand SMB collaboration to storage systems

Last week, Microsoft and Visuality Systems announced an expanded collaboration on SMB. Visuality is well known for their work supporting the SMB protocol in embedded devices. If you own a printer or scanner that supports the SMB protocol, there’s a good chance that device is running Visuality’s software. Visuality is now expanding into the storage…

0

Raw notes from the Storage Developer Conference 2015 (SNIA SDC 2015)

Notes and disclaimers: This blog post contains raw notes for some of the SNIA’s SDC 2015 presentations (SNIA’s Storage Developers Conference 2015) These notes were typed during the talks and they may include typos and my own misinterpretations. Text in the bullets under each talk are quotes from the speaker or text from the speaker…

7

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 Ignite 2015 sessions related to OneDrive and SharePoint

  Microsoft Ignite 2015 was a great event, but there were so many sessions that it was truly impossible to watch everything that looked interesting. However, all sessions were recorded and by now they should be available on Channel 9 for streaming. Even with all the recordings available, it’s hard to find the links to all…

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

Windows Server 2016 Technical Preview 2 (TP2) and Storage Quality of Service (QoS)

  Storage Quality of Service (Storage QoS) is a new feature in the upcoming Windows Server 2016 that provides a way to centrally monitor and manage storage performance for virtual machines. The feature automatically improves storage resource fairness between multiple virtual machines using the same file server cluster and allows specific minimum and maximum performance…

3