All Posts

Ansible Proxmox Vm Config

under Ansible Proxmox

Looking for a way to get Proxmox VM configuration in ansible? The community.general.proxmox_kvm module doesn’t have a qm config output, but you can use the Rest API to find out all current configuration.

Least Common Multiple Vect Rust

under Programming Rust Advent of Code

Non-recursive least common multiple function for multiple (vec) numbers in Rust.

Anova Table Solver

under Calculator Statistics

Simple javascript solver for ANOVA tables from set of known values. Values entered show in red. You can reset by reloading the page

Advent Of Code Input Parsing

under Programming Rust Advent of Code

With 2021 done, wanted to go back and put together a gist list of the input parsing, using standard crate Rust, for future reference

Simple Rss Feed With Jekyll

under Programming Jekyll

With moving my site off of Wordpress, I landed on Jekyll, but wanted to add an RSS feed option. Here is a simple way, without plugins. One of its example Generator plugins for Jekyll is their jekyll-feed plugin, used as a reference for those creating similar style file generation. Since I am Gemfile less currently, I really didnt want to add another configuration item, and it dawned on me…just build the RSS feed using templates and liquid!

Advent Of Code Day 9 Visualization

under Programming Rust Advent of Code

Day 9 done…thought it might be fun to visualize today’s solution (breadth-first search within a map space) with some holiday-themed 16 color ANSI console art! Happy coding!

Advent Of Code 2021 Begins Today

under Programming Rust Advent of Code

Advent of Code 2021 begins today! Goal for this year is to learn Rust-lang, and complete every challenge the same day released. Follow over on Github

Presenting At The Sql Server Pass Detroit User Group In November

under Presenting SQL Server

In or around Detroit? Come see my Getting Started with Machine Learning session at the Detroit PASS User Group Thursday, November 8th at 6 PM.

Sql Saturday Denver 2018

under Presenting SQL Server

Come see my presentation on Machine Learning Server for SQL Server at SQL Saturday Denver

Third Times The Charm Back At Sql Saturday Indy And Louisville Three Years In A Row

under

Two years running, I will be presenting at SQL Saturday Indy and SQL Saturday Louisville this year again! Come see my session on Getting Started with Machine Learning

Backup Visualsvn Using Powershell

under Programming PowerShell

Quick and easy backup for VisualSVN. Wraps the svnadmin.exe and performs a hotcopy of all repositories in the $source_path, dumping them to the $backup_path

Sql Saturday Wheeling 2018

under Presenting SQL Server

Third time in a month, I will be presenting Machine Learning Server, this time a

Machine Learning Server At The Cbuspass User Group

under Presenting SQL Server

Come out Thursday, April 12 to learn how to leverage Microsoft Machine Learning Server.

Sql Saturday Madison 2018

under Presenting SQL Server

Come out to see how to leverage Microsoft Machine Learning Server

Back At Sql Saturday Louisville And Indy

under Presenting SQL Server

Two years running, I will be presenting at SQL Saturday Indy and SQL Saturday Louisville this year again! Come see my SQL Server 2017 (Linux and Beyond) and Stretch Database and Managed Backups

Sql Saturday Chattanooga 2017

under Presenting SQL Server

Second of the year, I will be presenting at SQL Saturday Chattanooga 2017. Come see my SQL Server 2017 (Linux and Beyond) session

Sqlsaturday Rochester 2017

under Presenting SQL Server

Come to SQL Saturday Rochester 2017, and see both of my sessions, Stretch Database and Managed Backups: Cloud Services for your SQL Servers and SQL Server vNext (Linux and Beyond)

I Am Speaking At Sql Saturday Pittsburgh 2016

under Presenting SQL Server

I will be presenting my third SQLSaturday session at the upcoming Pittsburgh #545 Saturday, Aug. 13th, 2016. My session, Stretch Database and Managed Backups: Cloud Services for your SQL Servers, is a beginner track session going through the setup, configuration, usage and some real-world usage scenarios for both of these recently added features to the SQL Server product. Have you registered yet? Why not?

I Am Speaking At Sql Saturday Indy 2016

under Presenting SQL Server

That’s right, back-to-back roll. I will be presenting my second SQLSaturday session at the upcoming Indianapolis #530, Saturday, Aug. 13th, 2016. My session, Stretch Database and Managed Backups: Cloud Services for your SQL Servers, is a beginner track session going through the setup, configuration, usage and some real-world usage scenarios for both of these recently added features to the SQL Server product. Have you registered yet? Why not?

I Am Speaking At Sql Saturday Louisville 2016

under Presenting SQL Server

That’s right. My way of giving back to the SQL Server community, I am presenting my first SQLSaturday session at the upcoming Louisville #531, Saturday, Aug. 6th, 2016. My session, Stretch Database and Managed Backups: Cloud Services for your SQL Servers, is a beginner track session going through the setup, configuration, usage and some real-world usage scenarios for both of these recently added features to the SQL Server product. Have you registered yet? Why not?

Testing Restful Apis With Curl

under Programming Gist

Ultra simple way to test a JSON API POST response using curl

My Chocolatey List

under Programming Gist

You know what Chocolatey is, right?

Hyper V Backup Script

under Programming PowerShell

The following powershell script creates snapshots or exports of VMs on the local, and performs retention/cleanup as well. Be forewarned. There are known bugs with the current hyper-v snapshot integration and *nix systems.

60 Second Ipa

under Homebrew

My clone of nothing…just 60 seconds of hopping involved, how much easier could it be.

