mwwhited

CREATE FUNCTION [dbo].[LongestCommonPrefix]
(
	 @word1 NVARCHAR(MAX)
	,@word2 NVARCHAR(MAX)
)
RETURNS NVARCHAR(MAX)
WITH SCHEMABINDING
AS
BEGIN
    RETURN (

mwwhited

• Eater 6502 computer

  • 6502 Computer kit
  • Serial Kit
  • Complete Kit

• Eater 8bit computer kit

  • Complete kit

• Compdyna GP-6 analog computer

• TI-99/4a computer

• Clones & Replicas

mwwhited

Matthew Whited

Profile Links

• Github
  • Microcontrollers, Arduino, FPGA
  • Coding Challenges: Algorithms and Services
• Stack Exchange
• Stack Overflow
• NPM

mwwhited

Add versioning to SQL Server Projects

Summary

This is a basic set of instructions on how to add version number support for SQL Server projects and databases. This will will add the version number as an extended property on the deployed database.

How to access version number

mwwhited

Useful Links

AI/ML

• Who Answers It Better? An In-Depth Analysis of ChatGPT and Stack Overflow Answers to Software Engineering Questions

mwwhited

SET SONARQUBE_KEY=XXX
SET SONARQUBE_TOKEN=YYY

dotnet tool restore

echo "Git fetch"
git fetch --prune
FOR /F "tokens=* USEBACKQ" %%g IN (`dotnet gitversion /output json /showvariable FullSemVer`) DO (SET BUILD_VERSION=%%g)
if "%BUILD_VERSION%"=="" GOTO error

mwwhited

<Project>
  
  <PropertyGroup Condition="'$(SolutionDir)' == ''">
    <!-- Resolve solution dir if not set -->
    <SolutionDir Condition="'$(SolutionDir)' == '' and $([System.IO.Directory]::GetFiles('../', '*.sln').get_Length()) != 0">../</SolutionDir>
    <SolutionDir Condition="'$(SolutionDir)' == '' and $([System.IO.Directory]::GetFiles('../../', '*.sln').get_Length()) != 0">../../</SolutionDir>
    <SolutionDir Condition="'$(SolutionDir)' == '' and $([System.IO.Directory]::GetFiles('../../../', '*.sln').get_Length()) != 0">../../../</SolutionDir>
    <SolutionDir Condition="'$(SolutionDir)' == '' and $([System.IO.Directory]::GetFiles('../../../../', '*.sln').get_Length()) != 0">../../../../</SolutionDir>
    <SolutionDir Condition="'$(SolutionDir)' == '' and $([System.IO.Directory]::GetFiles('../../../../../', '*.sln').get_Length()) != 0">../../../../../</SolutionDir>
    <SolutionDir Condition="'$(SolutionDir)' != ''">$([System.IO.Path]::GetFullPath('$(SolutionDir)'))</SolutionDir>

mwwhited

[credential "https://source.developers.google.com"]
    useHttpPath = true
[user]
    name = Matthew Whited
    email = matt@whited.us
[core]
    excludesfile = 
[difftool "sourcetree"]
    cmd = '' \"$LOCAL\" \"$REMOTE\"
[mergetool "sourcetree"]

mwwhited

# %USERPROFILE%\.wslconfig
# https://learn.microsoft.com/en-us/windows/wsl/wsl-config

[wsl2]
# If the value is mirrored then this turns on mirrored networking mode. Default or unrecognized strings result in NAT networking.
networkingMode=mirrored

# Only applicable when experimental.networkingMode is set to mirrored. When set to True, will allow the Container to connect to 
# the Host, or the Host to connect to the Container, by an IP address that's assigned to the Host. Note that the 127.0.0.1 
# loopback address can always be used - this option allows for all additionally assigned local IP addresses to be used as well.

mwwhited

# https://learn.microsoft.com/en-us/dotnet/fundamentals/code-analysis/code-style-rule-options

###############################
# Core EditorConfig Options   #
###############################
root = true
# All files
[*]
indent_style = space