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 I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business Intelligence...

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

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

15 April 2011 a normal people's calendar, so you actually have to adjust this twice a year. Complicated Facility works like this, ask it what date it is on Tuesday in Week 52 of the Academic year 2011/2012... It tells you 2012-07-10. Ask it what date it is on...

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

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

23 April 2011 the div. This causes a scrollbar at the bottom. Tried different techniques of CSS overflow auto hidden etc. all to no avail. What I didn't want when I resize the web browser, a scrollbar! What worked for me: Specify the DIV layer width to be 100 percent...

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

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

28 April 2011 thing… but several customers were intensely relieved when I was able to “work my magic” and save their business/thesis/whatever.″ Rates: Charge nominal fee £20 /hour I bill in 20 minute increments If I have to visit, I add 30 After hours, holidays and...

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

Basic Webpage Controls with JavaScript / COMhttp://mail.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 show you the information and source code of each element by dragging the curser over the webpage. Frequently Asked Questions What is a pwb? - A variable that contains a pointer to the web browser object (Internet Explorer). Here is a simple script for...

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

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

03 August 2011 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 assume today's date is...

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

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

02 September 2011 number afterwards or when the initial report was run). The confirmation page just checks with the end-user that this is what they really want to do as we don't really have an immediate undo process. The form page carries the cancel button (textbox which...

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

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

05 September 2011 I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and...

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

How to Display Report Execution Time in SSRS (milliseconds)http://mail.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 + " second(s)" // yields // 0 hour(s), 1 minute(s), 2 second(s) This isn't what I want... It wasn't accurate enough and always saying 0 seconds was just confusing the end-user... Workaround #1 Although I'm convinced of a solution considering the...

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

Getting the mysql where in delimited string to workhttp://mail.joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 What? I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when...

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

How to change local folder for TFShttp://mail.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 What? I installed Business Intelligence Development Studio 2008 (BIDS) and connected it to a Team Foundation Server 2010 (TFS) instance and set my working local folder to my home directory. When the rest of my colleagues installed it however, they...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttp://mail.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 not work for either Joomla or JoomlaTune (Jcomments) This script is provided as is without warranty If you do not understand what this script is doing, let someone who does run it instead INSTALL INSTRUCTIONS Install JComments on your upgraded website...

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

Prefix Line Numbers in a Text Filehttp://mail.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 find myself copying amounts of code into the same document and then needing lines prefixed so that I can explain the code. What? Change contents of "original_file.txt" The first line of my code The second line of my code The third line of my code To...

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

Copy a table with structure and data into a temporary tablehttp://mail.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy a given table into a temporary table all the while maintaining the structure and data. Thinking inside of...

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

Joomla article modal with clear buttonhttp://mail.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 to Joomla 1.6+ What? This is an article to describe how to add an article modal button in the Joomla Admin Panel (at time of print version 2.5.6) of your component including the all important clear button. What I found was that no one posted this...

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

T-SQL example of Case-Sensitive Soundexhttp://mail.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 What? This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007http://mail.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 What? I misunderstood what was going to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my...

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

Background Gradient Disappears on Long Pageshttp://mail.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 What? This is a quick article on how to resolve the following issue: Overall body background color is blue. Background color of my contents is white. When I visit a small page on the site, the contents background (white) shows. When I visit a very long...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Licence GNU/GPLhttp://mail.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 compilation and its resulting copyright are not used to limit the access or legal rights of the compilation's users beyond what the individual works permit. Inclusion of a covered work in an aggregate does not cause this License to apply to the other...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Delete related records from multiple tableshttp://mail.joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 What? So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational...

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