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

  1. Windows 7 Aero Featureshttps://joellipman.com/component/content/article/windows-7-aero-features.html?catid=80&Itemid=165

    in Windows Vista (and originally 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...

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

  2. Restore MSSQL Error: Database is in usehttps://joellipman.com/articles/else/database/restore-mssql-error-database-is-in-use.html

    and double-check the "Start/Finish Date" is the one you want. OK Searches ssms restore database in use Cannot drop database because it is currently in use Restoring a SQL Database Backup Using SQL Server Management Studio Unable to restore database...

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

  3. Returned a data type that is not validhttps://joellipman.com/articles/else/database/t-sql/returned-a-data-type-that-is-not-valid.html

    I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report...

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

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

    Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only 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...

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

  5. T-SQL: Parse an XML valuehttps://joellipman.com/articles/else/database/t-sql/t-sql-parse-an-xml-value.html

    XQuery [value()]: 'value()' requires a singleton (or empty sequence), found operand of type 'xdt:untypedAtomic *' This is because more than one record was returned so you need to surround with brackets and append a [1] as per the above example....

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

  6. Convert to Proper Case in T-SQLhttps://joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in the examples above because the function was only going to be applied to names and titles rather than addresses, but here it is anyway, add this...

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

  7. Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    ideal, I say realistic. Quit complaining about processes and management and instead prove your worth. I'm good at what I do because I make do with what I have available and I've yet to fail in coming up with a fix/workaround. "It's a poor workman who...

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

  8. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    and when I only had one Joomla site with them, they still would block me thinking I was trying to hack into their servers because of the number of queries Joomla does and the number of times I refresh the page and upload files. Why they think that...

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

  9. SQL Queries for Statisticshttps://joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

    is specified (2010), I have a variable posted from a HTML form in my PHP. Also note: The association to a user can change because anonymous guests count as guests until they login, which is when they are associated to a UserID and identified as staff or...

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

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

    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 Development Studio (BIDS) IDE from...

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

  11. Inserting incremental weeks in MySQLhttps://joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

    For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are academic week numbers. So I can't use the built-in functions. The current structure looks similar to this: ID SetID...

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

  12. Delete related records from multiple tableshttps://joellipman.com/articles/else/database/mysql/delete-related-records-from-multiple-tables.html

    Given a Relational Database Management System (RDBMS) where deleting some erroneous rows in one table will cause errors because the existence of those rows is stored in another table, how do we delete from all the related tables as well? How? You need...

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

  13. Difference between two dates - the midnight hourhttps://joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    Tweedle Dee 10:00 12:00 2.00 08/03/2011 Tweedle Dum 23:30 00:30 -23.00 Note the last row is obviously incorrect. This is because the script is not changing the date at the stroke of midnight. Take the last row as an example, the equation that's...

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

  14. Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    have been asking if I can take over a project that has been abandoned by its developer. I've started writing this article because I find myself forgetting to ask something that could have saved an infinite number of man-hours (I exaggerate a little);...

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

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

    Three Webdevelopers phone in to say their computers can't view a website properly "Can someone have a look at our computers because we recently received the new corporate template for our website and it's not displaying properly on my colleague's...

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

  16. List of Font Awesomehttps://joellipman.com/articles/cms/website-development/list-of-font-awesome.html

    The List This is a copy of the cheat sheet version 4.4. If some icons don't appear on this page, it is because I have only copied over some of the entire directory (the icons I want to use). Note, change the width of your browser if the below list is...

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

  17. CSS keeping the footer at the bottomhttps://joellipman.com/articles/cms/website-development/css/css-keeping-the-footer-at-the-bottom.html

    main content layer was overlapping the footer. I tried various z-index's bearing in mind that the footer has to be behind because the main content had a semi-transparent layer that overlapped it half-way. I managed to fix this by including a div push...

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

  18. CSS Printing - Page Break Inside with Headers and Footershttps://joellipman.com/articles/cms/website-development/css/css-printing-page-break-inside-with-headers-and-footers.html

    A4; margin: 3cm 1cm 2cm 1cm; } @page :first { size: A4; margin: 0cm 0cm 0cm 0cm; } If this works for you then brilliant because it didn't work for me... I guess I'm special, this is what I had to do: @page { size: A4; margin: 0cm 0cm 0cm 0cm; } .page {...

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

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

    I added this article because when I was only trying to look up how to do this, this nut "the Storyteller" went and carried out a benchmark test on the most popular ways of counting the occurrence of a specific word within a string of text. Source:...

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

  20. UTF8 Unicode PHP MySQL for International Charactershttps://joellipman.com/articles/cms/website-development/php/utf8-unicode-php-mysql-for-international-characters.html

    can handle by default anyway. Cause: Q. Why does this work for Joomla! articles and not for this module? A. Think this is because that module is loaded before... not sure but for some reason the above command set names 'utf8' is obviously not run prior...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 121 - 140 of 158