JOEL LIPMAN Systems / Automation / AI

Knowledge base / Since 1999

Scripts, systems & field notes.

Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.

Advanced search

608 entries

301 Redirect using htaccess file
Web-Development

301 Redirect using htaccess file

There are a lot of articles & posts out there that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted any person visiting the old domain to be redirected to the new domain...

Read note 25,736 hits
Hide a Drive per User in Windows 7
Windows OS

Hide a Drive per User in Windows 7

Looking at ways of displaying different drives per user on a single computer. This one is by modifying the system registry, so if you aren't familiar with the system registry in MS Windows, you may need to find someone who is. How? As a proof of concept, let's see how to hide a specific drive. Note that this section ap...

Read note 49,581 hits
PHP: First name and Initial of Surname
Personal Home Page

PHP: First name and Initial of Surname

A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How?

Read note 19,109 hits
T-SQL: Parse an XML value
Transact-SQL

T-SQL: Parse an XML value

This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code.

Read note 56,634 hits
JComments 2.3.0 with ReCaptcha in Joomla 2.5.x
Joomla

JComments 2.3.0 with ReCaptcha in Joomla 2.5.x

Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. This article details how to replace jComments built-in kCaptcha with Google's ReCaptcha. Note that I have an article on how to do this with a ReCaptcha alternative called PlayThru by AreYouAHuman.com

Read note 207,349 hits
SSRS: Performance Improvements: SELECT TOP
SQL Server Reporting Services

SSRS: Performance Improvements: SELECT TOP

This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to...

Read note 47,435 hits

Working principle

Our Purpose

This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.

27 Years in IT
1021 CRM clients
810 Site articles
29.8m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.