Advanced Search

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

  1. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    to: Microsoft Business Intelligence Development Studio (BIDS) Visual Studio 2008 Microsoft Windows 7 Microsoft .NET Framework 3.5 Microsoft Visual C# 2008 What? So like lots of people on the net, I've been given a datasource with names and addresses all...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  2. Run commands for Windowshttps://joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

    This is an article intended for IT Support. It is a list of the system tools available in the Microsoft Windows OS that can be run from the "Start > Run" option. How? To Access…Run Command Accessibility Controls access.cpl Accessibility Wizardaccwiz Add...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  3. SSIS: Add Reference Microsoft.SqlServer.TxScripthttps://joellipman.com/articles/microsoft/ssis/ssis-add-reference-microsoft-sqlserver-txscript.html

    custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft staff so why should their documentation include it? Workaround (applies for any dll) You right-click on the "references"...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  4. Select unique values in Microsoft Excel columnhttps://joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

    of unique values in the range A3 to A1000 and excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help sites: Office 2010: Select the data range to do this to. Click on the "Data" tab. Click on "Advanced" (Advanced...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  5. MS Excel: Convert a text to a numberhttps://joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

    This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  6. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

    to: Microsoft Windows 10 AutoHotkey 1.1.30 What? Yay for Microsoft Windows 10 in joining the rest of the Operating Systems in implementing multiple desktops. So if you have a Mac or Linux system, you will know of a feature where you can have another...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  7. Microsofthttps://joellipman.com/articles/microsoft.html

    • Type: Category
    • Language: *
  8. Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

    from my IE7 tests) ie6olas_nt (from http://browsers.evolt.org - works but installing IE8 breaks it) ie6setup.exe (from Microsoft's website advising on Run > c:\\download\\ie6setup.exe /c:"ie6wzd.exe /d:1 /s:""#E") If you only want Internet Explorer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  9. Windows Live Mail Error ID: 0x8DE00005https://joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

    to: Windows Live Mail 2012 What? A quick article on how to update the Microsoft Live Server URL for Hotmail using Windows Live Mail. Well how to deactivate an account and set up a new one in Windows Live Mail. If you used IMAP all along then the new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  10. MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

    over (reason being, the archive is 4 terabytes and backing up only the changed files would speed things up). Applies to: Microsoft Windows XP Microsoft Windows 7 Microsoft Windows 8 for Vista and Windows 2008 without XCOPY, try ROBOCOPY. How? We're...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  11. AutoHotkey: Get Media Information and Displayhttps://joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

    To: Microsoft Windows 7 Professional v6.1.7601 32-bit AutoHotkey v1.1.33.02 What? This is a copied article just to store a permanent reference for if I ever need to build an app similar to the file explorer in the Microsoft Windows OS. Why? I had an app...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  12. SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

    variable ID (@StudentReference) everytime. So after an hour or so I came across "Cascading Parameters" (http://technet.microsoft.com/en-us/library/dd255197.aspx). Maybe the answer could be in that mess of a Microsoft article but this I can already do...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    Enter this as a query in Excel without the parameters and it will work. Set MySQL parameters (using @ - same as T-SQL) and Microsoft Excel 2007 gets confused. Putting it all together Create a SQL query that will return: staffname, activity date,...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

    SQL Developer v3 (you can use any equivalent, eg. SQL*Plus) Why? I think this is one of those very rare occasions that Microsoft people can say "it's so much easier using a Microsoft product to work with another Microsoft product" (ie "Seamless...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. Administrator Program Shortcut without Prompthttps://joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

    to: - Microsoft Windows 7 Enterprise - User with Local Administrator Privileges (required for setup) Why? Our work has group policies and two of our programs, Visual Studio 2010 Ultimate (VS2010) and Business Intelligence Development Studio (BIDS),...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  16. Hide a Drive per User in Windows 7https://joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

    to: Microsoft Windows 7 Professional What? Looking at ways of displaying different drives per user on a single computer. This one is by modifying the system registry, so if you aren't familiar with the system registry in MS Windows, you may need to find...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  17. SSRS Stop Scrolling Behindhttps://joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

    to: Microsoft SQL Server Reporting Services (SSRS) 2008 R2 Microsoft Visual Studio 2012 Microsoft Business Intelligence Development Studio What? I recently revamped our standard report with a new template comprising of a single Tablix which contained...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. Windows 10: Shortcut Apps to Settingshttps://joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

    To: Microsoft Windows 10 Pro v10.0.18362 What? This is a list of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings page....

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  19. SSRS Subscriptions cannot be createdhttps://joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

    to: Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  20. SSRS Display question mark when date is blankhttps://joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

    to: Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 1 - 20 of 78

Please publish modules in offcanvas position.