Make Servicenow Soap Calls With Powershell

under Programming PowerShell ServiceNow

The following PS script shows how to query ServiceNow via SOAP calls, using the WebServiceProxy object. View their Wiki for more examples of service methods

Synchronize File Timestamps

under Programming PowerShell

To synchronize file timestamps (creation, last access and last write) of two directory trees.

Get Last Logon Time For All Users In An Ad

under Programming PowerShell

Utilizing the ActiveDirectory module, this returns user names with last logon time stamp

Atmega328p At 3 3v

under Programming Arduino

Venturing down the path of low voltage Atmega (Arduino)? The following references the two steps (set your fuses and add a board entry) to allow you to use an off-the-shelf 328p “naked” and at very low voltage ranges (disabling brown-out).

Copy File Contents To The Clipboard

under Programming Windows Gist

Via right click (context menu) within Explorer, save the following to a .reg registry key file.

Run Powershell Script Via Command Line Or Task Scheduler

under Programming PowerShell Gist

To schedule PowerShell scripts to run via command line (or as a Task Scheduler task), using the following syntax:

Find Top Largest Files Via Powershell

under Programming PowerShell Gist

Get-ChildItem -Recurse | Sort-Object Length -Descending | Select FullName, Length -First 10

Crim 2012

under Running

Year Pace Time
2012 8:28 1:24:46
2011 8:43 1:27:11
2010 9:30 1:35:06
2009 9:05 1:30:54
2008 10:20 1:43:29

Powershell Full Database And Transaction Log Backup Script Works With Sqlexpress

under Programming PowerShell Gist

Loosely based off of other examples I found, this script will perform full database backups of all databases or tran log backups of all full/bulk-logged databases. In addition, it will utilize the default backup path (if one is not given), and delete old backup files (that conform to the file naming convention) that are older than a given number of retention hours (default to 48 hours): Examples:

Canton Marathon 2012

under Running

Time Pace Place
3:59:23.6 9:07 260/906

Create Local Admin User With Password Set To Never Expire

under Windows PowerShell Gist

The following script will create a local computer users in windows, set it’s password, mark the password to not expire and optionally set the description:

Modify Sql 2008 R2 Generated Configuration File For Unattended Installs

under SQL Server PowerShell Gist

After walking through the installation GUI, copy the Configuration File Path on the ‘Ready To Install’ page. Copy and modify this file in the following order to generate a repeatable unattended install process:

Check Mirror And Witness Status Before Rebooting

under SQL Server PowerShell Gist

The following script, meant to run as part of a pre-check for automated reboots, will check that all mirrored databases are in a Synchronized status and the witness is in a Connected status. If the above conditions are true, the script returns a 0 exit code, otherwise, it returns < 0.

Add Usergroup To Local Administrators Group

under Windows PowerShell Gist

The follow will prompt to add a given domain user/group to local admins on multiple boxes

Meatball Madness 5k 2011

under Running

Year Pace Time
2011 7:23 22:58

Deweese Park 5k 2011

under Running

Year Pace Time
2011 7:45 24:06

Holiday At Home 2011

under Running

Year Pace Time
2011 7:30 23:19
2010 7:51 24:26

Sugar Maple 5k

under Running

Year Pace Time
2003 10:22 32:12
2011 7:40 23:52

Tortisesvns Revision In As Version Number In Net

under SVN Gist

From scavaging the around the web, I pieced together the follow steps to setup TortiseSVN’s revision number (aka subwcrev) and time stamp as part of the assembly version.

2011 Frostbite 5

under Running

Year Pace Time
2011 8:42 43:32

Mt Lemon 2010

under Cycling

No Ski Valley this year…the climb:

Miami Valley School Run For The Rams 2010

under Running

Year Pace Time
2007 12:50:19 39:48:00
2008 8:30:39 26:23:00
2009 8:21:37 25:55:00
2010 8:18:00 25:40:00 – Actual distance was 3.5 mi (29:03)

Richter Saffin Ave Steepest Road In Cincinnati

under Cycling

Made it about 90% up the hill before I nearly had a heart attack at 202 bpm. 39 x 25 no good for climbs like this. Stats…

Coney Dog From American Coney In Downtown Detroit

under Food

American Coney

Do The Needful American Ipa

under Homebrew

Brew #3 is in bottles and ready…and American IPA

Defrag All Harddrives

under Windows PowerShell

The version of defrag that comes with most recent installs of Windows does not allow for scheduling…to get around this limitation, the following VBScript will enumerate all fixed harddrives on a machine, and launch defrag via command like for that drive. Set it up as a scheduled task and forget about it.

Extract Der Format X 509 Public Certificate From Iis 4 Pfx

under Windows Perl

IIS 4 certificate files usually contain both the private key and public certificate for SSL. To convert these to RSA private key and x.509 public certificates from NET to DER format, you need to manually edit the binary key file as documented on te’s site then run the following OpenSSL commands:

Print A List Of All Files Including Directories

under Programming Perl Gist

Writes list of all files and subdirectories for a given path to standard output. Not really useful on it’s own, but recurse subroutine is a good base to recursive file processing.

Convert Text File To Html Txt2html

under Programming Perl Gist

Converts text files to properly encoded HTML form.

Change File Extensions

under Programming Perl Gist

This script will append an extension to the end of the given files, optionally removing any existing extensions. Don’t ask me why I wrote this, must have been important at one point in time. Alot easier to do this via find in un*x. Giving the following files in a directory: