Phil Murwin PhilMurwin

## RasPiNamecheapDNS.md

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              13 stars
            
          
                PhilMurwin
                / RasPiNamecheapDNS.md
            
            
              Last active
              April 20, 2024 16:45
            
              
                How to setup DDclient on Raspberry Pi for use with Namecheap DynDNS
              
          
    How to use Namecheap DynDNS service with ddclient on the Raspberry Pi

Log into your Raspberry Pi (by ssh for example) or open a terminal window if you are working directly on Pi. In the first step we have to install ddclient, a DynDNS software, on the Pi. For this purpose, the following two commands are necessary.
sudo apt-get update
sudo apt-get install ddclient

Note: During installation an installation wizard opens and wants to know some things from you. Here you can safely enter what you want, because we have to adjust the configuration file manually either way, because the wizard does not support the Namecheap.com interface.

  
## garlic-os-tips.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                PhilMurwin
                / garlic-os-tips.md
            
            
              Created
              May 23, 2023 18:43
                — forked from milnak/garlic-os-tips.md
            
              
                [GarlicOS Tips for Windows] My set of GarlicOS tips
              
          
    Garlic OS Tips

GarlicOS Installation

This is for a single SD card. You can use two SD cards, but I find a single SD card is cheap and easy to manage.
Download RG35XX-MicroSDCardImage.7z.001 and RG35XX-MicroSDCardImage.7z.002
Extract RG35XX-MicroSDCardImage.7z.001 using 7-zip (open the .7z.001 file) to somewhere on your hard drive (not the USB card!).

  
## pwsh_makecert.ps1
# https://mattou07.net/posts/create-a-self-signed-certificate-for-iis-with-powershell/
# https://www.yaplex.com/how-to-create-a-self-signed-certificate-for-iis-using-powershell/
# https://adamtheautomator.com/new-selfsignedcertificate/

$binding = Read-Host -Prompt 'Enter the site you need a cert for: '
$cert = New-SelfSignedCertificate -DnsName "$binding" -NotAfter (Get-Date).AddMonths(72) -CertStoreLocation "cert:\LocalMachine\My"

Write-Host "Cert [$binding] has been created in the local machine cert store."
Write-Host "Cert will expire in 6 years."

## ListExtensions.cs
using Newtonsoft.Json;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Xml;
using System.Xml.Serialization;

## SQLServer_FindString.sql
DECLARE @SearchStr nvarchar(100) = 'SEARCH_TEXT'
DECLARE @Results TABLE (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

SET NOCOUNT ON

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
SET  @TableName = ''
SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

WHILE @TableName IS NOT NULL

## node_notes.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                PhilMurwin
                / node_notes.md
            
            
              Created
              July 11, 2022 04:06
            
              
                Windows Nodejs Notes
              
          
    Nodejs Notes

nodejs has some oddities when used on windows, below are some notes to address them.
Warning Message

Message "npm WARN config global '--global','--local' are deprecated. Use '--location=global' instead"
Referencing this stackoverflow thread: https://stackoverflow.com/questions/72401421/message-npm-warn-config-global-global-local-are-deprecated-use-loc
As of July 2022:

  
## Visual Studio solution file headers
== Visual Studio .NET 2003 (DO NOT COPY THIS LINE) ==
Microsoft Visual Studio Solution File, Format Version 8.00
# Visual Studio .NET 2003
VisualStudioVersion = 7.1


== Visual Studio 2005 (DO NOT COPY THIS LINE) ==
Microsoft Visual Studio Solution File, Format Version 9.00
# Visual Studio 2005
VisualStudioVersion = 8.0

## SSMS_Configs.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                PhilMurwin
                / SSMS_Configs.md
            
            
              Last active
              February 9, 2022 17:51
            
              
                SQL Mgmt Studio Configs
              
          
    Environment > Keyboard > Query Shortcuts


Create a Dev database to contain some server level procedures
Create a stored proc SPWHO with the sp_who2 script in it.

This is used for Ctrl + 3 below


Shortcut
Stored Procedure


Alt + F1
sp_help


Ctrl + F1


## GenerateSelfSignedCert_2022.ps1
#GenerateSelfSignedCert_2022.ps1
# Information from: https://www.tutorialspoint.com/how-to-create-a-self-signed-certificate-using-powershell
# Additional/Similar information from: https://petri.com/create-self-signed-certificate-using-powershell

# Get Current Directory
$curDir = Get-Location

#Write Header
Write-Host "`n WARNING: This script is provided AS-IS with no warranties and confers no rights." -ForegroundColor Yellow

## selfsigned_wildcard_cert.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                PhilMurwin
                / selfsigned_wildcard_cert.md
            
            
              Created
              September 24, 2021 17:55
                — forked from PSGM/selfsigned_wildcard_cert.md
            
              
                Creating a self-signed wildcard certificate for server authentication in a Windows environment
              
          
    Creating a self-signed wildcard certificate for server authentication in a Windows environment

We are increasingly using, or being required to use, SSL-encrypted sessions
(or technically, TLS-encrypted sessions) for application services. In technical terms, because the Fully Qualified Domain Name (FQDN) in the Uniform Resource Locator (URL) used by a client to access a service needs to match the Common Name (CN) in the certificate used by that service, we potentially have a proliferation of certificates (at least one per server) that need to be available to clients
One approach to addressing this proliferation is to use wildcard certificates that match multiple FQDNs within a domain. Below is a discussion on generating self-signed wildcard certificates as a way of addressing this
What
	# https://mattou07.net/posts/create-a-self-signed-certificate-for-iis-with-powershell/
	# https://www.yaplex.com/how-to-create-a-self-signed-certificate-for-iis-using-powershell/
	# https://adamtheautomator.com/new-selfsignedcertificate/

	$binding = Read-Host -Prompt 'Enter the site you need a cert for: '
	$cert = New-SelfSignedCertificate -DnsName "$binding" -NotAfter (Get-Date).AddMonths(72) -CertStoreLocation "cert:\LocalMachine\My"

	Write-Host "Cert [$binding] has been created in the local machine cert store."
	Write-Host "Cert will expire in 6 years."
	using Newtonsoft.Json;
	using System.Collections.Generic;
	using System.Data;
	using System.IO;
	using System.Linq;
	using System.Reflection;
	using System.Text;
	using System.Xml;
	using System.Xml.Serialization;
	DECLARE @SearchStr nvarchar(100) = 'SEARCH_TEXT'
	DECLARE @Results TABLE (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

	SET NOCOUNT ON

	DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
	SET @TableName = ''
	SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

	WHILE @TableName IS NOT NULL
	== Visual Studio .NET 2003 (DO NOT COPY THIS LINE) ==
	Microsoft Visual Studio Solution File, Format Version 8.00
	# Visual Studio .NET 2003
	VisualStudioVersion = 7.1


	== Visual Studio 2005 (DO NOT COPY THIS LINE) ==
	Microsoft Visual Studio Solution File, Format Version 9.00
	# Visual Studio 2005
	VisualStudioVersion = 8.0
	#GenerateSelfSignedCert_2022.ps1
	# Information from: https://www.tutorialspoint.com/how-to-create-a-self-signed-certificate-using-powershell
	# Additional/Similar information from: https://petri.com/create-self-signed-certificate-using-powershell

	# Get Current Directory
	$curDir = Get-Location

	#Write Header
	Write-Host "`n WARNING: This script is provided AS-IS with no warranties and confers no rights." -ForegroundColor Yellow