Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming ever is required, the following 34 results were found.

  1. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    from: "Obfuscating your SQL Server Data" by John Magnabosco but tweaked for our purposes. NOTE that the following has only ever been run on development environments and I would not recommend running this on a production system as I have not tested the...

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

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

    (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS suffix) or the IP address of the server Port should be 3306 by default...

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

  3. Display Feeds to major Social Networkshttps://www.joellipman.com/articles/cms/website-development/display-feeds-to-major-social-networks.html

    Instagram Not sure on this one as I could only embed a specific video manually. Will update this if ever a free method for embedding the page comes up. Go to Instagram and open the video/picture to embed Click the 3 dots (ellipsis) at the bottom right...

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

  4. Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/cms/website-development/js/sort-an-associative-array-by-values-in-javascript.html

    An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an...

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

  5. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    task is rather daunting. Having done it a few times and run through a few, I thought I'd note this down to remind me if I ever work for a company using SITS:Vision again. How? For demonstration purposes, I'm going to create a table update process (TUP)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *

  6. MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The...

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

  7. GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    in a couple years time. The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again, I'll add it to this article. How? I know there are instructions on the GoDaddy website but...

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

  8. Newbies guide to be the local computer guyhttps://www.joellipman.com/component/content/article/newbies-guide-to-be-the-local-computer-guy.html?catid=116&Itemid=165

    Get business cards made. Pass them out where ever you go. Don’t rent a storefront yet. Go to people’s businesses/homes and do the repairs there. Ask local businesses if you can post a flyer in their window or on their cash wrap. Initially, charge a...

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

  9. What can MAGA’s do to stop Biden from cheating again?https://www.joellipman.com/component/content/article/what-can-maga’s-do-to-stop-biden-from-cheating-again.html?catid=122&Itemid=165

    by a robot bartender. The robot says, "What'll you have?" and the guy says, "A martini." He then gets the best martini he's ever tasted. The robot says, "What's your IQ?" The guy says, "167." The robot proceeds to chat with him about subatomic physics,...

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

  10. Zoho Finance Suite Schedule: PATTERN NOT MATCHEDhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-finance-suite-schedule-pattern-not-matched.html

    A super quick article on resolving this issue if it ever appears again. Why? At time of print, this error was happening to schedules in Zoho Books, Zoho Inventory, and Zoho Subscriptions. Unless you can monitor when these type of schedules are failing,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *

  11. Add "Command prompt from here" to right-click context menuhttps://www.joellipman.com/component/content/article/add-command-prompt-from-here-to-right-click-context-menu.html?catid=80&Itemid=165

    to: Microsoft Windows XP How? I keep having to do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I...

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

  12. Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/else/database/mysql/search-and-replace-in-a-mysql-database.html

    Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration...

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

  13. Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/cms/website-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

    Issue If you've ever made PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds)....

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

  14. Mirror's Edge Prologue Speedrun Under 2:00https://www.joellipman.com/component/content/article/mirrors-edge-prologue-speedrun-under-200.html?catid=96&Itemid=165

    Blinding run in Mirror's Edge which is one of my favorite games. Yes it's quick to complete but if you've ever youtube'd the levels, there isn't another game so quick-paced and varied giving you that freedom of completing the game your way. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
Results 21 - 34 of 34