Go Premium for a chance to win a PS4. Enter to Win

x

Microsoft Applications

43K

Solutions

37K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Share tech news, updates, or what's on your mind.

Sign up to Post

Microsoft's Excel has many features that most people will never need nor take advantage of. Conditional formatting is one feature that you may find a necessity once you start using it.
1
Veeam Task Manager for Hyper-V
LVL 1
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Fonts
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how to install downloaded fonts.
6
 
LVL 25

Expert Comment

by:Brian B
Comment Utility
That is a really useful article, Andrew. Thanks for sharing.

A question though, back in the "old days" by my standards, you weren't supposed to share fonts because many of them were sold separately and were considered to be under the software license of the product they worked with. I would assume if you can get the font from Google that it is safe, but are there still instances of those IP fonts today that aren't supposed to be shared?
0
 
LVL 12

Author Comment

by:Andrew Leniart
Comment Utility
Hi Brian,

An excellent observation. With regards to safety of available fonts, I can only assume that all submissions are checked by Google in this respect before a listing is accepted, so while never beyond the realms of possibility, am confident that a malicious font download is unlikely.

I'm sure there are many fonts to be found on the web which are not supposed to be shared as you've rightly pointed out, however with every font downloaded from the Google Fonts site, there is also a license agreement included within the downloaded Zip file that specifies which usage license the font has been released under.

In the case of the illustrated "Lato" font used in my example, that particular font has been released under the Sil Open Font License (OFL) and comes with the following conditions when downloaded.
PERMISSION & CONDITIONS
Permission is hereby granted, free of charge, to any person obtaining a copy of the Font Software, to use, study, copy, merge, embed, modify, redistribute, and sell modified and unmodified copies of the Font Software, subject to the following conditions,
The list of exclusions are as one would expect for most open source material, such as preventing the sale of the font by itself etc, however for personal or commercial use within other products, there's no problem.  This could differ of course with each font that's made available so it always pays to check what rights are provided. Font families not available on Google Fonts and found on other font distribution sites would of course contain their own rules and restrictions, which should always be respected.

I hope that answers your questions and thank you for your feedback and up-vote. I very much appreciate it. Regards, Andrew
2
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
0
Decision Making
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
28
 

Expert Comment

by:Brendan Wilson
Comment Utility
This is an excellent article. I appreciate you taking the time to write this.
1
 

Expert Comment

by:Judy Deo
Comment Utility
Thanks for taking the time to post this in such detail. Appreciate it.
1
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to do.
27
 

Expert Comment

by:Brendan Wilson
Comment Utility
I read the other article that you wrote, and they both have been very useful. Thank you for taking the time to put this information together.
2
 

Expert Comment

by:Judy Deo
Comment Utility
Wow this was so simple and I did not know it. Nice to know now and I know for sure I will have many opportunities to use this in the future.
1
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)
 

Step 1: Make sure you meet the requirements!


Operating System Requirements

  • Windows Vista (any edition) with the latest service pack
  • Windows 7
  • Windows Server 2008 with the latest service pack
  • Windows Server 2008 R2
