Skip to content

Instantly share code, notes, and snippets.

View timabell's full-sized avatar
🍵
418 I'm a teapot

Tim Abell timabell

🍵
418 I'm a teapot
View GitHub Profile
@timabell
timabell / ms_descriptions.sql
Last active December 6, 2023 19:42
sql server description property management
/*
# About
Source: https://gist.github.com/timabell/6fbd85431925b5724d2f
Permanent copy of schema documentation in a format suitable for
easy source control and hand-editing.
This script template was created by Tim Abell, (c) 2015-2018
@timabell
timabell / data-duplicator.sql
Last active December 13, 2017 09:24
Script for copying data between databases
/*
Script for copying data between databases
Howto:
* Duplicate your database schema, but with all the FK constraints and identity specs removed (see below).
* Update the config at the top of this file.
* Connect to the target database.
* Run this script.

Subject: Follow your inner moonlight; don't hide the madness....

How was your bank holiday weekendTim? Did you manage to get up to any good mischief?

Through the words of Ginsberg, "follow your inner moonlight; don't hide the madness" and that is exactly what I am looking for, creative minds that shine through. Is that you? Are you the mad one which hides. If so then you are the person that I need to hear from.

A very interesting and intriguing position has arisen for a junior through to mid-weight ASP.Net, MVC .Net Developer to join a software house based in Winchester, salary would be paying up to £35k dependant on the right person with the right experience.

Due to winning a major new contract with one of the leading world banks they are looking to grow there team of 4 ASP.Net, MVC .Net Developer’s. This is a very exciting time to join this company, so if you are a ASP.Net, MVC .Net Developer looking to make your mark in the world of development then look no more, stop hovering your finger over the A

  1. failed to achieve goal of obtaining plans - due to the merry dance of trying to register taking all the time I had to achieve the task
  2. registration allowed me to enter a password (> 20 chars) that I was then unable to log in with (I can only guess that was the reason but based on what I saw and subsequent attempts to change it this seems the likely cause).
  3. error messaging on the login form was misleading, it said password was wrong - it wasn't, not helpful, and infuriating, compounding problem #2
  4. failure to use the PRG pattern means searching for plans and going back-and-forth results in lots of expired form submission warnings from the browser
  5. read this, do what it says, and the rest will solve itself http://www.amazon.co.uk/Dont-Make-Think-Revisited-Usability/dp/0321965515

other things I noticed; not the end of the world, but not good

  1. copyright 2008, seriously?
  2. url the size of a house - why can't I link to a plan? lame http://www.w3.org/Provider/Style/URI.html you've had ~20 years to
[2015-09-24T01:17:15.0220110+01:00:::PID 3940] Boxstarter: Boxstarter will use its own private version of Chocolatey...
Mode LastWriteTime Length Name
---- ------------- ------ ----
d----- 24/09/2015 01:17 chocInstall
[2015-09-24T01:17:15.5680243+01:00:::PID 3940] Boxstarter: Downloading http://chocolatey.org/api/v2/package/chocolatey/0.9.8.33 to C:\Users\tim\AppData\Local\Temp\chocolatey\chocInstall\chocolatey.zip
[2015-09-24T01:17:15.6305538+01:00:::PID 3940] Boxstarter: Attempt #1...
[2015-09-24T01:17:20.3023488+01:00:::PID 3940] Boxstarter: Downloading https://chocolatey.org/7za.exe to C:\Users\tim\AppData\Local\Temp\chocolatey\chocInstall\7za.exe
[2015-09-24T01:17:20.3023488+01:00:::PID 3940] Boxstarter: Attempt #1...
Installing chocolatey on thi
* daemon not running. starting it now on port 5037 *
* daemon started successfully *
--------- beginning of crash
F/libc ( 239): Fatal signal 11 (SIGSEGV), code 1, fault addr 0x20101 in tid 865 (Binder_1)
I/DEBUG ( 236): *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
I/DEBUG ( 236): Build fingerprint: 'google/occam/mako:5.1.1/LMY47V/1836172:user/release-keys'
I/DEBUG ( 236): Revision: '11'
I/DEBUG ( 236): ABI: 'arm'
I/DEBUG ( 236): pid: 239, tid: 865, name: Binder_1 >>> /system/bin/mediaserver <<<
I/DEBUG ( 236): signal 11 (SIGSEGV), code 1 (SEGV_MAPERR), fault addr 0x20101
@timabell
timabell / sql-fk-hierarchy.sql
Last active September 26, 2015 17:30
sql server script for finding all the parents of each table, and all the paths to them. http://sqlfiddle.com/#!6/1cf28b/1
-- find all the parents of every table, and all the paths to get to that parent
-- See it in action: http://sqlfiddle.com/#!6/1cf28b/1
with fkCte
as
(
select
cast(pa.name + ' > ' + ch.name as varchar(1000)) hrch,
fk.parent_object_id,
fk.referenced_object_id
from sys.foreign_keys fk
@timabell
timabell / diamond FK enforcement.sql
Last active September 28, 2015 04:14
get routes through a sql server fk structure - http://sqlfiddle.com/#!6/4364c/5

-- idea for making sure that diamond shaped relationships stay within the same parent
/*
-- what the diamond should like like
___ middleA-1 ___
/ \
parent-1 - - chiild-1
\ /

reposted here because the forum is a piece of shit and wouldn't let me post it. ~~

Hi, I've spent all day trying to get to the bottom of this with no luck so am reaching out for help.

I've just bought a galaxy s5 brand-new. Got it home, wiped it and flashed it with TWRP & CM 12.1. This worked fine and the phone behaves and is usable.

However; when I turn on encryption the phone encrypts the partition, reboots automatically and then never gets past the cyanogen logo and just sits there (left it overnight to see, was still stuck in the morning). I've tried several times, with/without adb/root enabled, and with/without connecting to the wireless lan.