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 joel is required, the following 656 results were found.

  1. About 5 seconds worth of funhttps://joellipman.com/component/content/article/about-5-seconds-worth-of-fun.html?catid=77&Itemid=165

    What? Really not work related but if you know your sharepoint site: Custom Error http:///_layouts/MySite.aspx?Error=You%20are%20a%20jerk%20and%20SharePoint%20does%20not%20share%20with%20jerks. Installer? http:///userdisp.aspx=ID=1 Paying attention to...

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

  2. SharePoint 2007: Change profile picture with minimal permissionshttps://joellipman.com/component/content/article/sharepoint-2007-change-profile-picture-with-minimal-permissions.html?catid=77&Itemid=165

    What? This is a quick article on how to change your profile picture in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been...

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

  3. Deserialization and cannot checkout files in TFShttps://joellipman.com/component/content/article/deserialization-and-cannot-checkout-files-in-tfs.html?catid=79&Itemid=165

    Why? So I get back from annual leave and I can't check-out / check-in any files in a Visual Studio 2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those obvious ones for those that know how but for those who...

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

  4. Making a CD copy with only one drivehttps://joellipman.com/component/content/article/making-a-cd-copy-with-only-one-drive.html?catid=80&Itemid=165

    This is in the case that you have only one optical drive which is a minimum of a CD Writer and you want to make a copy of a CD. Insert original CD in the drive In the CD Drive dialog box, click CANCEL On the desktop, double-click on MY COMPUTER...

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

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

    Applies 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...

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

  6. Another ASCII Extended Character Set for PChttps://joellipman.com/component/content/article/another-ascii-extended-character-set-for-pc.html?catid=80&Itemid=165

    Typing an ASCII character In DOS: Hold down the key while typing the decimal number on the keyboard keypad. (Example: 178) In Windows for a DOS character: Hold down while typing the decimal on the keyboard keypad. (Example: 230) In Windows for a WIN...

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

  7. Increase Recent Documents Number in Windows XPhttps://joellipman.com/component/content/article/increase-recent-documents-number.html?catid=80&Itemid=165

    Just a quick note here. This is an article based on the REG file from Kelly's Korner (@www.kellys-korner-xp.com/xp_tweaks.htm). I'm not fond of downloading REG files and running them even if I have checked what it's doing. I'm putting a note here just...

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

  8. VBScript to retrieve Windows Product Keyhttps://joellipman.com/component/content/article/vbscript-to-retrieve-windows-product-key.html?catid=80&Itemid=165

    What? A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example...

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

  9. MySQL Oracle equivalentshttps://joellipman.com/articles/else/database/mysql-oracle-equivalents.html

    The title of this article implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands in MySQL that I need in Oracle: Objective MySQL...

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

  10. MySQL Group_concat equivalent in T-SQL and Oraclehttps://joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

    MySQL is just the best Unfortunately I make a living using Microsoft and Oracle products. I shouldn't say unfortunately as I don't see myself doing any other job and it beats daytime television any day. I use this quite a lot so I thought I'd put an...

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

  11. Convert a delimited string to tablehttps://joellipman.com/articles/else/database/convert-a-delimited-string-to-table.html

    What? This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID...

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

  12. Modifying columns in a tablehttps://joellipman.com/articles/else/database/modifying-columns-in-a-table.html

    What? This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). All SQL -- Add a column to an existing table...

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

  13. Regular Expressions in SQLhttps://joellipman.com/articles/else/database/regular-expressions-in-sql.html

    What? Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called...

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

  14. Transact-SQL Date Format Conversionshttps://joellipman.com/articles/else/database/t-sql/transact-sql-date-format-conversions.html

    Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx

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

  15. Oracle SQL - Convert given list (CSV) into Rowshttps://joellipman.com/articles/else/database/oracle-pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

    Just a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  16. DBMS Random Referencehttps://joellipman.com/articles/else/database/oracle-pl-sql/dbms-random-reference.html

    What? How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing sensitive data. How? SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *

  17. Oracle: order by subquery missing right parenthesishttps://joellipman.com/articles/else/database/oracle-pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    What? A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *

  18. Increment a column in MySQL using the UPDATE queryhttps://joellipman.com/articles/else/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

    Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1...

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

  19. Search and Replace in a MySQL Databasehttps://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

  20. MySQL Commands to display all columnshttps://joellipman.com/articles/else/database/mysql/mysql-commands-to-display-all-columns.html

    The scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 581 - 600 of 656