Joe's Unduplicater (JUD)http://mail.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 Bin". Say you've got 100 media files, you sat there patiently waiting for 50 to convert and then cancelled the process for some reason. Your option is then to manually go through both folders and check which ones have already been converted and can now...

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

Running Internet Explorer 6, 7, 8 as standaloneshttp://mail.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 and no longer have all my test machines at work. Instead I only have the one workstation :eek Still I've been asked to test some web applications (???) so I had to find a solution to suit me. I'd done this before IE7 (so a long time since). My office...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

UTF8 Unicode PHP MySQL for International Charactershttp://mail.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 work for Joomla! articles and not for this module? A. Think this is because that module is loaded before... not sure but for some reason the above command set names 'utf8' is obviously not run prior to the module being displayed.

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

Passwords: Did-you-knowhttp://mail.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 (source: NirSoft Recovery Tools 01/2008) 4 main techniques used in getting your password: Steal It (by looking over someone's shoulder), Guess It, Brute Force (=try every combination), Dictionary Attack (=try every combination starting with words that...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

SQL Queries for Statisticshttp://mail.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 (VisitorUAgent), the User ID (VisitorID, 0 if not logged in) and of course the Timestamp (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also...

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

Connection Strings for SQL Serverhttp://mail.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 is available from Connector/NET version 5.0.3. In earlier versions, this option has no effect. Using encryption, alternative Some reported problems with the above one. Try replacing the key "Encryption" with "Encrypt" instead....

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

Accessing a MySQL Database with Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 5.1 Driver" > Finish Data Source Name (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS suffix) or the IP address of the...

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

Merge the content of two similar tables in MySQLhttp://mail.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 standard SQL we can combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION...

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

Room with a view E.M. Forsterhttp://mail.joellipman.com/articles/_other-misc/room-with-a-view-em-forster.html

04 February 2011 Taking a break from website migrations. Thought I'd share some thoughts I was reminiscing of: "We cast a shadow on something wherever we stand, and it is no good moving from place to place to save things; because the shadow always follows. Choose a...

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

MySQL: Find records in one table that are not in another.http://mail.joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these benchmark...

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

SSRS Hide results table if emptyhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 dataset) =IIF(Sum(Fields!Counter.Value, "Equipment") send to back), the expression for visibility on the textbox should be something like: =IIF(Sum(Fields!Counter.Value, "Equipment")>0, True, False) If you're bugged by the warning "Overlapping report...

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

CSS keeping the footer at the bottomhttp://mail.joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 this by including a div push layer which clears both (even though i had clear:both on the css for my #right div layer). For some reason, it has a more forceful effect in its own separate layer. In a joomla CMS template though, I wanted the "left" div to...

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

Newbies guide to be the local computer guyhttp://mail.joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 Ask local businesses if you can post a flyer in their window or on their cash wrap. Initially, charge a nominal fee…maybe something like $30/hour just to build up a client base and get some referalls. Put up a Web site describing your services. It makes...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

What's the problem? Amusing computer issueshttp://mail.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 and could only see the users screen. Three Webdevelopers phone in to say their computers can't view a website properly "Can someone have a look at our computers because we recently received the new corporate template for our website and it's not...

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

Could not instantiate mail functionhttp://mail.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 is an incorrectly setup mail system. Here is a list of rules that must be followed: I took this from Direct Admin but it has some useful guidelines for these kind of issues: How to setup the Mail System 1) hostname must not match any domain that is...

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

SSRS / MDX Date Querieshttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-mdx-date-queries.html

03 August 2011 endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS 2008 R2. The following examples...

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

Joes Network Transmission Detector (JTD)http://mail.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 includes the AHK file for you to modify and play with (Hooray for OpenSource) so you can style it to your own taste. Here's some pictures of it on an XP machine with a dark grey desktop background: In Development Read data packets without causing...

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

SSRS Dropdown parameter cannot be blank!http://mail.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 part of my SQL query is because I had to match the datatype used by our reporting server for the ItemID field which is some sort of hexadecimal ID value that Microsoft are so very fond of. You will need to use your own head to match the datatypes for...

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

Basic Oracle Function Structurehttp://mail.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 submit an Active Directory (AD) username and receive a student ID number instead, all with the aim to improve performance on some SSRS queries which accept either an ID number or an AD name as user parameters. Syntax: CREATE [OR REPLACE] FUNCTION...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

MySQL: Display Users and Duration in Matrix Timesheethttp://mail.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 list, within the loop run the activities query and replace the string "STRING_TO_REPLACE_PER_ITERATION" with the User ID. Something like: $result=mysql_query($user_list_query); while($row=mysql_fetch_assoc($result)) { $this_user_id=$row['UserID'];...

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