Coded UI and Silverlight: short and slow, or the other thing

So if I navigate directly from a HtmlCustom-derived class to the SilverlightButton-derived class, then that takes say 10 seconds. But if I use a hack of the generated classes, which have way more chaining in them, then takes 5 seconds. Presumably that is because the additional filters on the way down help to find things more efficiently.

This PasteBin contains both – you’ll work it out. It assumes a Silverlight button with an AutomationId of 101.

 

Windows: deleting files with very long names

So crazy that on Windows 10, a) you can still get this error message, and b) not be able to anything about it within Windows. Ignore all the false promises of [subst] or of moving the offending folders higher up the tree – with the Node sample application for example, either a) you still bang up against the error or b) it’s just too ridiculously manual to sort it out:

deleteFiles01

 

Chocolatey and a person to the rescue, and ha what do you know – it was precisely the Node folders that got me:

deleteFiles02

So go look here, and here, and you’ll be fine.

 

SQLServer – unattended installation

I didn’t quite get to the end of doing this as YouTube video, so for now a summary:

Provided you have a correctly configured ConfigurationFile.ini, whose purpose is to supply all the required configuration points for a SQLServer installation (works for 2008,2012,2014, with minor differences), then you can execute a command line very similar to this, and after about 30 minutes, you have a full SQLServer installation (plus RS, IS, etc, depending on what you have included in the config file):

SqlSilentInstall05

setup.exe /configurationfile=”c:\scratch\ConfigurationFile2014.ini”

This is the configuration file content I used to achieve this:

;SQL Server 2014 Configuration File
[OPTIONS]

IACCEPTSQLSERVERLICENSETERMS="True"

ACTION="Install"

ROLE="AllFeatures_WithDefaults"

ENU="True"

QUIET="True"

QUIETSIMPLE="False"

UpdateEnabled="True"

ERRORREPORTING="False"

USEMICROSOFTUPDATE="False"

FEATURES=SQLENGINE,REPLICATION,FULLTEXT,DQ,RS,DQC,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,MDS

UpdateSource="MU"

HELP="False"

INDICATEPROGRESS="False"

X86="False"

INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"

INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server"

INSTANCENAME="MSSQLSERVER"

SQMREPORTING="False"

INSTANCEID="MSSQLSERVER"

RSINSTALLMODE="FilesOnlyMode"

INSTANCEDIR="C:\Program Files\Microsoft SQL Server"

AGTSVCACCOUNT="NT Service\SQLSERVERAGENT"

AGTSVCSTARTUPTYPE="Manual"

ISSVCSTARTUPTYPE="Automatic"

ISSVCACCOUNT="NT Service\MsDtsServer120"

COMMFABRICPORT="0"

COMMFABRICNETWORKLEVEL="0"

COMMFABRICENCRYPTION="0"

MATRIXCMBRICKCOMMPORT="0"

SQLSVCSTARTUPTYPE="Automatic"

FILESTREAMLEVEL="0"

ENABLERANU="False"

SQLCOLLATION="SQL_Latin1_General_CP1_CI_AI"

SQLSVCACCOUNT="NT Service\MSSQLSERVER"

SQLSYSADMINACCOUNTS="NT AUTHORITY\SYSTEM"

SECURITYMODE="SQL"
SAPWD="Jones789"

ADDCURRENTUSERASSQLADMIN="False"

TCPENABLED="1"

NPENABLED="0"

BROWSERSVCSTARTUPTYPE="Disabled"

RSSVCACCOUNT="NT Service\ReportServer"

RSSVCSTARTUPTYPE="Automatic"

This msdn link gives meaning to the options:
https://msdn.microsoft.com/en-us/library/ms144259.aspx
on Windows 2012, this also requires Windows .net 3.5 framework to be installed

Azure: backups and the Recovery Service

My aim today was to get checkpoints/snapshots working on Azure again (using PowerShell – see earlier posts on this), just in order to do a video about silent or unattended installations of SQLServer.

But the command line way does not appear to work this time – and I am not clear whether that is because they changed the API, well what happens when you call the API. Anyway, I then stumbled across Azure Recovery Services, which seems to be worth a shot.

Although this list of completions and failures will mean nothing… it does tell a bit of a story, which I may come back to. Right now, as the most recent backup has completed (35 minutes – pretty slow for a machine with very little on it, but of course if it saves the day at some point, great), I’m going back to my unattended installation of SqlServer.

AzureBackup11

 

http://azure.microsoft.com/en-gb/pricing/details/backup/

http://azure.microsoft.com/en-us/documentation/articles/backup-azure-vms/