mrkaminski77 Goto Github PK

create-audittrigger

Create a table with user id, add triggers to log updates and deletes.

davidkaminski

Résumé

document-generator

transform markdown in to docx using dotx template

excel_adodb

collection of routines and functions used to talk to SQL Server from Excel VBA

excel_displaypanelmodule

Sometimes you want to display information on a worksheet using shapes instead of cells. This displays contents of a VBA Dictionary.

excel_menubuilder

An old project used to add navigation menu to Excel workbook

invoke-sql

modified version to use data views (compatible with out-gridview)

jscript-powershell

JScript functions for executing Powershell. Used in .hta projects.

jscript-recursivereplace

use JScript to recursives replace strings in folders....you could just user Powershell these days.

markdown-docx

convert an online markdown file into a docx using specified template.

mergegenerator

A very early python project before I really understood how to use SMO. I will be re-writing this in powershell.

mssql-doctor

Framework for automation production of database documentation based on SQL Server extended properties.

tsql-compareobjects

Use WinMerge and SQLCMD to open files objects for comparison.

tsql-intervalduration

return the number of minutes interval overlaps another interval

tsql-overlap

Detects overlaps between ranges - used as a check constraint.

worksheet-domo

worksheet_pivottableupdate

This is my VBA Event handler for the PivotTable update event. It's used to reformat the Pivot Table.