Windows 7 and Google Chrome incognito mode by defaulthttp://www.joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 (including the hyphen/dash) to the end of the Target value Ok that and see if it works Note that if in point 4, if there are any spaces in that value, you should add a double-quote character to the beginning and end of the location of chrome.exe (for...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

AutoHotkey Ternary Operatorhttp://www.joellipman.com/articles/automation/autohotkey/autohotkey-ternary-operator.html

27 April 2010 ThisVar:=1 Else ThisVar:=2 Converted to Ternary this would look like: ThisVar:=(ThisCondition = true) ? 1 : 2 I'll add as there are a whole bunch of methods using the Ternary Operator in AutoHotkey (discussed on...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

The Sandpithttp://www.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 can be found at http://aerofilm.blogspot.com/2010/02/sandpit-short-film-by-aero-director-sam.html Personally I can sit there watching it without sound. Here's another video that shows how to build the camera: {module title="Youtube Embedded Video -...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

SSRS Expand specific drilldown by defaulthttp://www.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This is how to do it in SQL Server 2008 and creating a...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS - Lost window with datasetshttp://www.joellipman.com/articles/microsoft/ssrs/ssrs-lost-window-with-datasets.html

25 March 2011 and not sure why. You open the project and the window panel for the Report Data containing the parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars before I found this. Open a Report solution (or have one open already?)...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Reminder on SSRS row separatorhttp://www.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 by clicking the grey part above it Delete this column. Check that the grouping grey part (a giant parenthesis) is still there. Right-click on the grey header of the tablix row again (left-most grey part) Select "Insert Row" and I selected "Outside Group...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

MediaWiki: MySQL to extract path to imageshttp://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 DESC Note that I've commented out the lines which specify images modified since the 22nd of September 2011. I've left it in there for my own benefit as it's unlikely I'm asked for an entire export. Should yield something like: img_name img_size...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

Convert seconds to total time in PHPhttp://www.joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

31 January 2012 This is intended for activity/session durations and although I usually get MySQL to do the date/time calculations, there are times when we have to do with PHP. This is the shortest way I know to properly convert seconds into total hours, minutes and...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

UNC Paths in Sharepoint 2007 linkshttp://www.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 I'd write this article to warn others that that's unnecessary and can simply open another can of worms (security-wise). There may be situations when this is better but I'm just trying to add a link to our Sharepoint 2007 portal. How? Add a link with the...

• Type: Article
• Author: Joel Lipman
• Category: SharePoint
• Language: *

List last modified files using FTP Command-linehttp://www.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 So let's say my FTP client is not the most expensive (was FREE), nor the most advanced client out there, and I want to know what were the most recent files I modified and uploaded to a site, how do I do it using just Microsoft Windows? How? I don't have...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Trim in T-SQL and SSIShttp://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 REPLACE( REPLACE( REPLACE( myString, "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) Using it to compare to a value? There are cases in T-SQL where the trim is unecessary and a similar equation can be written: Table: DMExtractEmployeeTable ID...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

MS Excel: Convert a text to a numberhttp://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 with your data but the way I see it is it's a space character and TRIM() should work. My solution Include the space (if there is one) in the substitute formula: =SUBSTITUTE(B3, " ₱", "") The resulting value will still need to be multiplied by 1 to...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

VBScript to retrieve Windows Product Keyhttp://www.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB