ExpressProfiler (aka SqlExpress Profiler) – Home

ExpressProfiler (aka SqlExpress Profiler) is a simple and fast replacement for SQL Server Profiler with basic GUI and integration with Red Gate Ecosystem project.

Can be used with both Express and non-Express editions of SQL Server 2005/2008/2008r2/2012/2014 (including LocalDB)
Distribution package contains both standalone version of ExpressProfiler (can be used without installation) and installation package.

ExpressProfiler – Home.

Scheduled jobs in EPiServer CMS 6 – long running and sending status updates back to the UI

“There are a few hidden bits in EPiServer CMS 6 that hasn’t been talked much about, one of them being the enhancements to the scheduled jobs. These new features include the ability to interrupt the execution of a long running job and for these jobs to send status updates to the UI.”

From: Scheduled jobs in EPiServer CMS 6 | This is nothing.

jQuery – get a list of values of an attribute from elements – Stack Overflow

$”.object”.attr”level” will just return the attribute of first the first .object element.This will get you an array of all levels:
var list = $”.object”.mapfunction{return $this.attr”level”;}.get;

via selectors – jQuery – get a list of values of an attribute from elements of a class – Stack Overflow.

Simple SQL script for searching for a certain word in all EPiServer 6 pages

The fkPageID value points to the actual page id which you can search for in EPiServer UI.
The string could be in a page in the Recycle Bin or maybe even in a previous page version…

SELECT *
FROM [myEpi6db].[dbo].[tblProperty]
where
string like '%support@mysite.com%'
or LongString like '%support@mysite.com%'

This is on a EPiServer 6r2 db.