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

  1. SSRS Redirect after a report is runhttps://www.joellipman.com/component/content/article/ssrs-redirect-after-a-report-is-run.html?catid=75&Itemid=165

    to connect to and the follow on link was enough as a solution. My seniors advised that if we had time in the future we could expand on this further. Google Searches that got me nowhere: ssrs process parameter after report execution auto-redirect after...

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

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

    which will do the select to check that the update happened. Unfortunately this means that when the report was executed, it could only really display a message saying "executed stored procedure", "please click on the link to continue" and then the user...

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

  3. SSRS Stop Scrolling Behindhttps://www.joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    all items are set to false or it will error): Save and test on the ReportServer. Background: If you need to visualize how I could have ended up in such a situation, here's the design mode of the report (apologies for the red censoring but this allows...

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

  4. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    the Default Update Interval If your clock is constantly out of sync even though it says the sync was successful, the problem could be that your computer is losing time because of a system clock problem. A workaround in this instance is to change the NTP...

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

  5. Print Directory Contents to a Filehttps://www.joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    This file will be stored in the folder that you asked to list. Instead of C:\windows\system32\cmd.exe, I could have used %Comspec% or even %windir%\system32\cmd.exe but with some group policies, you will get an "access denied" message. If you don't have...

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

  6. Administrator Program Shortcut without Prompthttps://www.joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    "C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe" for Start In..., I leave this blank but you could specify a working directory. OK the dialogs and close the Task Scheduler Right-click on an empty space on the desktop and select New...

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

  7. Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    to enable/disable notifications. Why write this article when there's a perfectly ok post on the Microsoft website? Well I could bookmark that page or save myself a click... How? To test any of the following, type the windows key and select "Run..." ( +...

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

  8. Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/else/database/create-read-only-database-user-in-sql-server.html

    the db_securityadmin fixed database role can modify role membership and manage permissions. Adding principals to this role could enable unintended privilege escalation. In theory, a user who can do nearly everything but modify access and security...

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

  9. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    system was case-sensitive despite the collation of the SQL Server being case-insensitive. What? End-users said that they could see the options "Data Not Yet Available" as well as "Data not yet available". These are obviously the same values, so I should...

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

  10. Formatting a date in an MDX queryhttps://www.joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

    when setting date as the parameter and trying to specify default date as today's in the format DD/MM/YYYY. Googled this but couldn't find an answer, then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with "=Today()" [yields: 01/01/2011] and...

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

  11. T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    case-insensitive. Furthermore, we now have the task of finding all the variations of the default values which we found we could do with the built-in SOUNDEX function. How? Lets assume the following, we have a table containing: StudentID StudentDetail...

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

  12. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF...

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

  13. T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    any of the non-numeric values to map to... Well the system thinks I might so it fails. I realised then the equals sign ("=") could be changed to a "LIKE" which will mean both values are expected to be a string. So with this in mind: SELECT r1.MapIn (...

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

  14. Compare two databases using T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/compare-two-databases-using-t-sql.html

    tools provided with SQL Server and without having to download any third-party products. Why? I googled and binged and all I could find were people selling third party products... they don't get it. If you are reading this, it's likely you've paid for a...

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

  15. Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/data-randomization-function-in-oracle-plsql.html

    to be written up all in the name of "seamless integration"... How? Previously I had tried to write a smart function which could determine the datatype automatically but as you may know, Oracle has a funny way of working with dates which made this need...

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

  16. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    the title doesn't put you off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...

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

  17. Country Lookup by IP address CSVhttps://www.joellipman.com/articles/else/database/mysql/country-lookup-by-ip-address.html

    to check where visitors were from. Note: we also use and love Advanced Web Statistics (awstats) but this was so that you could have your own country lookup script. The Download Should contain the following: create_countriesipranges_table.sql: SQL to...

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

  18. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    I could apply the PRINCE2 (Projects in a controlled environment) methodology to website projects but most people find this overwhelming. It's in business techno babble and I get asked what does this mean in stage 1? And this in stage 2? (There are over...

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

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

    members of the same character equivalence class as the specified character. For example, the following regular expression could be used to search for characters equivalent to 'n' in a Spanish locale: [[=n=]] This expression matches both 'N' and 'ñ' in...

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

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

    fjs.parentNode.insertBefore(js,fjs); } }(document,"script","twitter-wjs"); 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
Results 101 - 120 of 151