Cheat Sheet for mySQL vs t-SQLhttps://www.joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 memory aids for me so that I don't have to keep looking them up: MySQL T-SQL Strings String Replace REPLACE(haystack,needle,replacement) REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [, offset])...

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

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

05 February 2013 create a Server Instance, I'm going to specify the Take Parameters from Existing Database Connection option (note that I have obscured my personal settings in the following screenshot): In this screen, I've opted for Do not use Remote Management as I...

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

AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 it's the end of the month again and I have to prepare a report for some investors. The idea of an infographic report has excited them to no end but because the end of the month didn't wait for me to finish the project, I quickly created this program to...

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

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

06 April 2013 file for overall look. This is still in development! Currently 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...

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

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

23 April 2013 people think to themselves every time they see the error they programmed in. Apparently this problem also happens when you have a Data File of varying column numbers. My solution below will also fix this. How? My data file had some empty rows amongst...

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

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

09 May 2013 you are using a separate instance of the browser to your Joomla one. Check that your template isn’t the problem: If you have a test site that has the same error, change the site template to a default one and see if that works. Check your cookie policy:...

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

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

14 May 2013 DMExtractReferenceTable ------------------------------ ID MapIn MapOut 1 0011 71 2 8475 84 3 7749 63 4 B110 92 -- so we have 1 director, 2 managers, and 3 tape-monkeys Now suppose we had a convoluted query which needs to join the two tables so that we...

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

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

24 September 2013 awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases and you have their full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing the above which does a little more of...

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

Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 The page used to be a part of a Password Security System I wrote back in 2008 and I missed the analysis capability so I have restored it on my personal website. Security through Obscurity "Security through Obscurity" is always ultimately fallible. This...

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

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

28 February 2014 Access the page from a browser and you should get all your users listed... For security reasons, delete the file after you have used it. IT IS A SERIOUSLY BAD IDEA TO LEAVE THIS FILE ON YOUR WEBSITE FOR ANYONE TO ACCESS!!! DELETE IT AFTER USE.

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

SSRS Stop Scrolling Behindhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 are set to false or it will error): Save and test on the ReportServer. Background: If you need to visualize how I could have ended up in such a situation, here's the design mode of the report (apologies for the red censoring but this allows the images...

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

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

13 June 2014 and to populate a database table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? I've adapted my real working product with an example. As...

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

SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 [student_nationality_code], [student_ethnicity_code] FROM [sourcedb].[dbo].[events] Simple bit of SQL but as you can see we have a few fields that need decoding (suffixed by "_code"). Run as it is, yields something like the following: sequenceID...

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

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

09 August 2014 it with nothing (so removes it). The challenge here is the space character and delimiting by a string. 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...

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

DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 right moving forwards in an arc to go round corners. Then I learnt there were so many different angles and routes I could have taken (NTS: Take picture of whole track beforehand and plan a route). Strong Winds: Fighting the wind to keep up with the...

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

MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 Why? It's similar to javascript's message box or confirm box, only Android let's you redesign the dialog. For my purposes I have used an XML as the layout. How? This displays a standard Ok/cancel message popup which you attach to some event import...

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

Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 the PcWorldRssParser.java (without it crashing the app). The gist is to check for a description (the first two items do not have one). The following will also return a publishing date: Find the List function in: PcWorldRssParser.java (readFeed) and...

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

Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B ------------------------------------- ---------------------- Beijing Capital...

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

Copy a Wordpress Site for Developmenthttps://www.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 v4.1.1 What? A note to myself on how to create a development/test version of a production/live Wordpress CMS site. Why? I have a website sitting at a domain (eg. www.myexample.com), and I want to create an exact copy at a subdomain entitled "dev1" (eg....

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

Joes Google Map for Joomla (JGM)https://www.joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 as documentation for a module extension I made for the Joomla Content Management System versions 2.5 or later. Why? Could have probably used someone else's. I think there's loads out there but thought making my own to do exactly what I want was quicker....

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