How to change local folder for TFShttp://mail.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 Explorer and check what it says next to "Local Path" (for me this said the name of the local folder that I specified just before)

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttp://mail.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 associated to articles from your Joomla 2.5 site (no changes to article IDs but backup your original database (J1.5) anyway before running the following): UPDATE my_joomla_1_5_db.my_1_5_db_prefix_content j1a, -- Joomla 1.5.x Content...

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

DataJumble - Shuffling characters in a data valuehttp://mail.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 and I would not recommend running this on a production system as I have not tested the performance and database load. Before: StudentID StudentName DateOfBirth ----------- -------------------- ------------- 1 John Smith 1990-03-21 2 Fred Bloggs...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Vertically align an asterisk on a linehttp://mail.joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 when a user clicked on #2 they would in fact be clicking on the item containing the asterisk above it. Objective Box List Before: Box List After * 1 2 3 * 1 2 3 How? Decrease the line-height of the asterisk and vertically align to the bottom (...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Sync Outlook 2007 Shared Calendar with SharePoint 2007http://mail.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 in their instances of Outlook, they can also add to the calendar quite easily as we used to use an Outlook Shared Calendar before. We see leave announcements as well as key dates and deadlines popup which a single user assigned as "calendar manager" may...

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

DataScramble - Randomizing data rowshttp://mail.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before: StudentID StudentName DateOfBirth ----------- -------------------- ------------- 1 John Smith 1990-03-21 2 Fred Bloggs...

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

Setup a copy of your Joomla websitehttp://mail.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 and involved in the development, that they understand the risk of "accidental" changes and the concept of working on TEST before applying changes to LIVE (-> Schedule a daily backup of LIVE - NO EXCUSES!).

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

Delete related records from multiple tableshttp://mail.joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 >= '2013-02-01 00:00:00' Testing first I should put this at the beginning of the article as it is what you should do before running a DELETE FROM statement but I've added it here as I use it quite often: SELECT s.sessionId, ssf.sessionId, sst.sessionId...

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

Export/Import Database using MySQL Workbenchhttp://mail.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 screen that appears, select your database, specify to export to a Self-Contained File and click on Start Export: Importing Before importing a SQL file, check that nothing in it instructs it to use a specific database (otherwise you might overwrite your...

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

Joes Syntax Styler (JSS)http://mail.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 Before you ask, I tried Google Prettify and Alex Gorbatchev's Syntax Highlighter but both were causing problems for the sites I wanted to use it on. Mainly because of JavaScript frameworks (like jQuery and MooTools) conflicting with other scripts but do...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSIS Skip Blank Rows in Flat File Sourcehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Why? So the solution must be obvious to you by now. At least that's what...

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

Reorder Columns in a Tablehttp://mail.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 COLUMN misplaced_column AFTER other_column; NOTE that annoyingly the column doesn't retain the default properties it had before the move so I guess this has to be included: ALTER TABLE table_name MODIFY COLUMN misplaced_column BIT(1) NOT NULL DEFAULT...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 text (successful transform) // debugString = string.Format("ProcessInput - SUCCESSFUL Transform: Column: {0} - Value Before: {1} - Value After: {2}", x, inputValue, outputValue); debugString = ""; // blanking because I only need to know when it fails //...

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

Call to a member function mark() on a non-object in Joomla CMShttp://mail.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 the content was unaffected, the site was restored to satisfaction... not bad for an hours work. So I've heard it mentioned before, never thought much of it, but now I know. The lesson here is simply to Update the Joomla Core separately and prior to any...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttp://mail.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 has been advised that you have to tell MySQL WorkBench 6.0 to "use the old authentication protocol": • For versions before 6.0.7 • For versions after 6.0.7 Method #3 (Recommended): Do not use MySQL WorkBench!!! Seriously, your pride will slow...

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

Batch Process to rename multiple files using Windows DOShttp://mail.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 The Gist -- What I have Image00001 (Copy).jpg Image00002 (Copy).jpg -- What I want Image00001.jpg Image00002.jpg How? Before I continue, the undo may work in MS Windows (Control key + Z) but don't count on it. I'm going to use a short batch process but...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttp://mail.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 cable seems to go across the unit unless I have the top sticker wrong Legs on Checking vents (note I had masked these before painting as per youtube videos) Possibly my new facebook profile photo My old FC40 looking new(ish) Ok, still going with...

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

Quadcopter App with Flight Restrictions (JQA)http://mail.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 • A private key to use JoelLipman.com data Note: You should delete/uninstall this app or clear its data before giving your device to someone else as it can login to your online account automatically. Sharing: • Do not share security or personal details....

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

TravelPort Universal API - Ping Request with PHP-cURLhttp://mail.joellipman.com/articles/automation/api-misc/travelport-universal-api-ping-request-with-php-curl.html

27 April 2015 request, I thought I'd write this article. How? Using PHP and cURL, here is the full script for a standard ping request. Before you say it doesn't work, it has to be updated every time a new schema is introduced to the system. See my errors section for...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Joes Word Cloud (JWC) Downloadhttp://mail.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 case is not already in list. - Date Uploaded: Wed, 20th Jul 2011 1.6.5- Bug Fix: Keyword Exclusion List removes spaces before and after all words. - Date Uploaded: Mon, 18th Jul 2011 1.6.4- Added Joomla! Admin Option: Module Content Caching - Added...

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