James Skemp JamesSkemp

## NuGet - Install particular version of jQuery
Install-Package jQuery -Version 1.10.2

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

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

## Change table schema.sql
ALTER SCHEMA projectManagement
TRANSFER dbo.RequestPriority

## Add identity and primary key to table.sql
-- See http://stackoverflow.com/a/3698824/11912
alter table JobSupplies add Id INT IDENTITY
alter table JobSupplies add constraint PK_JobSupplies primary KEY(Id)

## Sitecore Term Search with SQL.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.

## Misc TFS 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

## modDevelopment.bas
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

## Sitecore Link from Item.cs
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);


## Sitecore Find Locked Items.sql
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
	/* Sitecore 6.x code */
	var searchParam = new SearchParam
	{
	Database = currentDB,
	Language = "",
	TemplateIds = "",
	LocationIds = blog.ID.Guid.ToString(),
	FullTextQuery = terms
	};
	alter table [projectManagement].[Task]
	alter column Name varchar(250) not null
	-- See http://stackoverflow.com/a/3698824/11912
	alter table JobSupplies add Id INT IDENTITY
	alter table JobSupplies add constraint PK_JobSupplies primary KEY(Id)
	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.
	# 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
	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
	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);
	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