2016-09

PowerShell Snippet #7: Retrieve SQL Server Licence Key

Copied from somewhere else on the internet, this PowerShell script will return the product key used for a SQL instance Install. Super useful when changing licenses on temporary VM’s I spin up and play around with to SQL Developer whose instances have passed the Enterprise evaluation use-by date. Putting this here for my own benefit. I claim no kudos!  function GetSqlServerProductKey { ## function to retrieve the license key of a SQL 2014 Server.

2016-09-11

PowerShell Snippet #6

Recently I needed to run Invoke-Sqlcmd that would use a connection string of a variety of parameters. Below is the script I used to accept whatever parameters would be passed in to the “Invoke-sqlcmd”. The input file contained the same text as the $query parameter.  $ServerInstance = ".\instance" $database = "Northgale" $uname = "user" $pword = "password123" $query = "'SELECT GETDATE() AS TimeOfQuery;'" $inputFile = "C:\Users\Richard\Documents\inputfile.sql" $connectionString = "-ServerInstance $ServerInstance -UserName $uname -Password $pword -Database $database -verbose" $connectionString = $connectionString -split '(?

2016-09-10

VSTS Hosted Build Agent Specs

I was interested to know just what the hardware specifications of the hosted build agent is. So I added some PowerShell to read out the info below:  2016-06-29T09:23:31.3935358Z systemname Name DeviceID NumberOfCores NumberOfLogicalProcessors Addresswidth 2016-06-29T09:23:31.3935358Z ---------- ---- -------- ------------- ------------------------- ------------ 2016-06-29T09:23:31.3935358Z TASKAGENT5-0010 Intel(R) Xeon(R) CPU E5-2673 v3 @ 2.40GHz CPU0 2 2 64 2016-06-29T09:23:31.4095356Z Total memory: 7167.55078125 What piqued my interest greater was that this is the exact same spec for a D2 v2 box that is available via Azure.

2016-09-05