JamesSkemp

# Can only be run within a Git repository, but this will also search untracked files, as well as those that are tracked.
git grep --untracked '<term>'

JamesSkemp

Application Settings

Extensions

• Add jsdoc comments
• C#
• C# XML Documentation
• Cordova Tools
• PowerShell
• seti-icons

JamesSkemp

CREATE VIEW authorizer.ElevatedUserSiteRoles
AS
/*
DESCRIPTION: Used to display all elevated users with their specific site roles.
	CALLED BY: SSMS.
*/
SELECT u.Id AS UserId, u.NetId, u.Added, u.SiteId, s.WiscWebId, s.Name AS SiteName, s.Url, s.DefaultRole, s.RequireWsb, u.RoleId, r.Name AS RoleName, r.[Description]
FROM authorizer.ElevatedUser u
	LEFT JOIN authorizer.WiscWebSite s ON u.SiteId = s.Id
	LEFT JOIN authorizer.AccessRole r ON u.RoleId = r.Id

JamesSkemp

LINQPad query to take a listing of emails, with some items containing comma-delimited list of emails, and finds distinct ones.

var emails = new List<string>()
{
"[email protected]",
"[email protected], [email protected]",
"[email protected]"
};

JamesSkemp

Move files into a subdirectory, Mac OS X.

for f in *.32x; do mv "$f" 32X; done

JamesSkemp

Mac OS X

A 7-zip clone can be installed via brew.

brew install p7zip

Extract all **.7z archives in a directory, keeping paths

for file in *.7z; do 7z x "$file"; done

Extract all **.7z archives to a subdirectory, keeping paths

JamesSkemp

Background

We currently have a Visual Studio solution with two projects: one for our main site, using Web forms, and one for utilities, which is currently Extension methods on Item. (The latter project has been in the queue to migrate to a NuGet package on our local NuGet server.)

Running Sitecore 8.1.160519.

Initial setups

1. Add solution folders to the existing project.
   1. Configuration
   2. Feature
   3. Foundation

JamesSkemp

REM Must point to the installer. In this case it was the full installer.
REM From https://msdn.microsoft.com/en-us/library/mt653628.aspx
vs_professional.exe /OverrideFeedURI http://download.microsoft.com/download/0/6/B/06BB0C5C-C767-4250-91DA-AB463377597E/20160405.3/enu/feed.xml

JamesSkemp

1. Install Visual Studio Code.
2. Install iTerm2.
   • Activate gitfast plugin.
     • vi ~/.zshrc and add gitfast on plugins line.
3. Setup SSH key for git.
   • ssh-keygen -t rsa
   • pbcopy < ~/.ssh/id_rsa.pub
4. Turn on hidden files in Finder
   • defaults write com.apple.finder AppleShowAllFiles YES
   • Hold the 'Option/alt' key, then right click on the Finder icon in the dock and click Relaunch.

JamesSkemp

<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <WebPublishMethod>FileSystem</WebPublishMethod>
    <LastUsedBuildConfiguration>Release</LastUsedBuildConfiguration>
    <LastUsedPlatform>Any CPU</LastUsedPlatform>
    <SiteUrlToLaunchAfterPublish />
    <LaunchSiteAfterPublish>True</LaunchSiteAfterPublish>
    <ExcludeApp_Data>False</ExcludeApp_Data>
    <publishUrl>C:\path\to\publish</publishUrl>