hlsupe

List all Sql Agent Jobs with their schedules

use msdb;
go
declare @weekDay table
    (
        mask      int,
        maskValue varchar(32)
    );

hlsupe

Git Tricks

Creating command aliases

If you have trouble remembering git commands or if you are tired of typing (searching for) the repository link, define aliases.

alias gclone='git clone https://github.com/yourFavoriteRepository'
alias gshowclean='git clean -nfd'
alias gclean='git reset --hard;git clean -fd'

and add to ~/.bash_profile, if you run git bash.

hlsupe

Regular Expressions Cheetsheet

Look ups

Look ahead positive A(?=B) Find expression A where expression B follows.
Look ahead negative A(?!B) Find expression A where expression B does not follow.
Look behind positive (?<=B)A Find expression A where expression B precedes.
Look behind negative (?<!B)A Find expression A where expression B does not precede.

hlsupe

Running Total

This is an abstract version of a problem I ran into once.

I have this table which stores containers by region and the number of coffee pouches in each of the containers.

if object_id( 'dbo.Container' ) is not null
    drop table dbo.Container
go

hlsupe

What are Registered Servers?

Refer to Register Servers to get familiar with registered servers.

What does the script do?

Creates a registered servers group as

	Dev
		ProductCatalog

FulfillmentCenter

hlsupe

Bash Commands

Some of my grep, sed, find and file commands. These are from my personal use and are not supposed to serve as an exhaustive reference.

grep

1. Find files where lines contain this but not that

   grep --include \*.txt -ri . -P -e '^((?!that).)*this((?!that).)*$'