Rapture in Everything

Posts tagged "open source"

Ghost: making me learn nginx on Ubuntu

So the time finally came: Ghost 1.0 is out. My setup is a little more complex than the vanilla one: on this site, there are two blogs next to one another: one here at /blog, and a separate one at /sk. I also have other Ghost blogs in different places and domains. This post documents the stuff I had to learn, and what I ended up using, in case I need a refresher. For various reasons, I run them in Azure. Setting it up was never easy - I'd wasted many, many hours on failed attempts and ended up...

Scripts for repeatable SSIS package deployment

Instead of writing manuals with a lot of pictures for a customer's admin, I prefer to write a script that does the deployment by itself when ran. Several times I'd needed to deploy SSIS packages and configure them with SQL scripts, which is a pain to do manually, since it involves a lot of clicking and SQL editing. Of course, another advantage of using scripts is that your deployments are repeatable, quick, and can be shared with your colleagues via your VCS of choice. All of the components used here should be present on any SQL server you are deploying...

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. 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. Why? A valid question. After all, there already are PS cmdlets that do the same thing, and more. An advantage of this script is that while you have to install the MSMQ Cmdlets module, you only need to download the queue script and run it. (It doesn’t depend on...

MSMQ reader component for SSIS

Last year I had to use SQL Server Intergration Services package to read some data from a MSMQ queue and pump them into a database. It sounded easy enough, but I quickly ran into difficulties. While SSIS does provide some MSMQ reading/writing components, they seem to be primarily meant to facilitate communication between two SSIS packages – I hadn’t been able to make them just read the queue and dump the textual data. So I set out to implement my own component. It was a major pain, so I’m open sourcing it, in case someone else needs it;...