sql

Return and Recap

So I've been meaning to get back to this blog for some time, and just…well I just haven't. Anyway, here we are, so it's time for a quick recap of what I've been up to technically the past couple of years. (Quick because I'd written a long version and MarsEdit lost the draft…said software is now uninstalled! What follows is the very brief re-write). Education, education, education Learning has been my thing.

SSIS – Change the Protection Level for all Packages in a Project

Here's a quick one I found this morning while fixing an execution issue with one of my SSIS packages. I needed to change the Protection Level of all the packages in a project from Encrypt With User Key to Don't Save Sensitive. The project contains over 30 packages, and I didn't really fancy opening each one, navigating to the properties and amending the Protection Level for each one - that's too time-consuming and frankly, boring.

Try R, a free course

I've been branching out a bit in my spare time with regards to other tools and languages for manipulating and analysing data. The R language has interested me for a while, and I came across this free tutorial which serves as a pretty good introduction to its basic usage and syntax. It does so in a rather nice interactive web interface. Highly recommended if you have a spare hour or two to go through the course.