Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 Pen from Play.Com to a 32Gb equivalent. I use my USB pen as the "My Documents" folder on every computer I use. It was fine with my 16Gb one but my 32Gb ones have all failed at some point. I went for a cheap one on Play.com (Verbatim 32Gb@£49.99 &...

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

Some milestones for a website projecthttps://www.joellipman.com/articles/web-development/some-milestones-for-a-website-project.html

14 April 2010 decide if concept is marketable. Browsable prototype or Vertical slice – normally a few sections of the website are produced with many of the website features in and working, this allows reviewers to get a feel for the site, the level of usability, the...

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

Calculating Percentagehttps://www.joellipman.com/articles/ecommerce/calculating-percentage.html

20 May 2010 ) = Gross Profit ( Sell - Cost ) / Sell * 100 = Gross Margin Percent eg. ( 75 - 50 ) / 75 * 100 = 33.33% Margin Percentage With Discount Applied: ((( Sell * Quantity ) - Discount ) - ( Cost * Quantity )) / (( Sell * Quantity ) - Discount ) * 100 eg. (...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Webdeveloper-Speakhttps://www.joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 that electronic and information technology developed or purchased by the US Federal Government is accessible by people with disabilities. I'm going to stop there but do check them out at http://www.motive.co.nz/index.php

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

K2 Items disappearhttps://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 error: #145 - Table './jos_k2_items' is marked as crashed and should be repaired The Quick Fix I managed to fix this with this SQL command . Note: you need to be able to run SQL commands against your database. My client had phpMyAdmin installed so I...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 following describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as having...

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

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

13 December 2010 which is when they are associated to a UserID and identified as staff or student. Number of total hits aggregated by month with on-peak/off-peak. SELECT CONCAT(MONTHNAME(a.DateTimeStamp), ' ', YEAR(a.DateTimeStamp)) Month, SUM(IF((HOUR(a.DateTimeStamp)...

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

Parameters not being used in report processinghttps://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 again I've spent a whole morning going in the wrong direction with a convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder 2.0 and when previewing the report, the parameters...

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

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 properties row... Done! Borders: I'm putting this here because often enough, if I'm going to make the report pretty with alternating rows, I'm probably going to look at the cell borders as well. I want a bigger border at the bottom of the overall report...

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

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

25 February 2011 Well actually I wanted all the articles that have NOT been approved yet... So would this work if I switched MyTable1 with MyTable2? Um I'll get back on this article when I work this out without using two SQL scripts. Currently I've returned to the...

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

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

28 April 2011 was a remote support job over the phone. The discussion above was after installing drivers and setting up the workstation with updates etc. as per our standard image. The printer was connected via three usb extension cables. The middle one wasn't...

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

List all cron jobs for all usershttps://www.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 tab=$(echo -en "\t") # Given a stream of crontab lines, exclude non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning of each line. function clean_cron_lines() { while read line ; do echo...

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

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

09 May 2011 and /etc/virtual/domain.com/aliases exist. 7) File permissions for virtual pop inboxes should be (not applicable with Dovecot/Maildir): /var/spool/virtual/domain.com 770 username:mail /var/spool/virtual/domain.com/* 660 username:mail 8) Ensure your...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 for copying this from another source but with lots of OpenSource developers disappearing and reappearing, the content is what I don't want to lose. ;// ;// Win32 Constants ;// ;#region Peek Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const...

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

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

03 August 2011 // yields: 31/12/2011 I'll add to this if I use others. Apologies for the European formats but this is what I work with so I like to just copy and paste from this article.

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

SSRS Redirect after a report is runhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 automatically. How? So there are various solutions out there, here's an overview of some: Method #1 Create one report with all selectable reports as subreports - toggle visibilty based on parameter. Method #2 Add a button below "View Report" linked to...

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

Importing Joomla articles to WordPress postshttps://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

16 August 2011 Change http://demo.joellipman.com/wordpress/ to the full URL of your WordPress site. If post_type is to be post then append with ?p= otherwise use ?page_id=. Articles: ------ MIGRATING JOOMLA v1.5.# CONTENT TO WORDPRESS v3.2.# ------...

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

Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 filters available on the report (only a few to keep it simple silly). When you click on the filter, a dropdown appears with all available values listed. The Problem The values are listed in alphabetical order at first. If any new values come along then...

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

MySQL last year week month day trend periodshttps://www.joellipman.com/articles/database/mysql/mysql-last-year-week-month-day-trend.html

31 October 2011 all accounts irrespective of being activated or not). It needs to pick up trends as well and compare for example todays, with yesterdays up to the same hour. How? I used to use a lot more PHP but since becoming an analyst, I do more at the database...

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

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

15 January 2012 in this case. In my example, I need to 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....

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