Differences

This shows you the differences between two versions of the page.

--- start [2013/12/22 20:31] – [How to enable Service Tracing] stephen
+++ start [2024/08/24 01:22] (current) – [Running with Rubix] stephen
@@ Line 7: / Line 7: @@
 This is a collection of random stuff I want to record for future reference. Probably not much use to anyone else.
+===== .NET Logging Levels =====
+Trace = 0, Debug = 1, Information = 2, Warning = 3, Error = 4, Critical = 5, and None = 6.
+===== Running with Rubix =====
+Rubix and I did approximately 1,547 runs and covered 16,347kms together. First run was 2015-08-24, last was around 2024-07-24.
+===== Restart Garmin Forerunner 235 =====
+Hold down the ☀️ button for ages. Watch will power off. Press it again to power on. Settings etc. are not lost.
+===== Set Environment Variable in Unit Test =====
+Create a ''something.runsettings'' file and put it in the solution directory:
+<code xml>
+<?xml version="1.0" encoding="utf-8"?>
+<!-- File name extension must be .runsettings -->
+<RunSettings>
+	<RunConfiguration>
+		<EnvironmentVariables>
+			<!-- List of environment variables we want to set-->
+			<ENABLE_GOD_MODE>true</ENABLE_GOD_MODE>
+		</EnvironmentVariables>
+	</RunConfiguration>
+</RunSettings>
+</code>
+Getting Visual Studio to use the file is a bit tricky. Try Test -> Configure Test Settings. You may need the 'Select Solution Wide runsettings File'. Eventually the file itself should appear in the menu.
+To test, debug and stop at a breakpoint. Run ''Environment.GetEnvironmentVariables()'' in the Immediate Window.
+===== Direct Object Creation with Ninject =====
+This will only work inside an ASP.NET project.
+<code c#>
+using System.Web.Mvc;
+private ILog _log;
+private ILog Log => _log ?? (_log = (ILog)DependencyResolver.Current.GetService(typeof(ILog)));
+</code>
+===== Azure Virtual Machine Windows Activation Problems =====
+Running this worked on my Azure Dev VM:
+<code powershell>
+ForEach-Object { Invoke-Expression "$env:windir\system32\cscript.exe $env:windir\system32\slmgr.vbs /ato" ; start-sleep 5 }
+</code>
+More details at [[https://docs.microsoft.com/en-gb/azure/virtual-machines/troubleshooting/troubleshoot-activation-problems?WT.mc_id=Portal-Microsoft_Azure_Support|Troubleshoot Azure Windows virtual machine activation problems]].
+===== Log all TypeScript functions =====
+Search: ''<nowiki>(public|private)( static)?\s*([\w]+)\(.*?\)(:\s*[\w<>]+)?\s*\{</nowiki>''
+Replace: ''<nowiki>$0 console.log('Module: $3');</nowiki>''
+===== Stupid Roslyn Error =====
+<code>
+Could not find a part of the path 'C:\Dev\BucketsOfFunds\BucketsOfFunds.Web\bin\roslyn\csc.exe'.
+</code>
+Run this in the Package Manager Console:
+<code>
+Update-Package Microsoft.CodeDom.Providers.DotNetCompilerPlatform -r
+</code>
+===== Use PowerShellGet behind a corporate proxy =====
+<code powershell>
+notepad $PROFILE
+</code>
+Add this to the top:
+<code powershell>
+[system.net.webrequest]::defaultwebproxy = new-object system.net.webproxy('http://10.104.66.70:80')
+# To use your current Windows account to log on to the proxy:
+[system.net.webrequest]::defaultwebproxy.credentials = [System.Net.CredentialCache]::DefaultNetworkCredentials
+# To use a different Windows account:
+$Username="domain\username"
+$Password="password"
+[system.net.webrequest]::defaultwebproxy.credentials = New-Object System.Net.NetworkCredential($Username, $Password)
+[system.net.webrequest]::defaultwebproxy.BypassProxyOnLocal = $true
+</code>
+Restart your PowerShell session. Fix up the repository source:
+<code powershell>
+Register-PSRepository -Default
+</code>
+Check you have a repository:
+<code powershell>
+Get-PSRepository
+</code>
+Should get ''https://www.powershellgallery.com/api/v2''.
+===== Add the IIS Development certificate to the Trusted Root Certificates =====
+  - Open MMC.
+  - Add the Certificates snap-in for 'Computer account'.
+  - Console Root > Certificates (Local Computer) > Personal > Certificates.
+  - localhost (IIS Express Development Certificate) > Right click > Copy.
+  - Console Root > Certificates (Local Computer) > Trusted Root Certification Authorities > Certificates.
+  - Actions (right panel) > More Actions > Paste
+===== Kill Chrome instances from automated testing =====
+<code powershell>
+(Get-WmiObject Win32_Process -Filter "name = 'Chrome.exe'" | Where-Object { $_.CommandLine.Contains("--enable-automation") }).Terminate()
+</code>
+And if you want to get rid of the Chrome driver as well (which is always a good idea):
+<code powershell>
+(Get-WmiObject Win32_Process -Filter "name = 'Chrome.exe'" | Where-Object { $_.CommandLine.Contains("--enable-automation") }).Terminate(); (Get-WmiObject Win32_Process -Filter "name = 'chromedriver.exe'").Terminate();
+</code>
+===== Faking DateTime.Now() =====
+<code c#>
+using (ShimsContext.Create())
+{
+	System.Fakes.ShimDateTime.NowGet = () => new DateTime(2019, 03, 31);
+	...
+}
+</code>
+===== Chrome Dev Tools - Show only bad network requests =====
+Copy and paste the below into the filter.
+''-is:running -status-code:200 -status-code:302 -status-code:204 -status-code:304 -status-code:307''
+===== Unit testing - test a method on a property is executed =====
+Requires the [[https://github.com/moq/moq4|Moq]] [[https://www.nuget.org/packages/Moq|NuGet package]].
+<code c#>
+[TestMethod]
+public void MealViewModel_Banana_EatMethodIsCalled_DrinkIsNot()
+{
+	IUtensil spoon = new Spoon();
+	var mockBanana = new Mock<BananaViewModel>();
+	var test = new MealViewModel();
+	testMeal.Banana = mockBanana.Object;
+	// Calling Eat() on the meal should also call Eat() on the banana.
+	testMeal.Eat(spoon);
+	mockBanana.Verify(banana => banana.Eat  (It.IsAny<IUtensil>()), Times.Once,  "Banana should be eaten with a utensil.");
+	mockBanana.Verify(banana => banana.Drink(It.IsAny<IUtensil>()), Times.Never, "Banana should not be drunk.");
+	// Not sure if an interface will work here -------^^^^^^^^
+}
+</code>
+===== Visual Studio can't open CSHTML files =====
+{{ :visual_studio_cant_open_cshtml_files.png |}}
+Fix it thusly:
+  - Close Visual Studio.
+  - Delete everything in ''%LocalAppData%\Microsoft\VisualStudio\14.0\ComponentModelCache''
+  - Open Visual Studio.
+===== Append randomness to start of a filename =====
+<code powershell>
+Get-ChildItem *.mp3 | ForEach-Object{Rename-Item $_ -NewName "$(Get-Random) $($_.Name).mp3"}
+</code>
+===== Why did Windows wake from sleep? =====
+Run this and find out:
+<code>powercfg -lastwake</code>
+===== HTML Sanitation =====
+Add the 'AntiXSS' (Microsoft) package from NuGet.
+<code c#>
+var input = "fjkdlsjf<script></script> <b>klds</b> <a href='fsdfsd.html'>Test</a> <a href='javascript:alert('bugger off')'>HubAdmin</a>";
+var output =  Microsoft.Security.Application.Sanitizer.GetSafeHtmlFragment(input);
+// fjkdlsjf <b>klds</b> <a href="fsdfsd.html">Test</a> <a href="">HubAdmin</a>
+</code>
+===== Setting up a Database User =====
+  - [SQL Server Management] Right click the **server**, Properties.
+  - [SQL Server Management, Server Properties] Security -> Server Authentication -> SQL Server and Windows Authentication mode
+  - [SQL Server Management, Server Properties] Ok
+  - [SQL Server Management] Right click (Server) -> Security -> Logins, New Login...
+  - [SQL Server Management, Login - New] General -> Fill in details.
+  - [SQL Server Management, Login - New] Server Roles -> public only.
+  - [SQL Server Management, Login - New] Ok
+  - [SQL Server Management] Right click (Server) -> Databases -> (Database) -> Security -> Users, New User...
+  - [SQL Server Management, Database User - New] General -> Fill in details.
+  - [SQL Server Management, Database User - New] Membership -> Fill in details.
+  - [SQL Server Management, Database User - New] Ok.
+===== Reading Event Logs with PowerShell =====
+<code powershell>
+# Logs that contain 'Sequence contains'.
+Get-EventLog Application -Source M.pad -newest 20 -message "*Sequence contains*"  | Format-Table -autosize -wrap
+# Logs that do not contain 'FromCommonAuditItem'.
+Get-EventLog Application -Source M.pad -newest 2000 | Where { $_.Message -notmatch 'FromCommonAuditItem' } | Format-Table -autosize -wrap
+</code>
+===== Unit Testing Private Methods =====
+Ignoring the argument as to whether a private method //should// be unit tested...
+<code c#>
+using Microsoft.VisualStudio.TestTools.UnitTesting;
+public class Banana {
+	private int _count;
+	private static int Add(int n1, int n2) {
+		return n1 + n2;
+	}
+	private int Inc() {
+		_count = Add(_count, 2);
+		return _count;
+	}
+}
+class Program {
+	static void Main(string[] args) {
+		PrivateType bananaTest1 = new PrivateType(typeof(Banana));
+		int result1 = (int)bananaTest1.InvokeStatic("Add", 12, 34);
+		PrivateObject bananaTest2 = new PrivateObject(new Banana());
+		int result2 = (int)bananaTest2.Invoke("Inc");
+	}
+}
+</code>
+===== Enable external web requests (Win8) =====
+  - Open 'Windows Firewall' (with Advanced Security)
+  - Add an Inbound Rule
+  - Local port 80 (and 443 if HTTPS is required).
+===== When HTTPS requests always return 404s =====
+  - [IIS Manager] Select the //Default Web Site//.
+  - [IIS Manager] On the right, under Actions, Edit site, select //Bindings...//
+  - [IIS Manager, Site Bindings] There should be two entries, http & https. Select //https//, select //Edit...//
+  - [IIS Manager, Edit Site Binding] SSL certificate should be selected (e.g. PKS1684.corp.ps.co.nz).
+===== Poor Man's Dependency Injection =====
+Chris used an abstract base class. The following should be adapted for an interface, if possible.
+<code c#>
+/*
+  <appSettings>
+    <add key="definitionService" value="EA.ReportingPortal.Services.DbDefinitionService" />
+  </appSettings>
+*/
+public abstract class DefinitionService
+{
+	public abstract List<CategoryTag> GetAllCategories();
+	// ...
+	public static DefinitionService Current
+	{
+		get
+		{
+			var activeServiceName = WebConfigurationManager.AppSettings["DefinitionService"];
+			if (string.IsNullOrWhiteSpace(activeServiceName))
+				throw new ConfigurationErrorsException("Definition Service type not specified or blank");
+			var serviceType = typeof(DefinitionService).Assembly.GetType(activeServiceName);
+			if (serviceType == null || !typeof(DefinitionService).IsAssignableFrom(serviceType))
+				throw new ConfigurationErrorsException("Definition Service type does not exist or does not inherit from DefinitionService");
+			var defaultConstructor = serviceType.GetConstructor(Type.EmptyTypes);
+			if (defaultConstructor == null)
+				throw new ConfigurationErrorsException("Definition Service type does not have an empty constructor");
+			return (DefinitionService)defaultConstructor.Invoke(null);
+		}
+	}
+}
+</code>
+===== How to view LINQ Generated SQL statements =====
+<code c#>
+((System.Data.Objects.ObjectQuery)myQuery).ToTraceString()
+</code>
+Or, if you want an extension method:
+<code c#>
+public static class IQueryableExtensions
+{
+    public static string ToTraceString<T>(this IQueryable<T> t)
+    {
+        ObjectQuery<T> oqt = t as ObjectQuery<T>;
+        return oqt == null ? string.Empty : oqt.ToTraceString();
+    }
+}
+</code>
+===== Windows Azure Regional Response Times =====
+^ Region ^ Free ^^ Standard ^^
+^   ^ Mean ^ StdDev ^ Mean ^ StdDev ^
+| West US            | 160.03 | 23.97 | 155.72 | 12.17 |
+| East Asia          | 163.13 | 22.12 | 159.67 | 13.76 |
+| North Central US   | 205.12 | 11.56 | 207.13 | 15.07 |
+| East US            | 212.42 | 9.47 | 213.05 | 12.15 |
+| North Europe       | 293.83 | 16.72 | 287.96 | 14.76 |
+| West Europe        | 307.37 | 45.31 | 296.47 | 11.05 |
+[[http://azurespeedtest.azurewebsites.net/|Azure Speed Test]]
+Just use **Australia East**.
+===== Unget Files from TFS =====
+  - [Visual Studio] Open Source Control Explorer.
+  - [Visual Studio - Source Control Explorer] Right click the branch or folder to be ungetted.
+  - [Visual Studio - Source Control Explorer] Select 'Get Specific Version...'
+  - [Visual Studio - Get dialogue] Type: Changeset.
+  - [Visual Studio - Get dialogue] Changeset: 1.
+  - [Visual Studio - Get dialogue] Click Get. Bye bye local files and the branch / folder is updated correctly in the Source Control Explorer.
+===== Caches along a trail =====
+  - Open this page in a **new** browser window.
+  - Setup a [[http://www.geocaching.com/my/lists.aspx|list]] for the results.
+  - Create a new or reuse an existing [[http://www.geocaching.com/my/userroutes.aspx|route]].
+  - Create a run-once pocket query based on the route.
+  - Sort the results by favourites and open each in separate browser tab.
+  - Send each one to c:geo.
+  - Bookmark the first one and add it to the list.
+  - Bookmark all the rest.
+  - Go back to the [[http://www.geocaching.com/my/lists.aspx|lists]] and create a pocket query based on it.
+  - Check lots of boxes and Use the "Uncheck the day of the week after the query runs" option.
+  - Go to [[http://www.geocaching.com/pocket/default.aspx|pocket queries]] and delete it.
+  - Wait for email.
+  - Upload attached GPX file to phone.
+  - Import caches into Locus.
+  - Use [[http://umap.openstreetmap.fr/en/|uMap]] (Twitter log in).
+  - Create new map and upload GPX file.
+To print:
+  - Open uMap page in Firefox.
+  - F11 to full screen.
+  - Ctrl + PrnScn (or whatever it is).
+  - Open Paint.NET, paste & print.
+  - Untick 'Fit picture to frame'.
 ===== How to enable Service Tracing =====
@@ Line 83: / Line 454: @@
 </code>
-===== Nuke the Database =====
-Generates SQL commands to drop everything in the database. Be careful you nuke the correct database...
-<code sql>
-USE [Database]
-SELECT 'DROP PROCEDURE ' + [Schema].name + '.' + StoredProcedure.name AS SqlCommand
-       , 10                                                           AS SortOrder
-FROM   sys.objects StoredProcedure
-JOIN   sys.schemas [Schema]
-ON     [Schema].schema_id = StoredProcedure.schema_id
-WHERE  StoredProcedure.TYPE = 'P'
-UNION
-SELECT 'DROP VIEW ' + sys.objects.name
-       , 20
-FROM   sys.objects
-WHERE  sys.objects.TYPE = 'V'
-UNION
-SELECT 'ALTER TABLE ' + [ParentTable].Name + ' DROP CONSTRAINT [' + [ForeignKey].name + ']'
-       , 30
-FROM   sys.objects [ForeignKey]
-JOIN   sys.objects [ParentTable]
-ON     [ParentTable].object_id = [ForeignKey].parent_object_id
-WHERE  [ForeignKey].TYPE = 'F'
-UNION
-SELECT 'DROP TABLE ' + sys.objects.name
-       , 40
-FROM   sys.objects
-WHERE  sys.objects.TYPE = 'U'
-ORDER BY SortOrder
-</code>
 ===== ASP.NET MVC Security Check List =====
@@ Line 160: / Line 499: @@
 <code powershell>
-Get-Item *.jpg | ForEach-Object { convert $_ "$($_.basename).png" }
+Get-Item *.jpg | ForEach-Object { magick convert $_ "$($_.basename).png" }
 </code>
@@ Line 166: / Line 505: @@
 <code powershell>
-Get-ChildItem 'C:\External Drives\Primary Media 2\My Pictures\Fractals\FA (Dual Monitor Wallpaper)' | Foreach { convert $_.FullName -resize 3840x1080! -quality 99 $_.Name }
+Get-ChildItem 'C:\External Drives\Primary Media 2\My Pictures\Fractals\FA (Dual Monitor Wallpaper)' | Foreach { magick convert $_.FullName -resize 3840x1080! -quality 99 $_.Name }
+</code>
+For canvas prints through pixelpaint.co.nz, use **8E** series images and convert to JPEG, < 15MB. Copy images from ''C:\External Drives\Primary Media 2\My Pictures\Fractals\8E (Printing)'' to a temp directory. Run this:
+<code powershell>
+Get-ChildItem | Foreach { magick convert $_.FullName -quality 98 "$($_.basename).jpg" }
 </code>
+For any that are still bigger than 15MB, decrease quality and / or size (''-resize 80%%'').
 ===== Firefox Command Line Parameters =====