(Taken from http://technet.microsoft.com/en-us/library/hh519788.aspx as of 12/9/2014)

Note: I have tested the installation on Windows 8.1 and can confirm it is working here too, leading me to conclude it should also work on Windows Server 2012 R2 as well (although I have not tested this personally).
 

Additional Requirements


  • Microsoft .NET Framework 3.5, which you can download from the Microsoft Download Center.
  • Microsoft Visual Studio 2008 Shell, which must be in the same language as the display language of the operating system. You can install Visual Studio 2008 Shell from the Prerequisites page in the Service Manager Authoring Tool Setup Wizard.
     
Note: During Authoring Tool Setup, if an error appears stating that Microsoft Visual Studio Shell 2008 is not installed and you’ve verified that it is installed, then the Visual Studio 2008 Shell Isolated Mode Redistributable Package might not be installed completely. To install it, navigate to \VS 2008 Shell Redist\Isolated Mode\ and run VS_Shell_isolated.enu.exe as administrator.
 …
1
PowerPoint Still Works
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
0
 

Expert Comment

by:Taylor Swift
Comment Utility
I'd like to start a blog so I will be able to share my experience and feelings online. Please let me know if you have any kind of ideas or tips for new aspiring blog owners. Appreciate it!
0
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take you a long step deploying successfully.
2
 
LVL 66

Expert Comment

by:Jim Horn
Comment Utility
Nice article, voted yes.   I think this article can be improved if the script were rendered in pieces-parts code blocks, with helpful text explanation on what the script does, so that experts can get an understanding and manipulate if they have to.
0
Main Metering Runbook
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
2
 
LVL 66

Expert Comment

by:Jim Horn
Comment Utility
Nicely illustrated and reads very well.   Voted Yes.
0
 
LVL 66

Expert Comment

by:Jim Horn
Comment Utility
You're welcome.  Nice work.

Speaking of .. my recent article just went Featured Article ... Top 10 Ways to Write Rock Star Articles
0
This collection of functions covers all the normal rounding methods of just about any numeric value.
3
 
LVL 52

Author Comment

by:Gustav Brock
Comment Utility
Finally I have these assembled. Through the years bits and pieces were collected, but now I had the option for a rewrite.

/gustav

PS: There are minor flaws in the layout but the editor is somewhat strange so I couldn't get it completely straight.
0
 
LVL 66

Expert Comment

by:Jim Horn
Comment Utility
Nicely laid out.  Voted Yes.
0
Free Backup Tool for VMware and Hyper-V
LVL 1
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Windows 10 is spying on you
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the information it can gather - without you knowing!
7
 

Expert Comment

by:Mark Rhodes
Comment Utility
Excellent I will get this set up and Thanks for the step by step
0
 
LVL 30

Author Comment

by:Thomas Zucker-Scharff
Comment Utility
Anytime - just be careful when installing - always use custom install.
0
Delete Emails from Server
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  At least at my institution, one has to show a business need for such an action.  So proceed with caution, and remember if this is an attempt to keep the email you have received so far private, it won't work.  Backups are there for a reason.  An email you receive going forward would not be stored on the exchange server, so would not be accessible as easily.  But anything going through your work network is available to your bosses in some shape or form.

So first, the easiest way to do this is with outlook.  This example will use Outlook 2010 on a windows 7 Pro 64bit computer connected to an Exchange 2010 installation.  One of the only reasons I am writing this is because in the past week I have either had several requests or seen several questions here on Experts Exchange asking for just this information.  

I made a quick silent video of the process here.  the video repeats what is listed below, with some emphasis of what to do when.  It comes down to the following:
  1. Start outlook
  2. When you see the main Outlook window, click on the file menu
  3. After clicking on the File menu you should see the following screen:file-menu.PNG
  4. Click on Account settings and in the drop down click Account Settings again and this screen should pop up:data-files-settings.PNG
0
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring.

SCOM monitors:
 
  • Windows or UNIX/Linux
  • Network Devices
  • .Net application (APM)
  • Java application
  • Web Application as well as URLs
  • More monitoring capabilities by using the management packs which help to monitor specific objects or application….
SCOM has the ability to send you alerts when a monitored object is not healthy, providing you with information about the problem and how to resolve it.
 
The main SCOM components and roles are:
 
  1. Management Server
  2. Resource pool
  3. Gateway Server
  4. Operational Database
  5. Data warehouse
  6. Agents
  7. Services
  8. Managemet Packs
  9. Reporting
  10. ACS (audit collection service)
 
  • Managemet Server:
When you want to install SCOM 2012 and during the setup, you will be asked to create a management group. The MG contains the management servers you want to add to your environment. The management server manages the MG and communicates with agents and databases.
 
  • Resource Pool
When you add another management server to your SCOM environment, the management servers will be members of a resource pool, so you can distribute works between the management servers and grant high availability when a management server member is failed.
 
  • Gateway Server
A gateway server will help you to monitor objects in an untrusted domain. For more details see
0
Many companies are making the switch from Microsoft to Google Apps. Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps.

It is important to note that there is a pricing plan to use Google Apps for businesses. The cost is $5 per user per month or $50 per user per year. The pricing for Microsoft Office 365 is much more complex and expensive.  

First and foremost, for those who are unfamiliar with Google’s office integration platform, Google Apps works similarly as Microsoft Office 365. Gmail and Google Calendar can substitute Microsoft Outlook and Microsoft Exchange. Google Drive contains platforms that are similar to Microsoft Word, Microsoft Excel, Microsoft PowerPoint and Microsoft One Drive. All documents made through Google Drive can be shared with others. Google Drive will allow users to edit files in real-time as well.
 
Google Drive includes services such as Google Docs, Google Sheets and Google Slides. These can be accessed online or by downloading the respective app through your smartphone. Through the web you can access and edit all your files through Google Drive. On your mobile device you must download each separate app to use the editing function. Google Drive can sync documents by using the cloud and also allows users to collaborate on files offline. 
 
The most …
13
 
LVL 13

Expert Comment

by:Greg Hejl
Comment Utility
Most folks are to tied to the Office Apps to give up on them.  if you tie Google Apps cost and the cost of Office licensing you might as well get on board with O365 for the online experience as well as the device experience for the same overall price.
0
 
LVL 4

Expert Comment

by:pchettri
Comment Utility
Office365 does offer web version to application access. It is specially useful for saving documents on Onedrive, when you are accessing application form tablet or phone. Most of the plan allows application access for up to 5 devices. For laptop or desktop,  I would prefer full downloaded version which gives option to same on OneDrive or local drives. 5 devices option is same for business essentials/premium, E3 or E5, of course the application and storage varies with plan
0
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings). The Microsoft support team will tell you to open Lync federation for this to work or use the Lync web app instead. How do you expect corporate users to be copying meeting URLs and pasting them into web browser and then insert "?SL=1" at the end of the link?

