Rapture in Everything

Posts tagged "cli"

Moving a VHD (disk image) between Azure Storage accounts with x-plat CLI

I’ve discovered I’ve accidentally created a VHD in a Premium storage account, so I wanted to migrate it into a standard one. (Premium data are stored on SSDs and much more expensive.) I’ve found a way to do it using the Powershell commands, but I like the xplat CLI more. (It, too, is developed by Microsoft, built on Node.js and available via npm. [https://azure.microsoft.com/en-us/documentation/articles/xplat-cli-install/]) So I set to exploring. Here is what’s worked for me; I can’t guarantee...

csv-to-sqlite - copying from CSV files to a SQLite database

csv-to-sqlite is a command line tool that **takes CSV files and dumps their contents into a SQLite database**. The basic gist: for each file, the script creates a database table with the same name, tries to guess the data type, then copies all the data into the database....

Manipulate MSMQ with PowerShell

I´ve recently published an open source MSMQ component for the SQL Server Integration Services [https://zblesk.net/blog/2015/02/08/msmq-reader-component-for-ssis/]. While working on its implementation (and other, related things), I’ve created some PowerShell utilities for queue manipulation. Now I’m consolidating them and putting them here, too. I’ts just a single ps1 file [https://github.com/zblesk/scripts/blob/master/queue.ps1]. Why? A valid question. After all, there already are [https://tech...