Stephen's Wiki

User Tools

Site Tools

Trace: • foobar2000_setup • start • copilot_cheat_sheet
start

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
start [2014/03/19 04:32] – [Poor Man's Dependency Injection] stephenstart [2024/08/24 01:22] (current) – [Running with Rubix] stephen
Line 6: Line 6:
  
 This is a collection of random stuff I want to record for future reference. Probably not much use to anyone else. 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 ===== ===== When HTTPS requests always return 404s =====
Line 83: Line 340:
 | West Europe        | 307.37 | 45.31 | 296.47 | 11.05 | | 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 ===== ===== Unget Files from TFS =====
  
Line 194: Line 454:
 </code> </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 ===== ===== ASP.NET MVC Security Check List =====
Line 271: Line 499:
  
 <code powershell> <code powershell>
-Get-Item *.jpg | ForEach-Object { convert $_ "$($_.basename).png" }+Get-Item *.jpg | ForEach-Object { magick convert $_ "$($_.basename).png" }
 </code> </code>
  
Line 277: Line 505:
  
 <code powershell> <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> </code>
  
Line 283: Line 511:
  
 <code powershell> <code powershell>
-Get-ChildItem | Foreach { convert $_.FullName -quality 98 "$($_.basename).jpg" }+Get-ChildItem | Foreach { magick convert $_.FullName -quality 98 "$($_.basename).jpg" }
 </code> </code>
  
start.1395203551.txt.gz · Last modified: 2017/01/01 19:53 (external edit)
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki