Skip to content

Instantly share code, notes, and snippets.

View jpann's full-sized avatar
Always learning.

Jonathan Panning jpann

Always learning.
  • United States
View GitHub Profile
jpann / Install-Latest-rdpwrap.ps1
Last active January 4, 2024 20:14
(Script) How to add the ability to Remote Desktop into Windows 11 Home Edition
Downloads the latest sebaxakerhtc/rdpwrap installers from GitHub.
Downloads the latest sebaxakerhtc/rdpwrap installers from GitHub
and copies them into the "C:\Program Files\RDP Wrapper" folder
and executes the installer.
If Windows Defender is enabled, "C:\Program Files\RDP Wrapper"
jpann / .gitconfig
Last active December 7, 2023 20:08
defaultBranch = main
[filter "lfs"]
clean = git-lfs clean -- %f
smudge = git-lfs smudge -- %f
process = git-lfs filter-process
required = true
default = simple
jpann / Get-SqlServerKeys.ps1
Last active January 24, 2024 18:11 — forked from mtrimarchi/Get-SqlServerKeys.ps1
Get-SqlServerKeys with support for SQL Server 2019
Function Get-SqlServerKeys {
Gets SQL Server Product Keys from local and remote SQL Servers. Works with SQL Server 2005-2019
Using a string of servers, a text file, or Central Management Server to provide a list of servers, this script will go to each server and get the product key for all installed instances. Clustered instances are supported as well. Requires regular user access to the SQL instances, SMO installed locally, Remote Registry enabled and acessible by the account running the script.
Uses key decoder by Jakob Bindslet (
jpann / NancyThrottling.cs
Created February 26, 2019 22:52
nancy throttling
using System;
using System.Runtime.Caching;
using Bootstrapper;
public class Home : NancyModule
public Home()
Get["/"] = parameters => {
return "Hi";
jpann / SqlUtil.cs
Last active March 14, 2019 21:01
SqlUtil class to make querying a SQL Server database easier and more contained.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace Utilities
public static class SqlUtil
jpann / gist:7063765
Last active December 26, 2015 00:19
Playing around with a new SqlUtil class.
void Main()
var count = SqlUtil.ExecuteScalar<int>("SELECT COUNT(SSRSReports) FROM SSRSReports");
Console.WriteLine("count = " + count);
var reports = SqlUtil.ExecuteQueryReader<SSRSItem>("SELECT * FROM SSRSReports WHERE IsSubReport <> 'N'", c => SSRSItem.LoadFromRecord(c));
foreach (var report in reports)