Windows 7: System Clock is constantly going out of synchttps://joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 First off, check there aren't any Update for Windows 7 releases at Microsoft's Windows Update The Long Fix Now below are the notes I've had to try and fix this before (personally it was because Microsoft released an optional windows update that fixed my...

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

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

13 April 2010 more errors (had to return the pen for another and another) as well as the common USB disk storage format tools for Windows. Note that any data on the USB pen is automatically lost, and that if you use rescue programs, you may corrupt the pen in such...

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

Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 FROM _SMDBA_.Incident WHERE _SMDBA_.Incident.[Group Name] LIKE @GroupName AND _SMDBA_.Incident.[Assigned To Full Name] '' Note that this excludes all the data that doesn't have a matching label. Which can be a major part of your charts if this is a...

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

Joe's CSV Chart Generator (JCG)https://joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the copyright text that...

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

Change the login link in MediaWikihttps://joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

22 September 2010 system to automatically prompt them for their username/password. (Kerberos authenticated, as opposed to NTLM authenticated). Note: This article is displaying how to change the link and not how to setup these authentication methods. Open your skin file...

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

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

22 October 2010 is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international characters A Module Extension I wrote for Joomla! displayed...

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

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

13 December 2010 ) t1 LEFT OUTER JOIN wikimedia_user b ON t1.ID=b.user_id GROUP BY t1.IP ORDER BY b.user_name ) t2 GROUP BY MONTH(t2.Date); Notes: I use this in a PHP script so where year is specified (2010), I have a variable posted from a HTML form in my PHP. Also...

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

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

06 January 2011 I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report...

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

Formatting a date in an MDX queryhttps://joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The other formats are: =FormatDateTime(Fields!BirthDate.Value,...

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

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

04 February 2011 This is just a note for me as it took a while to find on the net and even then it was confusing as to why it works but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in...

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

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

25 February 2011 results and the PHP script runs another SQL query for each row to check the ID does not exist in the audit table... -- Note: This article was updated on 2011-04-19 11:54

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

Difference between two dates - the midnight hourhttps://joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 ---------------- -------------- 04/03/2011 Tweedle Dee 10:00 12:00 2.00 08/03/2011 Tweedle Dum 23:30 00:30 -23.00 Note the last row is obviously incorrect. This is because the script is not changing the date at the stroke of midnight. Take the last row...

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

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

15 April 2011 Here's a script I used to generate the SELECT query. If you run it, it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have been any table with more than 52 rows, I'd say specify the table you will NOT be...

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

CSS Background Without Causing Scrollbarshttps://joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 note in case I spend as long as I did again. A Client had some clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost tip aligned to the right of a central content section. I...

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

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

28 April 2011 List: Car Notebook Mini-USB mouse (wired) Norton Ghost USB Drive for storage (backing up clients pc) USB Drive with drivers/software/portable apps USB Dongle connecting to an Internet Provider OS disks Document Templates: Service Agreement Template...

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

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

28 April 2011 reading the rest of this article in case you're easily offended. It's just an amusing stab at customers computer issues. Note that most of the below were remote support jobs so we weren't there in person and could only see the users screen. Three...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 JoelLipman.Com is my repository for scripts, programs and extensions to existing web-development systems. I use it to store notes that other websites either do not have or have stopped providing, or just because it's easier for me. This program can be...

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

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

07 July 2011 you message v0.1 (06/07/2011) - Added Admin Section: Settings/Configuration --- Component landing page customization (add note to see Component Style). --- Storage folder for files (can be outside of Joomla! for performance). --- Protect storage folder...

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

List MediaWiki Articleshttps://joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 do I want? Page ID, Title, Content, Category, AccessLevel (note that AccessLevel is extra to your standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've...

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

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

30 September 2011 were complaining it became too convoluted and cramped when refreshing data and preferred the end result with this change. Note on "row height": We did not want the customer having to format the report after they've already gone through the hassle of...

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