Connect to SQL Server on Ubuntu Linux VirtualBox machine

For my everyday tests with SQL Server I use VirtualBox. SQL Server 2017 is/will be a huge thing – mostly because it will be available on Linux. If so – I should get comfortable with using it on Linux. I start with Ubuntu Server (because of the name – I used Ubuntu Desktop in the past), Installation of VM on VirtualBox comes down to adding ISO image as the CD-ROM (DVD-ROM?) and selecting almost only the default options. I don’t want to build a cluster or do sophisticated things – I just want the Linux Server to be up and running.

Share
Continue reading »

Get the passwords from SSIS Environment variables

SSIS has a neat feature – it encodes all the sensitive data when you set it as – well – sensitive. It’s a great thing for environment variables – you write once, use it to configure the project and then you can forget the password. Or write it down for later use. In the future. Some day. Maybe. But what if you need to do the configuration on another server? Or you’re just curious how to decode encrypted data? SSIS has to do it somehow, right?

Share
Continue reading »