Skip to content

Instantly share code, notes, and snippets.

@alexhiggins732
alexhiggins732 / SP_CreateFileStreamDatabase.sql
Last active May 20, 2019 14:36
SQL SPROC - Enable FILESTREAM and Create FILESTREAM Database
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: https://github.com/alexhiggins732
-- Create date: 5/18/2018
-- Description: Stored Procedure to Create a FILESTREAM enabled DATABASE. See the comments for instructions to enable FILESTREAM on the server
-- =============================================
CREATE PROCEDURE SP_CreateFileStreamDatabase
class Program
{
static void Main(string[] args)
{
HostConfiguration hostConfigs = new HostConfiguration()
{
UrlReservations = new UrlReservations() { CreateAutomatically = true }
};
using (var host = new NancyHost(hostConfigs, new Uri("http://localhost:8080")))
{
@alexhiggins732
alexhiggins732 / StaticNancyFXApiModule.cs
Last active May 28, 2019 06:01
Static NancyFX Api Module
class Program
{
static void Main(string[] args)
{
HostConfiguration hostConfigs = new HostConfiguration()
{
UrlReservations = new UrlReservations() { CreateAutomatically = true }
};
using (var host = new NancyHost(hostConfigs, new Uri("http://localhost:8080")))
{
@alexhiggins732
alexhiggins732 / MyDbContext.cs
Created May 28, 2019 21:00 — forked from hikalkan/MyDbContext.cs
How to map a dictionary property of an entity to a string field of a table in Entity Framework Core v2.1+
public class MyDbContext : DbContext
{
public DbSet<User> Users { get; set; }
public MyDbContext(DbContextOptions<MyDbContext> options)
: base(options)
{
}
@alexhiggins732
alexhiggins732 / .gitignore
Last active October 16, 2020 19:32
Search SQL Meta
## Ignore Visual Studio temporary files, build results, and
## files generated by popular Visual Studio add-ons.
# User-specific files
*.suo
*.user
*.userosscache
*.sln.docstates
# User-specific files (MonoDevelop/Xamarin Studio)
@alexhiggins732
alexhiggins732 / ShanghaiCCPMember.sql
Last active February 24, 2024 23:30
English version of Leaked database of 1.95 million Chinese Communist Party members
/*English version of the leaked database of 1.95 million Chinese Communist Party Members
that have infiltrated US and Western Companies, Government and Educational Institutions.
The report showed massive communist infiltration in Western firms and governments, including the United States
CSV Dataset can be dowloaded here: https://t.co/6I0SGZvRAX?amp=1
shanghai-ccp-member-ch-en.csv 511.2 MB
SHA256 Hash: AA376F6C18388E138ACCCCCB2D18FC72E9B40191BF89C5CC691157455353D0D5
*/

Solarwinds Orion Attack Vectors

Updated December 19th CISA advisory (retrieved from https://us-cert.cisa.gov/sites/default/files/publications/AA20-352A.stix.xml via https://twitter.com/kr3at)

Initial Access - Supply Chain Compromise - T1195

Adversaries may manipulate hardware components in products prior to receipt by a final consumer for the purpose of data or system compromise. By modifying hardware or firmware in the supply chain, adversaries can insert a backdoor into consumer networks that may be difficult to detect and give the adversary a high degree of control over the system. Hardware backdoors may be inserted into various devices, such as servers, workstations, network infrastructure, or peripherals.

Execution - Service Execution - T1035

Adversaries may execute a binary, command, or script via a method that interacts with Windows services, such as the Service Control Manager. This can be done by either creating a new service or modifying an existing service.

@alexhiggins732
alexhiggins732 / Fulton-ga-2020-elections.xml
Last active January 2, 2021 04:40
Fulton County Georgia 2020 Presidential Election Results
This file has been truncated, but you can view the full file.
<?xml version="1.0"?>
<!--Election result snapshot imported from Tabulation System
-->
<ElectionResult>
<Timestamp>11/18/2020 9:13:47 AM EST</Timestamp>
<ElectionName>November 3,2020-General Election</ElectionName>
<ElectionDate>11/3/2020</ElectionDate>
<Region>Fulton</Region>
<VoterTurnout totalVoters="806451" ballotsCast="528777" voterTurnout="65.57">
<Precincts>
@alexhiggins732
alexhiggins732 / gist:1c51dd185b0e27eb8d547d8d924c813e
Created January 24, 2021 04:07
Pulling from upstream master
If not set, add the upstream masters.
git remote add upstream https://github.com/iperov/DeepFaceLab.git
git pull upstream master
git status
git push origin master
@alexhiggins732
alexhiggins732 / download.bat
Created January 31, 2021 05:40
Download M3U8 TS with FFMPEG
ffmpeg -user_agent "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_5) AppleWebKit/601.7.8 (KHTML, like Gecko) Version/9.1.3 Safari/537.86.7" -i [Url to m3u8 file] -c copy nygard-16.mp4