Windows Anniversary – Enable Bash

Hurrah! Windows 10 (Version 10.0.14393) is here.

Prerequisites: you will need a 64-bit installation of Windows. Then you will need to have enable Developer Mode .

Start a new PowerShell window running as an Administrator. Run the following to enable the feature:

Enable-WindowsOptionalFeature -Online -FeatureName 'Microsoft-Windows-Subsystem-Linux'

Reboot your device and log back in.
Open the Start Menu, and type in “bash”.  (It points here: C:\Windows\System32\bash.exe).

The following prompt will appear:

-- Beta feature --
This will install Ubuntu on Windows, distributed by Canonical
and licensed under its terms available here:
https://aka.ms/uowterms
Type "y" to continue:

If you agree, type in “y” and press <Enter>. A download will begin:

Downloading from the Windows Store... 100%
Extracting filesystem, this will take a few minutes...
Please create a default UNIX user account. The username does not need to match your Windows username.
For more information visit: https://aka.ms/wslusers
Enter new UNIX username: <username>
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
Installation successful!
The environment will start momentarily...
Documentation is available at:  https://aka.ms/wsldocs
<username>@<hostname>:/mnt/c/Windows/System32$

Then go to town! You’ll get a new shortcut labeled ‘Bash on Ubuntu on Windows’ which points at the bash.exe and get the initial package updates out of the way.

<username>@<hostname>:/mnt/c/Windows/System32$ sudo apt-get update
<username>@<hostname>:/mnt/c/Windows/System32$ sudo apt-get upgrade

And does ‘cmatrix’ work…?

<username>@<hostname>:/mnt/c/Windows/System32$ sudo apt-get install cmatrix cmatrix-xfont
<username>@<hostname>:/mnt/c/Windows/System32$ cmatrix

It does!

If you want to poke around from Windows, the root filesystem is located here:

%USERPROFILE%\AppData\Local\Lxss\rootfs

T-SQL Bulk Insert From Text (TXT) File Into A Temporary Table

First, have a text file with some values you would like to BULK INSERT.
The example below is a text file called ‘animals.txt’ with contents of:

 cat
 dog
 fish
 bird
 snake

The SQL snippet:

 CREATE TABLE #TempTable (Pets CHAR(16));
 BULK INSERT #TempTable
 FROM 'C:\SQLTesting\animals.txt'
 WITH
 (
 DATAFILETYPE= 'char',
 FIELDTERMINATOR=',',
 ROWTERMINATOR='\r' -- Carriage Return
 );
 SELECT Pets FROM #TempTable;
 -- Remove our temporary table.
 DROP TABLE #TempTable;

CREATE TABLE:
https://msdn.microsoft.com/en-us/library/ms174979.aspx

BULK INSERT:

https://msdn.microsoft.com/en-us/library/ms188365.aspx

PowerShell – Calculated Property Example & Export-Csv Formatting


Import-Module MSOnline
Connect-MSOLService -Credential (Get-Credential)
$groupid = 'XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX' # A GroupID with a known single Error.
$groupdetails = Get-MSOLGroup -ObjectID $groupid -ErrorAction 'Stop'
$groupdetails | `
Select-Object ObjectID,DisplayName,GroupType,`
@{ Label='ExpandedErrorCode';Expression={$PSItem.Errors[0].ErrorDetail.ObjectErrors.ErrorRecord.ErrorCode} },`
@{ Label='ExpandedErrorDescription';Expression={$PSItem.Errors[0].ErrorDetail.ObjectErrors.ErrorRecord.ErrorDescription} }
| `
Export-Csv -LiteralFile "$env:USERPROFILE\Desktop\MyGroupFile.csv" -NoTypeInformation
Remove-Variable groupid

Running $groupdetails | Get-Member shows Name of ‘Errors’ as a MemberType of: ‘Property’, with a Definition of: ‘System.Collections.Generic.List[Microsoft.Online.Administration.ValidationError] Errors {get;set;} ‘

PowerShell – Array vs. ArrayList Performance

Let’s take a look at performance when dealing with looping over an array variable; adding a new item and overall performance.
A standard array object in PowerShell is of a fixed size when created and cannot expand automatically. When you use the “+=” operator to append an entry, a new array object is created in memory with the additional overall previous array object. This leads to a large performance hit when dealing with a large number of items and increased memory consumption. For example:


$ArrayList = New-Object -TypeName 'System.Collections.ArrayList';
$Array = @();


Measure-Command
{
for($i = 0; $i -lt 10000; $i++)
{
$null = $ArrayList.Add("Adding item $i")
}
};
Measure-Command
{
for($i = 0; $i -lt 10000; $i++)
{
$Array += "Adding item $i"
}
};

Recommendation: use generics!

Modifying Multivalued Attributes With PowerShell

[int] $ADS_PROPERTY_CLEAR = 1;
[int] $ADS_PROPERTY_UPDATE = 2;
[int] $ADS_PROPERTY_APPEND = 3;
[int] $ADS_PROPERTY_DELETE = 4;

# Get the user's Distinguished Name (DN) however you prefer.
# Utilize the above option switch to adjust.
$ADuser = [ADSI]"LDAP://SERVER-NAME-HERE/$($theUserAccount.DistinguishedName)"          
$ADuser.PutEx($ADS_PROPERTY_DELETE, "proxyAddresses", @("smtp:$userNameForUpdate@contoso.com"))
$ADuser.PutEx($ADS_PROPERTY_APPEND, "proxyAddresses", @("SMTP:$userNameForUpdate@extranet.contoso.com"))

# Commit the changes to the AD User Object:
$ADuser.SetInfo()

Reference:
http://technet.microsoft.com/en-us/library/ee156515.aspx

More Debian Adventures

Tried a NetBoot install of Debian and was a big fan of this post: http://www.octatech.net/blog/2014/08/things-to-do-after-installing-debian-8-jessie/

The NIC in my NUC wasn’t auto-detected initially and had to use a Debian Unstable net-boot image as mentioned in this post:
http://codepoets.co.uk/2014/installing-debian-jessie-on-an-intel-nuc-d54250wyk/