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

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…

11

My top tweets from 2016

These are my top tweets from each month in 2016, according to https://analytics.twitter.com.   January 2016   New blog post: My Top Reasons to Use OneDrive http://blogs.technet.com/b/josebda/archive/2016/01/26/my-top-reasons-to-use-onedrive.aspx   New FileCab blog: Updating Firmware for Disk Drives in Windows Server 2016 (TP4) https://blogs.technet.microsoft.com/filecab/2016/01/25/updating-firmware-for-disk-drives-in-windows-server-2016-tp4/   Updated Intel HD 5000 driver (released alongside the new Surface Pro 3 firmware)…

0

Interesting OOF messages

It’s that time of the year when everyone is taking time off and some of us will leave out-of-office messages. The typical boring OOF (shouldn’t they be called OOO or OoOf?) should tell when you’re coming back and the e-mail of the poor soul that will be in the office during this time. It reads like:…

1

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

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

Build 2016 videos related to OneDrive

Here is an unofficial list of Build 2016 videos that are related to OneDrive: Session Title: OneDrive API – Overview, What’s New, and Scenarios Presenter: Sean Maloney Description: Overview of the OneDrive API for OneDrive and OneDrive for Business, highlights on what’s new, and a quick overview of the range of scenarios you can enable. Session Title: Introducing the…

0

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

The ABC language, thirty years later…

Back in March 1986, I was in my second year of college (Data Processing at the Universidade Federal do Ceara in Brazil). I was also teaching programming night classes at a Brazilian technical school. On that year, I created a language called ABC, complete with a little compiler. It compiled the ABC code into pseudo code…

1