Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 and friends are all surprised by the Aero features and weren't aware that these existed in Windows Vista (and originally from Linux variants). Sometimes you may only have partial Aero effects. This can be because Windows may not think your machine is...

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

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

12 July 2010 because I reghost all my computers (Home & Work) each year and can't be bothered to retrieve accidentally deleted programs from my backup drives. I downloaded a load of media files (all legitimately :) and stored them in my music folder. I then run my...

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

Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 to public and db_datareader. Confirm by clicking OK. You should get something like the following: Database-level role names from http://msdn.microsoft.com/en-us/library/ms189121(SQL.100).aspx db_accessadmin Members of the db_accessadmin fixed database...

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

Returned a data type that is not validhttps://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 1, 0)) 'Smart', SUM(IF(t1.VisitorBrowser='Other', 1, 0)) 'Other', COUNT(t1.VisitorBrowser) 'Total' FROM (SELECT a.DateTimeStamp Date, CASE WHEN INSTR(a.VisitorUAgent, 'MSIE ') THEN 'MSIE' WHEN INSTR(a.VisitorUAgent, 'Firefox') THEN 'Firefox' WHEN...

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

Room with a view E.M. Forsterhttps://www.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: *

Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 Herein lies the problem The reason I'm doing this is for another system which decided to "cleverly" use the exports from CMIS Facility so that all the weeks correspond to the rest of the academic data. Unfortunately the developer wrote a system he felt...

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

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 was (still is) one created by a PhD student who graduated and left the institution. It was a custom-built site written from scratch, and it's purpose was to manage Staff and Students within the Additional Learning Needs group. These are staff who take...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 years" JOELLIPMAN_ALLERGYTIMEOPTION4="10 years+" PLG_USER_PROFILE5_FIELD_ALLERGYTIMEDISP_DESC="Choose to hide from other users?" PLG_USER_PROFILE5_FIELD_ALLERGYTIMEDISP_LABEL="Hide from others?" ./profile5/en-GB.plg_user_profile5.sys.ini ; Joomla!...

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

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 your data backed up for $75. Then, I’d charge them $150 for “forensic data recovery” with “no guarantees” – while recovering from the backup I’d made silently. I guess it’s part of the “underpromise/overdeliver” thing… but several customers were...

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

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

28 April 2011 need you to restart your computer now and tell me when that's done.". "I've done what you said but it's still not working". "From my logs, you haven't restarted this machine in a while.". "No I definitely log off every evening and then back on again"....

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

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

09 May 2011 while sending the registration email. A message has been sent to the administrator of this site. Check you can send email from that server ERROR: Message not sent. Server replied: Connection refused 111 Can't open SMTP stream. One common problem people...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 version control Automatic changelogs based on support tickets/development requests. INSTALLATION Download the ZIP file from my website. Login to your Joomla! Administrator Panel. Go to "Extensions" > "Install/Uninstall". Click on the "Upload" button and...

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

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

03 August 2011 I find myself using date ranges 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...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at "SYS.DBMS_UTILITY",...

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

Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 which your program has to read, then this is for you. DllCall will usually run contained in the program and can be hidden from the end-user. The one to rule them all: This is a function I pulled from the Autohotkey forums submitted by SKAN which lists...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 have a DEPT column that is an acronym of the departments so for example: SELECT Date, Reservation, Contact, JobTitle, Dept FROM my_imaginary_table WHERE Contact='Joe' Would become SELECT Date, Reservation, Contact, JobTitle, CHAR(10) + Dept + CHAR(10)...

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

Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 this article is for Joomla 1.5.x sites to be converted to Wordpress 3.2.x sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot easier since it uses nested categories like Wordpress. There are lots of commercial migrators...

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

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 different login details for their Joomla database. The example below demonstrates how to get these details and extract data from the database. How? Based on a script I found on StackOverflow. Not sure what version they were using so I modified it to...

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

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 Determined submitted value as 'DATE'; v_rand_param1 := TO_CHAR(TO_DATE(v_rand_param1,'dd/mm/yyyy hh24:mi:ss'),'J'); -- eg. from 01/01/1901 (Julian Days) v_rand_param2 := TO_CHAR(TO_DATE(v_rand_param2,'dd/mm/yyyy hh24:mi:ss'),'J'); -- eg. to 01/01/2001...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 glass) and for all the flashy stuff, to only appear within the boundary of the parent div layer. Why? I'm making a slideshow from scratch. How? The idea is: Use two main div layers, I'm going to refer to them as "window_slide" and "inner_window". Slide...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *