Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 "tcp" is an equivalent for "socket". Use "pipe" to use a named pipes connection, "unix" for a Unix socket connection and "memory" to use MySQL shared memory. Specifying character set Use this one to specify which character set to use to encode queries...

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

Proposed Budget i3 PC under £200https://joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 Hard Drive Western Digital Caviar Blue 160 GB (7200 rpm) SATA 8 MB 3.5 inch Hard Drive (Internal) - Western Digital £24.95 Memory Corsair CMX4GX3M1A1333C9 XMS3 Desktop Memory 4GB - Corsair £20.05 Optical Drive Sony AD-5280S-0B DVD±RW 24x SATA Drive with...

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

Forum Ruleshttps://joellipman.com/static-items/forum-rules.html

31 May 2009 in a row in the same thread. Posting lots of times in a row reduces the quality of the board, is a waste of the board's memory, and provides the culprit with ill earned post count points. Double posts will be merged into regular posts, and you will lose...

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 content migration, the commands are split to do about 5000 articles on each iteration so as to avoid session timeouts and memory issues. Edit the script, renaming the database and table names used (DO NOT CONFUSE THE FOLLOWING DATABASE NAMES OR YOU WILL...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 slowed it down a little but the requirement was met. If your end-users complain, do what Microsoft suggests and throw more memory at the SQL Server. The remaining issue is what if the user leaves both fields blank? This would return all users who don't...

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

Cheat Sheet for mySQL vs t-SQLhttps://joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 memory aids for me so that I don't have to keep looking them up: MySQL T-SQL Strings String Replace REPLACE(haystack,needle,replacement) REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [, offset])...

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

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

03 January 2014 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 the input field and check the "Rule Abiding" variation as a strong password to use....

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

SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 it was told to return no more than 100 rows, it would complete in under 10 seconds (7.5 seconds). We played with hardware memory, report layouts and a few days worth of other solutions dotted about the web but the biggest improvement was the "SELECT TOP...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic memory to do the same. My beloved DJI Phantom and the Hubsan X4 H107C This model is the DJI Phantom FC40 so the first Phantom (v1.2?)...

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

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 on line 160 Why? I'm downloading an XML feed to our servers, and then loading the downloaded file into memory with simplexml_load_string(). I get the above error when it is attempting to load an XML feed which is mostly in Spanish and breaks at the...

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