James Skemp JamesSkemp

JamesSkemp / NuGet - Install particular version of jQuery

Last active December 27, 2015 20:49

Install a particular version of a NuGet package. In this case jQuery.

Install-Package jQuery -Version 1.10.2

JamesSkemp / SitecoreADCMigration.cs

Last active December 31, 2015 22:59

Example of how I converted Advanced Database Crawler functionality to Sitecore 7.

	/* Sitecore 6.x code */
	var searchParam = new SearchParam
	{
	Database = currentDB,
	Language = "",
	TemplateIds = "",
	LocationIds = blog.ID.Guid.ToString(),
	FullTextQuery = terms
	};

JamesSkemp / Alter table column.sql

Created December 26, 2013 21:03

T-SQL to alter a column in an existing table.

	alter table [projectManagement].[Task]
	alter column Name varchar(250) not null

JamesSkemp / Change table schema.sql

Created December 26, 2013 21:06

SQL to change the schema on an existing table.

	ALTER SCHEMA projectManagement
	TRANSFER dbo.RequestPriority

JamesSkemp / Add identity and primary key to table.sql

Created December 26, 2013 21:08

SQL to add a new identity column to an existing table.

	-- See http://stackoverflow.com/a/3698824/11912
	alter table JobSupplies add Id INT IDENTITY
	alter table JobSupplies add constraint PK_JobSupplies primary KEY(Id)

JamesSkemp / Sitecore Term Search with SQL.sql

Last active March 11, 2016 15:30

Searches Sitecore field values for a search term, via SQL.

	use XXX_Sitecore_Master

	declare @searchTerm varchar(100)
	declare @onlySearchLayouts bit
	/*
	If using parameters, they must be escaped:
	%2b = space
	%252f = /

	If using DataSource, they don't.

JamesSkemp / Misc TFS Commands

Last active January 4, 2016 09:09

TFS workspace commands

	# all from VS command line - C:\Program Files (x86)\Microsoft Visual Studio 11.0>

	tf workspaces /server:http://domain:8080/tfs /owner:*

	tf workspace /delete "packages sacred";domain\jskemp /server:http://domain:8080/tfs

	# view detailed information, including mappings
	tf workspaces /owner:* /computer:* /collection:http://domain:8080/tfs /format:detailed

JamesSkemp / modDevelopment.bas

Created February 17, 2014 16:58

Module for Microsoft Visual Basic for Applications (specifically Access) that provides various developer functions.

	Option Compare Database
	Option Explicit

	' Dumps connection data for all ODBC/linked tables.
	Function DumpConnectionData() As Boolean
	Dim db As DAO.Database
	Dim tb As DAO.TableDef

	Set db = CurrentDb
	For Each tb In db.TableDefs

JamesSkemp / Sitecore Link from Item.cs

Last active August 29, 2015 13:56

Create a link given a Sitecore Item.

	protected void AddProgram(Sitecore.Data.Items.Item program)
	{
	HtmlGenericControl listItem = new HtmlGenericControl("li");

	HtmlAnchor listLink = new HtmlAnchor();
	listLink.InnerText = program.DisplayName;
	listLink.HRef = Sitecore.Links.LinkManager.GetItemUrl(program).ToLowerInvariant();

	listItem.Controls.Add(listLink);

JamesSkemp / Sitecore Find Locked Items.sql

Created February 20, 2014 16:10

Searches the Sitecore database for locked items.

	use XXX_Sitecore_Master

	select f.ItemId, f.Value, f.Created, f.Updated, i.Name
	from VersionedFields f
	left join Items i on f.ItemId = i.ID
	where f.Value like '<r owner%'
	order by f.Value