William Shelley cathode
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Query object mappings to find objects that should be active. | |
| var active = context.Objects | |
| .Join(context.ObjectSets | |
| .Join(context.Databases | |
| .Where(e => e.Environment == this.CurrentEnvironment), | |
| set => set.DatabaseId, | |
| database => database.DatabaseId, | |
| (set, database) => new | |
| { | |
| ObjectSetId = set.ObjectSetId, |
cathode
/ compare.sql
Last active
June 10, 2016 21:03
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- UDF definition: | |
| CREATE FUNCTION [dbo].[GetSessionParameter] | |
| ( | |
| @key nvarchar(255), | |
| @defaultValue nvarchar(MAX) = null | |
| ) | |
| RETURNS NVARCHAR(MAX) | |
| AS | |
| BEGIN | |
| DECLARE @Ret as NVARCHAR(MAX) |
cathode
/ nightmare.sql
Created
May 19, 2016 20:27
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| [TargetCompleteDate] - 21 AS [ActionReqd], | |
| [S1].[Qid], | |
| [S1].[JBGid], | |
| [Manufacturers].[FacilityName], | |
| [S1].[Qty], | |
| [S1].[Description], | |
| [S1].[SubDescription] | |
| FROM | |
| ( |
cathode
/ gist:cc54415f7ffb27480d12cfa25f3cb2e5
Created
May 18, 2016 20:31
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE [dbo].[SessionParameters] | |
| ( | |
| [SessionId] SMALLINT NOT NULL, | |
| [PKey] NVARCHAR(128) NOT NULL, | |
| [PValue] NVARCHAR(MAX) NULL, | |
| CONSTRAINT [PK_SessionParameters] PRIMARY KEY ([SessionId], [PKey]) | |
| ) | |
| GO |
cathode
/ backup_to_nas.py
Created
May 9, 2016 22:44
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/local/bin/python3.4 | |
| # ZFS backup to NAS script | |
| import sys | |
| import os | |
| import socket | |
| import subprocess | |
| # bring in custom/shared stuff | |
| import hatools |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # /usr/local/etc/smb4.conf | |
| # Samba 4.1 Configuration file | |
| [global] | |
| # SPECIFIC SETTINGS FOR THIS MACHINE | |
| netbios name = ZNAS1 | |
| # Basic settings | |
| workgroup = MYDOMAIN | |
| realm = MYDOMAIN.local |
cathode
/ gist:1803d50ea8594517a140
Created
February 18, 2016 00:14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@zfs-primary:~ # smartctl -x /dev/ada0 | |
| smartctl 6.4 2015-06-04 r4109 [FreeBSD 10.2-RELEASE-p9 amd64] (local build) | |
| Copyright (C) 2002-15, Bruce Allen, Christian Franke, www.smartmontools.org | |
| === START OF INFORMATION SECTION === | |
| Model Family: Intel 730 and DC S3500/S3700 Series SSDs | |
| Device Model: INTEL SSDSC2BB240G4 | |
| Serial Number: CVWL4226033L240NGN | |
| LU WWN Device Id: 5 5cd2e4 04bc7ad54 | |
| Firmware Version: D2010370 |
cathode
/ gist:e0123d1b25fe2ccf03a2
Created
February 16, 2016 23:10
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Allow samba to properly store NTFS-style ACLs | |
| map archive = no | |
| map readonly = no | |
| map hidden = no | |
| map system = no | |
| nfs4: mode = special | |
| nfs4: acedup = merge | |
| nfs4: chown = yes | |
| zfsacl:acesort = dontcare |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ---- Minecraft Crash Report ---- | |
| // Hey, that tickles! Hehehe! | |
| Time: 2/10/16 10:15 PM | |
| Description: Updating screen events | |
| java.lang.NullPointerException: Updating screen events | |
| at net.minecraft.item.crafting.ShapelessRecipes.func_77572_b(SourceFile:54) | |
| at net.minecraft.item.crafting.CraftingManager.func_82787_a(CraftingManager.java:325) | |
| at net.minecraft.inventory.ContainerPlayer.func_75130_a(ContainerPlayer.java:80) |
cathode
/ messages.txt
Created
February 9, 2016 05:54
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Feb 9 21:53:06 zsan1 kernel: mpr0: log_info(0x3112010c): originator(PL), code(0x12), sub_code(0x010c) | |
| Feb 9 21:53:06 zsan1 kernel: (da4:mpr0:0:4:0): READ(10). CDB: 28 00 1d 71 7c 0b 00 00 b5 00 length 92672 SMID 740 terminated ioc 804b scsi 0 state c xfer 131072 | |
| Feb 9 21:53:06 zsan1 kernel: mpr0: log_info(0x3112010c): originator(PL), code(0x12), sub_code(0x010c) | |
| Feb 9 21:53:06 zsan1 kernel: (da4:mpr0:0:4:0): READ(10). CDB: 28 00 1d af a9 c6 00 00 07 00 length 3584 SMID 626 terminated ioc 804b scsi 0 state c xfer 1024 | |
| Feb 9 21:53:06 zsan1 kernel: mpr0: log_info(0x3112010c): originator(PL), code(0x12), sub_code(0x010c) | |
| Feb 9 21:53:06 zsan1 kernel: (da4:mpr0:0:4:0): READ(10). CDB: 28 00 1e 17 e1 7e 00 00 3d 00 length 31232 SMID 488 terminated ioc 804b scsi 0 state c xfer 512 | |
| Feb 9 21:53:06 zsan1 kernel: mpr0: log_info(0x3112010c): originator(PL), code(0x12), sub_code(0x010c) | |
| Feb 9 21:53:06 zsan1 kernel: (da4:mpr0:0:4:0): READ(10). CDB: 28 00 1d 71 7c 0b 00 00 b5 00 length 92672 SMID 503 terminated ioc 80 |