Blog

Articles, code snippets and news worth sharing.

SnippetMar 30, 2012
jQuery KeyDown Event
A generic JavaScript function to capture a key press and run logic, such as clearing a field on backspace.
```
function CheckKey(e) {
    var keynum;
    if (window.event) // IE
    {
        keynum = e.keyCode;
    }
```
1 min read#ASP.NET#JavaScript#jQuery

SnippetMar 29, 2012

SharePoint Configuring WAS

PowerShell script to create the Word Automation Services service application in SharePoint 2010.

$serviceName = "Word Automation Service"
$appPool = $null

Add-PSSnapin Microsoft.SharePoint.PowerShell
$appPool = Get-SPIisWebServiceApplicationPool -Identity <appPoolName>
if ($appPool -eq $null)

1 min read#PowerShell#SharePoint#SharePoint 2010

SnippetMar 28, 2012
Visual Studio 11 Beta
A first look at the Visual Studio 11 Beta, with the splash screen and the main IDE window.
1 min read#Tools#Visual Studio
SnippetMar 27, 2012
SQL List All Triggers In Database
A query that returns every trigger in a database with its table, type and whether it is disabled.
```
USE YourDBName
GO
SELECT trigger_name = sysobjects.name,
      trigger_owner = 'x',
      table_schema = s.name,
      table_name = OBJECT_NAME(parent_obj),
```
1 min read#SQL
ArticleMar 26, 2012
SharePoint 2010 WAS ConversionJob
Use the Word Automation Services ConversionJob object to bulk convert documents, for example DOCX to PDF, and monitor the job.
1 min read#C##SharePoint#SharePoint 2010
ArticleMar 25, 2012
jQuery AutoComplete Control
Steps to add a jQuery UI autocomplete (type ahead) box to an ASP.NET page, backed by a WCF data service.
2 min read#ASP.NET#JavaScript#jQuery
ArticleMar 23, 2012
WSS 3.0 Site Actions Menu Item
Add a custom menu item to the Site Actions menu in WSS 3.0 using a feature, then deploy it with stsadm.
1 min read#.NET#SharePoint
SnippetMar 23, 2012
SharePoint 2010 Modal Dialog
Open a page in a SharePoint 2010 modal dialog from JavaScript and handle the result when it closes.
```
var options = SP.UI.$create_DialogOptions();
options.width = 450;
options.height = 450;
options.url = "/_layouts/PageName.aspx";
options.showClose = true;
options.title = "Dialog Title";
```
1 min read#JavaScript#SharePoint#SharePoint 2010
SnippetMar 22, 2012
SQL List All Tables In Database
Return all tables in a SQL Server database by querying sys.tables.
```
USE YourDBName
GO
SELECT *
FROM sys.tables
```
1 min read#SQL
ArticleMar 21, 2012
jQuery Ajax Loading Image
Show a centred loading image while Ajax calls run, then reveal the page when they finish.
1 min read#JavaScript#jQuery
SnippetMar 20, 2012
SQL List All Stored Procedures
List every stored procedure in a database using INFORMATION_SCHEMA.ROUTINES.
```
SELECT * FROM
DatabaseName.information_schema.routines
WHERE routine_type = 'PROCEDURE'
```
1 min read#SQL

SnippetMar 19, 2012

jQuery getJSON

Populate a dropdown list from a JSON service using $.getJSON and $.each.

$.getJSON("URL", null,
   function (data) {
      $.each(data.d, function (i, result) {
         var optionText = "<option value='" + result.value + "'>"
            + result.text + "</option>";
         $('#ddlSelectTagId').append(optionText);

1 min read#JavaScript#jQuery

Blog

Posts