Problem:

Here is the eror message we get each time we click on join online meeting link in outlook to join a non-federated user's meeting.

For Lync 2010: "an error has occurred during online meeting"
For Lync 2013: "An error occured during the Lync Meeting"

Brief description of our network environment:

Our organization deployed a proxy auto-config file for all users as they access the Internet, firewalls and are doing inpections on all traffic. We do not open Lync federation because our Corporate Security Group declined all requests to do so. After many years of struggling, we resolved this issue without opening federation.

Resolution:

On a user's computer, using Lync 2010, open regedit and navigate to
HKEY_CURRENT_USER\Software\Policies\Microsoft\Communicator

Open in new window



Locate "DisableHttpConnect" and change the value of the REG_DWORD to 0.

By default it is set to 1. Use this new setting to enable the Lync …
0
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basically letting the management server know, “Hey I am still ok and here”, the interval is by default every 60 seconds, but this is customizable. When the guys checked these agents they were online and functioning with no apparent issues, so it made me think, the only thing it could be is stale alerts or something wrong with the agents.

Now I love automation and always having some excuse to use Orchestrator, so when the guys asked if I could make it easier for them to automatically get and repair these agents I jumped at it, literally.
System Center Orchestrator is Microsoft’s workflow management solution that allows you to automate the creation, deployment and monitoring in your environment, you will notice that I mention the word “Runbooks”, now runbooks contain the individual instructions for your automation process and each step is called an activity and each of these activities have configurable settings.

While creating mine I found this article from Nathan Olmstead: http://blogs.technet.com/b/systemcenterramblings/archive/2014/03/22/runbook-for-persisting-stale-heartbeat-alerts-in-scom.aspx
2
The canonical version of this article is on my web site here:
http://iconoun.com/articles/collisions/

A companion presentation is available here:
http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
15
 
LVL 111

Author Comment

by:Ray Paseur
Comment Utility
@jason1178: Coming from you that is a great compliment!  Thanks, ~Ray
0
 
LVL 16

Expert Comment

by:DansDadUK
Comment Utility
An excellent article.

I spent years persuading other people (in the Western world) to use the 8-bit ISO-8859-1 coded character set, rather than switching between various National Language Variants of the 7-bit US-ASCII coded character set in order to use (relatively common) accented characters.

Moving to UTF-8 is the way to go now that 256 characters (strictly 191 graphic characters plus 65 control codes) of an 8-bit encoding is no longer sufficient in our increasingly global environment.
0
MS Access 2003 or later To MySQL Migration Project

Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I find some time to write down my project experience on the same, thought some of you may get some help out of it!

Background Information/Available Alternatives  

