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

05 January 2011 exists as a MySQL user and a server user. Reporting server is remote as well as the MySQL database. BIDS is on the client machine. Download and install the MySQL ODBC driver (at time of print v5.1) Visit http://dev.mysql.com/downloads/connector/ Click...

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

Counting the occurence of a word within a string: Benchmarkhttps://joellipman.com/articles/web-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

06 September 2009 took : 0.36489319801331 Seconds Count By substr_count took : 0.27841401100159 Seconds If you are interested to know the machine configuration, these tests ran on a Celeron 1.6GHz processor based laptop with 768 MB of RAM. And I am using PHP 5.1.1...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

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 rights on your computer. Open regedit.exe through the start menu search box, and then find this registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\w32time\TimeProviders\NtpClient Double-click on the key on the right-hand side for...

• 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 doesn't need it. Bulletproof, waterproof, fireproof, shockproof BUT NOT joe-proof!... I'm using windows 7 and my day-job machines tend to be windows xp. I found this solution on a windows xp machine so if the error happens again, I'll try fixing it on...

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

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

27 April 2010 from Linux variants). Sometimes you may only have partial Aero effects. This can be because Windows may not think your machine is powerful enough to run these effects without affecting performance. If this is happening to you, and you don’t mind about a...

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

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

18 May 2010 the WWW detailing this process but none of them really worked for me. I recently changed job 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...

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie. from my workstation). I would have to upload the report to the server, configure the web application to use the...

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

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

28 April 2011 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". "You mean you log back on in the morning?"...

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

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

29 September 2011 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 network traffic (tried tcpdump,...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 folder to place binaries from your sample. If you need to place files in the GAC, right-click on the File System on Target Machine -> Add Special Folder -> Global Assembly Cache folder. It will now show up as an additional folder, and you can add...

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

Joes Password Analyzer (JPA)https://joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 to memorize or to type quickly. Companies using certain password systems can even send the login credentials to the remote machine for you, but does this just open another can of worms? The trick in my opinion is a memory aid. How to use Type a word in...

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

Change Regional Settings for your Reporthttps://joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter...

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