JOEL LIPMAN

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

638 entries

Convert to Proper Case in T-SQL
Transact-SQL

Convert to Proper Case in T-SQL

So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles and departments.

Read note 62,017 hits
SSIS: Add Reference Microsoft.SqlServer.TxScript
SQL Server Integration Services

SSIS: Add Reference Microsoft.SqlServer.TxScript

This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft staff so why should their documentation include it?

Read note 23,388 hits
SSRS Change Background Color of Image
SQL Server Reporting Services

SSRS Change Background Color of Image

Sounds easy but actually if you use an image which has transparent areas, ie. has one color which will be transparent, the transparent pixels will be colored in with the page background color.

Read note 30,352 hits
SSRS Stop Scrolling Behind
SQL Server Reporting Services

SSRS Stop Scrolling Behind

I recently revamped our standard report with a new template comprising of a single Tablix which contained the images of the corners and sides of the report. It looked beautiful if simply displayed on a single page (the top half of the page) as long as the end-user doesn't scroll. If the page was scrolled, what should d...

Read note 40,112 hits
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,956 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,720 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
822 Site articles
30.1m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.