The Database Application is built and developed in MS Access 2003, it is further splitted in Front-End and Back-End to perform in Multi-User environment. However, due to more concurrent users, slow network, increasing data etc. the existing architecture is resulting poor performance. To increase the backend stability, application performance and considering zero cost MySQL Server (http://dev.mysql.com/) is being opted.

Business Goals and Objectives      

The business goals and objectives for this project will focus on implementing MySQL backend that:
      
•      A faster Database.
•      Zero Cost.
•      Open Source.
•      Scalability (No more 2 GB Limitation).
•      Heavy Duty Multiple User Capability.
•      Portability for the Back-End Data (PC, Mac etc.)
•      Easy Installation.
•      Easy Maintenance.
•      Provides high levels of data security.
•      Provides an open, flexible, reliable technology base for the future.
•      Easy to Use.


Scope Definition
      
The Project will introduce new faster backend storing and querying technology; including the following:
      
 
•      …
0
This very simple solution applies to a narrow cross-section of the "needs to close" variety.
In this case, the full message in Event Viewer was in applog, Event ID 1000:

Faulting application iexplore.exe, version 8.0.6001.18702, faulting module msxml3.dll, version 8.100.1052.0, faulting address 0x000a1425

Original message was in French:
Application défaillante iexplore.exe, version 8.0.6001.18702, module défaillant msxml3.dll, version 8.100.1052.0, adresse de défaillance 0x000a1425

My user was on a fully patched Windows XP SP3 PC. One Windows update had been installed the previous evening, KB973904. Uninstalling it sped up IE performance, but did not solve the problem of the error message.

Uninstalling and reinstalling IE restored functionality to the user's web-based applications (some Flash and Java), but the error message still appeared when opening a session in the web-based app.

Solution: the error message was ultimately eliminated by going into Add/Remove Programs and repairing MSXML 4.0 SP2 (KB954430).

Hope this helps someone else out!
1
Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. The bad news is that all existing contacts will not.

A field in the contact record called Message Class determines which form is used, but the Message Class field cannot be changed manually. The typical approach to solving this problem is to write VBScript code that changes Message Class to the new form for all items in the folder. Examples of this approach may be found in the Microsoft Knowledge Base (How to update existing items in an Outlook folder to use a new custom form) and here at Experts Exchange (Changing Message Class and Journal Values Programmatically). However, many users don't have the skills to deal with VBScript code and add it to Outlook Macros (or are reluctant to do so).

Solution: I had this problem myself, as I wanted to change more than 2,000 contacts to use a new form. I found an excellent, free, out-of-the-box application to do this and wrote this article to share the solution with the Experts Exchange community. There is no VBScript code and no changes to Outlook's Macro handling (in fact, no changes to Outlook at all). You simply run a program (no installation/setup necessary – just run the EXE).

The program is called DocMessageClass (the executable is DocMessageClass.exe
4
I wanted to share this with fellow Experts, who might not know.

How often have you wanted to learn something, only to be set back by either restrictions imposed on "trial" or "evaluation" software?  How often have you had to rebuild a home network due to the evaluation time period ending, thus asking you to pay for a product which in no way is going to be used as an Enterprise product at all, but rather as a learning tool?

Then, I may have an answer for you.

Caveats:
- Must be a student!
- Must have a .EDU email address (your school must issue you one).

- >>> See Below On How To Gain Access Without A .EDU Account <<<

Instructions:
- Go to https://www.dreamspark.com/default.aspx
- Sign up for an account by following the directions.  You will be asked for your .EDU email address, so be sure to have a way to log in to it, as your account information will be sent there.

"But, ThatSharePointGuy, I don't have a .EDU account for my school, but I AM a Student!"
- Go to http://msdn.microsoft.com/en-us/academic/bb250597.aspx and read about the ELMS for MSDN Academic Alliance (MSDNAA).
- Notice, that your educational institution must be a partner with Microsoft E-Academy, which offers online courses in Microsoft Information Technology subjects.
- To get an account, you need to go to http://www.e-academy.com/msdnaa_request.cfm and fill out the request form.  
- To do so, you must have the name of your institution's…
8
 
LVL 6

Author Comment

by:ThatSharepointGuy
Comment Utility
Cheers :)
0
 
LVL 5

Expert Comment

by:Attlax
Comment Utility
Nice share!
0

Microsoft Applications

43K

Solutions

37K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.