SQLite

Phil Hack

Aug 31, 2014 • 1 min read

SQLite Syntax Reference
SQLite Docs

Sign up for more like this.

Enter your email

Subscribe

Building a Yeoman webapi microservice template

References Yeoman with ASP.NET Attempt1: Installation of existing ASP.NET template Installs the .net dmx: 1.0.0.0rc1 Install Yo Update NPM: npm install -g npm npm install -g yo bower grunt-cli gulp Install the asp.net generator: npm install -g generator-aspnet Run ASP.NET Template yo aspnet

Phil Hack Nov 23, 2017 • 2 min read

Git Diffs

The file names that changed between 2 commits git whatchanged 11d5b2894f98350eccef85f15c47510361f6691e c94027d16d121418560431330b727bbddb0dd3ca | cat > /c/Temp/out.txt The contents that changed between 2 commits git diff --patch 11d5b2894f98350eccef85f15c47510361f6691e c94027d16d121418560431330b727bbddb0dd3ca | cat > /c/Temp/out.txt

Phil Hack May 4, 2017 • 1 min read

SQL Azure

Determine which user is assigned to which role Run this on your target database in Azure (ie: not against the master database) select m.name as Member, r.name as Role from sys.database_role_members inner join sys.database_principals m on sys.database_role_members.member_principal_id

Phil Hack Mar 15, 2017 • 1 min read

Powered by Ghost