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

06 April 2013 this plugin is mostly hard-coded and most of the parameters have no effect. It was initially built for someone as a quick syntax highlighter that recognizes SQL; but I am working on getting it to recognize more programming languages so that I can use it...

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

MS Excel - Sort pivottable column headings by datehttp://www.joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The...

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

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

23 April 2013 This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...

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

Things to Check if Joomla Password Reminder email not being senthttp://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 A quick article on a frequent question I get asked. This refers to an issue within the Joomla CMS (version 2.5.x) where it fails to email users who reset their password. How? A few things to check: Check the email message even exists: Login to your...

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

T-SQL Conversion failed when converting the varchar to data type inthttp://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well...

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

T-SQL concatenate an incremental row numberhttp://www.joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another...

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

Autohotkey Count Number of Files/Folders in a Directoryhttp://www.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 := ComObjCreate("Scripting.FileSystemObject").GetFolder(UserFolder).Files.Count FolderCount := ItemCount - FileCount -- quick if looking at one directory. -- just as slow if looping for subdirectories: Loop, %UserFolder%\*.*, 1, 1 { ThisFolder :=...

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

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

22 July 2013 Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...

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

Split a row into multiple rows based on a column valuehttp://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that has all the days of sickness of employees. This table contains, which...

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

htaccess Rewrites SEF URL and submits to PHPhttp://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 A quick note on a htaccess rewrite rule I'm liking. What does it do? What I type: http://www.mywebsite.com/blog/videos.html Sends this to server: http://www.mywebsite.com/index.php?myFolder=blog&myFiles=videos How? Options -Indexes +FollowSymlinks...

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

Compare two databases using T-SQLhttp://www.joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without having to download any third-party products. Why? I googled and...

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

Regular Expression Basic Usage Exampleshttp://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use the...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Problem creating SSRS report subscriptionshttp://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 A quick article on if you are trying to create a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following: Message from webpage Subscriptions cannot be created because the credentials...

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

Client Services: Website Development Agreementhttp://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 allocate. They will do the investigative work to get the service up and running again. Having a small chain-of-command and quick development cycle, there are advantages to working on my own: I can keep costs low, I have scripts which have sped up...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

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

17 November 2013 This is a quick note on one reason you may get the above error in a Joomla CMS environment. Call to a member function mark() on a non-object in /public_html/index.php How? Not really a solution here because this is indicating that the system can't find...

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

MS-DOS: Copy folders without overwriting fileshttp://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal hard drive to an external one. I wanted it to copy only...

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

Registered Users Cannot Login - Super Users Canhttp://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 How? In our case, the website had recently been migrated from Joomla 1.5.x to 2.5.x. I asked to examine the database and a quick scan in the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is "root". Login to...

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

Export Joomla Users scripthttp://www.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 Why? I want to move a client's list of Joomla users to a new system which allows the passwords to be in MD5. All I want is a quick bit of code to get all the users out of a Joomla CMS. How? I could just type a query on the database and get the same...

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

SSIS: How to loop through multiple flat files as data sourceshttp://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 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...

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

Include a carriage return in a column headinghttp://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? 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...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *