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
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
<#
.SYNOPSIS
Downloads the latest sebaxakerhtc/rdpwrap installers from GitHub.
.DESCRIPTION
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
jpann / .gitconfig
Last active December 7, 2023 20:08
.gitconfig
[init]
defaultBranch = main
[filter "lfs"]
clean = git-lfs clean -- %f
smudge = git-lfs smudge -- %f
process = git-lfs filter-process
required = true
[push]
default = simple
[core]
@jpann
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 {
<#
.SYNOPSIS
Gets SQL Server Product Keys from local and remote SQL Servers. Works with SQL Server 2005-2019
.DESCRIPTION
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 (http://goo.gl/1jiwcB)
@jpann
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
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
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)
{
Console.WriteLine(report);
}