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

  1. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    on a specific student. An additional request is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based on the...

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

  2. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    the data and present it in a report, which would average about 0.4 seconds. We're obviously not interested in shaving off time from 0.4 seconds; no, we're more interested in the fact that 0.4 Microsoft seconds seems to translate to about 10 minutes in...

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

  3. Include a carriage return in a column headinghttps://www.joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located on a database on the other side of...

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

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

    by the Aero features and weren't aware that these existed 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...

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

  5. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    been asked to test some web applications (???) so I had to find a solution to suit me. I'd done this before IE7 (so a long time since). My office workstation setup for this is: HP CMT DC7900 E5300 @ 2.60Ghz 2Gb RAM Windows XP Professional SP2 Internet...

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

  6. Run commands for Windowshttps://www.joellipman.com/component/content/article/run-commands-for-windows.html?catid=80&Itemid=165

    clipbrd Command Prompt cmd Component Services dcomcnfg Computer Management compmgmt.msc Control Panel control Date and Time Properties timedate.cpl DDE Shares ddeshare Device Manager devmgmt.msc Direct X Control Panel (if installed)* directx.cpl Direct...

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

  7. Set up Desktop SlideShow in Windows 7https://www.joellipman.com/component/content/article/set-up-desktop-slideshow-in-windows-7.html?catid=80&Itemid=165

    every change. About a zillion group policies control our every deviation from the standard staff image and so we spend more time on "how do you make it like it was in XP?" situations. How? Who doesn't want to change their desktop background wallpaper?...

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

  8. Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/component/content/article/windows-live-mail-error-id-0x8de00005.html?catid=80&Itemid=165

    'https://mail.services.live.com/DeltaSync_v2.0.0/Sync.aspx' Windows Live Mail Error ID: 0x8DE00005 How? I don't remember the time when the Microsoft website became helpful but as they already have an article on this, I'm going to do a bunch of...

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

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

    click Yes. Restoring in SSMS, Right-click on the database Select Tasks > Restore... > Database Specify the "to a point in time" if you don't want to restore from the most recent backup and double-check the "Start/Finish Date" is the one you want. OK...

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

  10. T-SQL DateTimestampshttps://www.joellipman.com/articles/else/database/t-sql/t-sql-datetimestamps.html

    setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British Summer Time) Tuesday the 11th of October 2011 at 06:00am: CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) Oct 11 2011 6:00AM CONVERT(CHAR(8),...

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

  11. T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/else/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

    = RTRIM(LTRIM(@StringInput)) INSERT INTO @OutputTable ( StringValue ) VALUES ( @StringValue ) END RETURN END And one more time for a more common purpose where it converts a string of words delimited by commas to a table: CREATE FUNCTION...

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

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

    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 developers should not be able to send a 1000 queries a minute or why...

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

  13. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/else/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    (preferably add the keyword "portable") Avoid links to MySQL Workbench and download an alternative. MySQL.com may in the time that I have written this article, release a newer version that corrects this. I personally downloaded HeidiSQL, setup a...

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

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

    on both IT and environmental policies. Tech Notes: For PCs: Run a command prompt and type systeminfo: Look for "System Up Time". A staff member in a partner institution: "By the way my printer has stopped working, in fact it hasn't been working for...

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

  15. Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    an exact number of occurrences of the preceding character or subexpression. For example, to find where 'a' occurs exactly 5 times, you specify the regular expression: a{5} This expression matches: aaaaa The expression does not match: aaaa Interval...

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

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

    enough time trying different methods across the web but only 1 article worked for me using the "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: Header Left Right Footer Situation The header displayed fine....

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

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

    many rows to fit on one page, and this overlaps onto the next, covering the footer and header... How? By spending a lot of time spinning on my chair and twiddling my thumbs... Firstly, set the page CSS: This will allow 3cm from the top for a header and...

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

  18. CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/cms/website-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

    when I hover the mouse over the links, the text changes and the transition between the two is controlled smoothly. Why? At time of print, I couldn't find any clear example demonstrating this so here's my take on it: What I have » Home / Products /...

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

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

    What? 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...

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

  20. Slideshow div layer through a windowhttps://www.joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

    just "...fast and works with cms articles...". If we have 100 slides then 100 slides of data will need to load at the same time per page. Terrible. Using AJAX (which will have to be Asynchronous JavaScript and xHTML. I'm not using XML, or is that...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
Results 181 - 200 of 230