AHK Countdown Tooltip
Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better and have it calculate to the nearest second. I call this latest app "byeBU" and this is version 0.4 Beta (unofficial app).
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 search477 entries / matching AI
Clear filters
Joomla WHERE clause with OR
A quick article on how to use the where clause in a joomla database query.
Include a carriage return in a column heading
A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time.
SSIS: How to loop through multiple flat files as data sources
This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later.
SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issue
I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer
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.
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?
ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2
This article is a follow on from my article JComments 2.3 with PlayThru (Joomla 2.5.x) but this is for a later version of the components using the alternative called PlayThru by AreYouAHuman.Com.
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.
Loading more notes...
No more notes to load.