Blog

Articles, code snippets and news worth sharing.

SnippetJan 29, 2013
SharePoint: exclude a document library from search
Use one advanced setting on the document library to keep its items out of search results.
1 min read#SharePoint#SharePoint 2010

SnippetJan 29, 2013

SharePoint: display search results as raw XML

Replace the XSL of the Search Core Results web part to see the raw XML, so you can tell search problems from XSLT problems.

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes" />
<xsl:template match="/">
<xmp><xsl:copy-of select="*"/></xmp>
</xsl:template>
</xsl:stylesheet>

1 min read#SharePoint#SharePoint 2010

SnippetJan 28, 2013
SharePoint: the administration service is running so all administration jobs will be run in the timer service
Fix a SharePoint 2010 solution deployment stuck on Deploying by restarting the admin service and running the pending admin jobs.
```
stsadm -o execadmsvcjobs
```
1 min read#PowerShell#SharePoint 2010
ArticleJan 20, 2013
Windows 8 Store app development - prerequisites
What you need to start building Windows 8 Store apps: Windows 8, Visual Studio 2012 and a developer licence, plus a dual boot setup.
2 min read#C##Visual Studio#Windows
ArticleDec 23, 2012
JavaScript: detect if a SharePoint page is in edit mode
Several client side ways to tell whether a SharePoint publishing, web part or wiki page is in edit mode.
2 min read#JavaScript#SharePoint
ArticleDec 5, 2012
SharePoint 2013 - single server installation
The prerequisites and the four phases of installing SharePoint 2013 on a single server.
1 min read#SharePoint 2013#Windows
SnippetNov 20, 2012
JavaScript error handling
Handle exceptions in JavaScript with try, catch and finally, and catch everything else with window.onerror.
```
try {
    // Code block
}
catch (e) {
    // Handle exception
}
```
1 min read#JavaScript
SnippetOct 19, 2012
jQuery HTML encode and decode
Two small functions that encode and decode HTML characters by letting jQuery and the browser do the work.
1 min read#JavaScript#jQuery
SnippetOct 16, 2012
C# FileSystemWatcher
A console sample that uses FileSystemWatcher to log a timestamp every time a file changes.
```
using System;
using System.IO;

namespace ConsoleApplication1
{
    class Program
```
1 min read#.NET#C#

SnippetSep 18, 2012

SQL search for a string in a database

Generate a set of SELECT statements that search every text column in the database for a given string.

select
'select distinct ''' + tab.name + '.' + col.name + '''  from
[' + tab.name + '] where [' + col.name + '] like ''%TEXT_TO_SEARCH%'' union '
from sys.tables tab
join sys.columns col on (tab.object_id = col.object_id)
join sys.types types on (col.system_type_id = types.system_type_id)

1 min read#SQL

SnippetAug 16, 2012
SQL comma separated list
Build a comma separated string from the values of a table column with a single COALESCE query.
```
DECLARE @listStr VARCHAR(MAX)
SELECT @listStr = COALESCE(@listStr + ''',''', '') + ColumnName
FROM TableName
SELECT @listStr
```
1 min read#SQL

SnippetJul 2, 2012

RichTextBox: highlight a line on click

Handle the MouseDown event of a WinForms RichTextBox to select the whole line under the mouse.

Private Sub RichTextBox1_MouseDown(ByVal sender As Object, ByVal e As MouseEventArgs) Handles RichTextBox1.MouseDown
    Dim box = DirectCast(sender, RichTextBox)
    Dim index = box.GetCharIndexFromPosition(e.Location)
    Dim line = box.GetLineFromCharIndex(index)
    Dim lineStart = box.GetFirstCharIndexFromLine(line)
    Dim lineEnd = box.GetFirstCharIndexFromLine(line + 1)

1 min read#.NET#VB.NET

Blog

Posts