JamesSkemp

use aspnetdb
exec sp_spaceused elmah_error

JamesSkemp

use XXX_Sitecore_Web

select top 100 h.Action, h.Category, h.ItemId, h.ItemVersion, h.ItemPath, h.UserName, h.Created
--select count(*)
from History h
where UserName = 'user'
	and Created <= '2014-04-11 17:11:36.870'
	and Created >= '2014-04-11 17:00:59.963'
	-- Created and Deleted items are potentially disruptive changes. The rest could be bad, but ...
	and h.Action in ('Created', 'Deleted')

JamesSkemp

fast://*[@__Renderings='%{FAAD00AE-A089-4AEF-989C-73917660FF48}%']

JamesSkemp

// query against XXX_Sitecore_Core
var adminUsers = from profile in Aspnet_Profiles
	join user in Aspnet_Users on profile.UserId equals user.UserId
	where profile.PropertyNames.Contains("Administrator")
		&& profile.PropertyValuesString.Contains("True")
	select new { Profile = profile, User = user }
	;

adminUsers
	.OrderBy (u => u.User.LastActivityDate)

JamesSkemp

This content has been moved to https://git.jamesrskemp.com/.

Helpful Git Commands

The following is a dump of Git commands for use on your shell of choice.

JamesSkemp

var imageTemplate = Guid.Parse("{F1828A2C-7E5D-4BBD-98CA-320474871548}");
var jpgTemplate = Guid.Parse("{DAF085E8-602E-43A6-8299-038FF171349F}");

var fileSizeField = Guid.Parse("{6954B7C7-2487-423F-8600-436CB3B6DC0E}");
// For checking image properties, the below can be used.
var imageWidthField = Guid.Parse("{22EAC599-F13B-4607-A89D-C091763A467D}");
var imageHeightField = Guid.Parse("{DE2CA9E4-C117-4C8A-A139-1FF4B199D15A}");

var mediaItems = (
	from item in Items

JamesSkemp

# start where you want the project directory to be created
# create a new directory for an application. pass -B to skip adding bundles (requires internet connection)
rails new application_name
# start in main project directory
# must run commands for a project out of bin directory
cd bin
# start Rails WEBrick server (on port 3000). ctrl + c will kill it
rails server

# create a new scaffold (object and CRUD)

JamesSkemp

# run as administrator

# if you haven't already, execution policy will need to be relaxed. This probably returns Restricted
Get-ExecutionPolicy

# switch to a lax policy
Set-ExecutionPolicy Unrestricted

# install Chocolatey
iex ((new-object net.webclient).DownloadString('https://chocolatey.org/install.ps1'))

JamesSkemp

tf history /server:http://server:8080/tfs/xxx "$/path" /recursive /format:detailed > "c:\path\search.txt"

JamesSkemp

7za x *.7z -oExtracted