Stephen's Wiki

User Tools

Site Tools

Trace:
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 [2012/12/16 04:35] – external edit 127.0.0.1start [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 =====
 +
 +  - [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 =====
 +
 +  - [Visual Studio] Tools -> WCF Service Configuration Editor
 +  - [Microsoft Service Configuration Editor] File -> Open -> Config File...
 +  - [Microsoft Service Configuration Editor] (Open the Web.config file)
 +  - [Microsoft Service Configuration Editor] Diagnostics (not a subnode)
 +  - [Microsoft Service Configuration Editor] Click Enable MessageLogging
 +  - [Microsoft Service Configuration Editor] Click Enable Tracing
 +  - [Microsoft Service Configuration Editor] File -> Save
 +  - [] Rerun app and reproduce error or whatever.
 +  - [Windows Explorer] Open directory with Web.config in it.
 +  - [Windows Explorer] Double click Web_messages.svclog and Web_tracelog.svclog.
 +
 +===== MVC Date binding =====
 +
 +<code c#>
 +[DataType(DataType.Date)]
 +[DisplayName("Start date")]
 +[DisplayFormat(DataFormatString = "{0:dd/MM/yyyy}", ApplyFormatInEditMode = true)]
 +[Date(ErrorMessage = "Please enter a start date")]
 +public DateTime StartDate { get; set; }
 +</code>
 +
 +===== Get a connection string using a GUI =====
 +
 +  - Minimise all windows.
 +  - On the desktop, create a new file and name it 'test.udl'.
 +  - Double click it.
 +  - Select Provider and connection settings and play with them until they work.
 +  - Click ok.
 +  - Open 'test.udl' in a text editor. There is your connection string.
 +
 +===== Delete a TFS Workspace that does not exist =====
 +
 +Visual Studio can sometimes get a bit confused about which TFS workspaces exist and which don't. Sort it out with the Visual Studio Command Prompt.
 +
 +Figure out what workspaces really exist:
 +<code>
 +tf workspaces /collection:sourcecontrol.company.co.nz\DefaultCollection
 +</code>
 +
 +Well and truly delete the motherfucker:
 +<code>
 +tf workspace /delete workspacename
 +</code>
 +
 +If ''tf'' starts complaining about "Unable to determine the source control server", try running the first command again (it seems to magically fix shit up or something):
 +<code>
 +tf workspaces /collection:sourcecontrol.company.co.nz\DefaultCollection
 +</code>
 +
 +===== Rob Connery's JavaScript Inferno =====
 +
 +^ Library ^ Conceptual Density ^ Googles/Hour ^ Scaling Pain¹ ^ Rob's Choice ^
 +| Knockout | Fairly Low | 6 - 8 | 20, 25, 50, 90 | 80% of the time |
 +| Backbone | High | 25 - 30 | 50, 30, 20, 20 | |
 +| Angular | Medium/ High | 10 - 20 | 10, 20, 70, 90 | Simple JS App |
 +| Ember | Extreme | *² | 90, 25, 20, 10 | Big JS App |
 +
 +¹ Simple, Moderate, Advanced, Enterprise\\
 +² Gave up googling, api changes often, lots of out-of-date info on web.
 +
 +===== Conditional Attributes in Razor =====
 +
 +<code html>
 +<div @(item.Selected ? string.Empty : "style=display:none")></div>
 +</code>
 +
 +Note that Razor is quite fussy about the format of the ''style=display:none'' bit. No spaces.
 +
 +A less nice method that also works is:
 +
 +<code html>
 +<div class="notch" @(Html.Raw(item.Selected ? string.Empty : "style=\"display: none;\""))></div>
 +</code>
 +
 +
 +===== ASP.NET MVC Security Check List =====
 +
 +See [[asp_net_mvc_security_check_list|ASP.NET MVC Security Check List]].
 +
 +===== Problem Steps Recorder =====
 +
 +On Windows 7 and above:
 +
 +  - Start button.
 +  - Type ''Steps'' or ''PSR''.
 +  - Click 'Record steps to reproduce a problem'.
 +  - Be amazed.
 +
 +===== Updating NuGet VS2010 WinXP =====
 +
 +  - Download ''NuGet.Tools.vsix'' (look for it at [[http://nuget.org|nuget.org]])
 +  - Uninstall NuGet from within Visual Studio.
 +  - Close Visual Studio.
 +  - Run the ''NuGet.Tools.vsix'' file to install the new version.
  
 ===== Log Parser Examples ===== ===== Log Parser Examples =====
Line 11: Line 479:
 Search the application event log on the local machine: Search the application event log on the local machine:
 <code> <code>
-LogParser.exe -i:evt "SELECT TOP 100 * FROM Application WHERE SourceName like '%Reporting%'" > d:\Temp\Output.txt +LogParser.exe -i:evt -rtp:-1 "SELECT TOP 100 * FROM Application WHERE SourceName like '%Reporting%'" > d:\Temp\Output.txt 
 </code> </code>
  
 Search the standard three event logs on the local machine: Search the standard three event logs on the local machine:
 <code> <code>
-LogParser.exe -i:evt "SELECT TOP 100 * FROM System, Application, Security WHERE SourceName like '%Reporting%'" > d:\Temp\Output.txt +LogParser.exe -i:evt -rtp:-1 "SELECT TOP 100 * FROM System, Application, Security WHERE SourceName like '%Reporting%'" > d:\Temp\Output.txt 
 </code> </code>
  
 Search the application event log on a remote machine (may take a while): Search the application event log on a remote machine (may take a while):
 <code> <code>
-LogParser.exe -i:evt "SELECT TOP 100 * FROM \\MachineName\Application WHERE SourceName like '%Reporting%'" > d:\Temp\Output.txt +LogParser.exe -i:evt -rtp:-1  "SELECT TOP 100 * FROM \\MachineName\Application WHERE SourceName like '%Reporting%'" > d:\Temp\Output.txt 
 </code> </code>
 +
 +The ''-rtp:-1'' option suppresses the "Press a key..." prompt.
  
 ===== Batch Convert Image Format ===== ===== Batch Convert Image Format =====
  
-Note: This doesn't actually work m(+In a Powershell console:
  
-  - **Copy** the files to a temp directory. +<code powershell> 
-  - <code>mogrify -format png *.cr2</code> +Get-Item *.jpg | ForEach-Object { magick convert $_ "$($_.basename).png" } 
-  - <code>rename *.cr2 *.png</code>+</code> 
 + 
 +This also works: 
 + 
 +<code powershell> 
 +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 ===== ===== Firefox Command Line Parameters =====
  
start.1355632541.txt.gz · Last modified: 2017/01/01 19:53 (external edit)
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki