developerprofiles

<#
.SYNOPSIS
  Runs a select with on the specified table with the specified columns 
  and writes the result to a CSV file.
  
.DESCRIPTION
  This function calls the connection passed as a parameter and sends a
  SELECT command to it. The table on which the SELECT is run as well as
  the selected columns are passed as a parameter.
  

developerprofiles

Some Jenkinsfile examples

developerprofiles

#
# Script to start, stop, restart Jekyll Dev Environment container
#

# Set default parameter set
[cmdletbinding(DefaultParameterSetName='container')]

# Intialize parameters
param (
	[Parameter(Mandatory = $true)]

developerprofiles

#
# Script to start, stop, restart Jekyll Dev Environment container
#

# Set default parameter set
[cmdletbinding(DefaultParameterSetName='container')]

# Intialize parameters
param (
	[Parameter(Mandatory = $true)]

developerprofiles

Alternatives to the "Atlassian Stack"

Fuller stack alternatives (replaces at least two of the Atlassian stack)

• Phabricator

• Github

• Gitlab

• Taiga

• Redmine

developerprofiles

# SQL Sever & firewall  : https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access
# New-NetFirewallRule : https://docs.microsoft.com/en-us/powershell/module/netsecurity/new-netfirewallrule?view=win10-ps

New-NetFirewallRule -DisplayName "SQLServer default instance" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow
New-NetFirewallRule -DisplayName "SQLServer Browser service" -Direction Inbound -LocalPort 1434 -Protocol UDP -Action Allow

developerprofiles

title	subtitle	author	date	source
Build, Publish and Deploy ASP.NET Web Applications from the Command Line	How to use the MSBuild (or dotnet) command to build, publish, deploy ASP.NET web applications from the command line.	Microsoft	December 12, 2019	https://jonlabelle.com/snippets/view/markdown/build-publish-and-deploy-aspnet-web-applications-from-the-command-line

Folder publish (Cross-platform)

developerprofiles

title	author	date	source	snippet	gist
MSBuild Version Properties Cheatsheet	natemcmaster	September 18, 2019	https://stackoverflow.com/questions/42183300/what-is-the-difference-between-various-msbuild-version-properties-such-as-versi	https://jonlabelle.com/snippets/view/markdown/msbuild-version-properties-cheatsheet	https://gist.github.com/jonlabelle/34993ee032c26420a0943b1c9d106cdc

Based on Stack Overflow

developerprofiles

#!/usr/bin/env bash

#
# Bash wrapper script for the .NET Format global CLI tool.
#
# Author........: Jon LaBelle
# Date..........: February 4, 2021
# Snippet.......: https://jonlabelle.com/snippets/view/shell/net-format-bash-wrapper-script
# Gist..........: https://gist.github.com/jonlabelle/a0751768a220274a90d4be498da51643
# .NET Format...: https://github.com/dotnet/format

developerprofiles

title	subtitle	date	source	snippet	gist	notoc
.NET Unit Test Framework Translation Cheatsheet	Compares popular .NET Unit Test Frameworks usages with their respective counterparts.	January 27, 2021	https://www.automatetheplanet.com/mstest-cheat-sheet/	https://jonlabelle.com/snippets/view/markdown/net-unit-test-framework-translation-cheatsheet	https://gist.github.com/jonlabelle/9afa182a1ecc2bfaac42a6586e45f292	true