Skip to content

Instantly share code, notes, and snippets.

View jmbeach's full-sized avatar
🏠

Jared Beach jmbeach

🏠
View GitHub Profile
IF OBJECT_ID ('SearchAllTables') IS NOT NULL
DROP PROCEDURE SearchAllTables
GO
CREATE PROC SearchAllTables
(
@SearchString nvarchar(100)
)
AS
@jmbeach
jmbeach / ssms-hotkeys.ahk
Created April 28, 2018 23:02
Hotkeys for SQL Server Management Studio
SetTitleMatchMode, REGEX
#IfWinActive, Microsoft SQL Server Management Studio$
; your hotstrings go here
^+t:: Send, declare @t varchar(200) = '<transaction name>' {enter}begin tran @t {enter}{enter}rollback tran @t
; kill connections
^+k:: Send, USE [master]{enter}DECLARE @kill varchar(8000) = ''{enter}SELECT @kill = @kill {+} 'kill ' {+} CONVERT(varchar(5), session_id){enter}FROM sys.dm_exec_sessions{enter}WHERE database_id = db_id('MyDB'){enter}EXEC(@kill);
@jmbeach
jmbeach / no-numlock.ahk
Created April 28, 2018 23:00
Turn off numlock in Windows
SetNumLockState, AlwaysOn
@jmbeach
jmbeach / explorer-shortcuts.ahk
Created April 28, 2018 23:00
Shortcuts for Windows explorer. Right now, just binds alt-down to enter
#IfWinActive ahk_class CabinetWClass
!Down::
; send alt
Send, {Enter}
@jmbeach
jmbeach / curly-keys.ahk
Created April 28, 2018 22:58
Use mac-style keybindings to type curly single and double quotes
!]::Send ‘
+!]::Send ’
![::Send “
+![::Send ”
@jmbeach
jmbeach / github-project-parser.js
Created April 20, 2018 15:22
Parses card tasks on a GitHub project. Useful for downloading the data
function CardManager() {
this.SEL_PROJECT_CARD = '.project-card'
this.ATTR_ASSIGNEE = 'data-card-assignee'
this.ATTR_AUTHOR = 'data-card-author'
this.ATTR_STATUS = 'data-card-state'
this.ATTR_TYPE = 'data-card-type'
this._parseAssignee = function(card) {
var raw = card.getAttribute(this.ATTR_ASSIGNEE)
if (!raw || typeof(raw) === 'undefined') return null
@jmbeach
jmbeach / todoist-progress.js
Last active January 19, 2019 16:49
show progress percentages on Todoist.com for multi-level tasks
function TaskManager() {
this.CLASS_NAME_TASK_ITEM = 'task_item'
this.SEL_TASK_ITEM = 'li.' + this.CLASS_NAME_TASK_ITEM
this.SEL_BASE_INDENT = 'indent_'
}
TaskManager.prototype.getTaskLevelSelector = function(level) {
return this.SEL_BASE_INDENT + level
}
@jmbeach
jmbeach / wikia.css
Created March 23, 2018 19:04
wikia custom css
html,.mediawiki,.TSddqdlwwG {
width: 100%
;
}
.WikiaSiteWrapper {
background-image: none;
background-color: white;
margin-top: -55px;
width: 100%;
@jmbeach
jmbeach / everything-winkey.ahk
Created November 20, 2017 17:51
Open the program "Everything" to search with Windows key
OpenEverything()
{
IfWinExist, Everything
{
WinActivate
return
}
Run, "C:\Program Files (x86)\Github\Wox\Everything\Everything.exe"
return
}
@jmbeach
jmbeach / infragistics client paging.js
Created November 1, 2017 20:41
Infragistics Client Paging
function updatePaging() {
$find('<%=yourgrid.clientid%>').get_behaviors().get_paging().updatePager(
getPageSize(),
getPageIndex(),
getPageCount())
}
function getSequencePageCount() {
var count = getResultsCount() / getPageSize()
if (count <= 0=) {