This is step by step guide how to use new .NET namespace Microsoft.Data.SqlClient with Powershell. I've tested connection string using SQL login and Windows login. This could not fit you all but might provide you some ideas.
Fresh Windows Server 2016 in my case Azure VM.
| function Find-Module { | |
| <# | |
| .Synopsis | |
| A wrapper for Invoke-RestMethod to search the PowerShell Gallery | |
| .Description | |
| In order to support wildcards, we build pretty complicated URLs, | |
| and then we filter the results by title | |
| #> | |
| [CmdletBinding()] | |
| param ( |
| # pulled from http://xecdesign.com/qemu-emulating-raspberry-pi-the-easy-way/ | |
| # expanded via http://superuser.com/questions/690060/how-to-enable-network-with-a-raspberry-pi-emulated-on-qemu | |
| # tested with 2015-02-16-raspbian-wheezy.zip on OSX Mavericks | |
| # OSX terminal | |
| brew install qemu | |
| # kernel-qemu is a linux kernel compiled with ARM1176 support. | |
| # learn more here: http://xecdesign.com/compiling-a-kernel/ | |
| curl -OL http://xecdesign.com/downloads/linux-qemu/kernel-qemu | |
| curl -o raspbian_latest.zip -L http://downloads.raspberrypi.org/raspbian_latest |