Steve Withington stevewithington

Powershell: Create/Add Windows System DSN via `.CSV` Import

You can create/add/update/get a Windows System DSN pretty easily with Powershell.

Database, SystemDSN, Server
AAA, AAA_DSN, SomeIP\User

If you don't already have an existing gist, you'll need to create one before proceeding.

git clone https://gist.github.com/<hash>.git # via https
git clone [email protected]:<hash>.git     # via ssh

Outlook version(s)	Code
All Windows Outlook (Most common)	`<!--[if mso]> your code <![endif]-->`
Outlook 2000	`<!--[if mso 9]> your code <![endif]-->`
Outlook 2002	`<!--[if mso 10]> your code <![endif]-->`
Outlook 2003	`<!--[if mso 11]> your code <![endif]-->`
Outlook 2007	`<!--[if mso 12]> your code <![endif]-->`
Outlook 2010	`<!--[if mso 14]> your code <![endif]-->`

Some useful commands for Git.

git tag -a v1.0.0 -m 'v1.0.0'
git push origin --tags # To push tags to Github

	# get latest tag for the current branch
	git describe --tags
	# outputs > v..*-{hash}

	# get latest tag for the current branch without the hash
	git describe --tags --abbrev=0
	# outputs > v..*

	# get latest tag across all branches
	git describe --tags $(git rev-list --tags --max-count=1)

	/*
	Example of how to update a table in SQL using a Common Table Expression (CTE)
	*/

	USE [SomeTable]
	GO

	;WITH cte AS (
	SELECT te.LandEntityId, te.BirthDate, te.BirthDateId, dd.DateId
	FROM TypedEntity te

	SET ANSI_NULLS ON
	GO
	SET QUOTED_IDENTIFIER ON
	GO
	-- =============================================
	-- Author: <[email protected]>
	-- Create date: 2020.12.21
	-- Description: Convert string to DATE if NULL or invalid, else set to '0001-01-01'
	-- =============================================
	CREATE FUNCTION [dbo].[udf_ConvertStringToDate]

	<?xml version="1.0" encoding="UTF-8"?>
	<configuration>
	<system.webServer>
	<rewrite>
	<rules>
	<clear />
	<!-- `stopProcessing` is irrelavent for `redirect` rules -->

	<rule name="MAINTENANCE MODE" enabled="true">
	<match url="^(.*)$" ignoreCase="true" />