System Requirements for Microsoft Dynamics GP 2018

Microsoft has announced the system requirements for Microsoft Dynamics GP 2018 which is to be released on December 1 2017. 

The details are here: https://mbs.microsoft.com/customersource/northamerica/GP/learning/documentation/system-requirements/MDGP2018_System_Requirements.

The requirements listing is very thorough, and, needs to be read carefully.

Client Requirements

image

image

image

New Features in Power BI From June 2017 Release

image

Figure 1 – Explanation of Power BI from https://powerbi.microsoft.com

On June 12, Amanda Cofsky, Program Manager for Power BI, provided an overview of the new reporting features available as of June.  The link to download Power BI is…. http://powerbi.microsoft.com/desktop?WT.mc_id=Blog_Desktop_Update.

Here’s the complete list of June updates from Cofsky’s blog posting.

Reporting
  • Data bars for new table & matrix (preview)
  • Markers on line, area, & combo charts
  • Accessible reports
    • Consume Power BI reports with keyboard navigation and screen reader support
    • Create accessible reports
  • Visuals font family setting
  • Horizontal Image Slicer
  • Combo chart formatting updates
    • Force zeros to align between the two axes
    • Shade area of the line
  • Bing maps improvements
    • Map themes
    • Improved geo hierarchy experience
  • High density line sampling
Data connectivity
  • Custom Data Connectors support
  • Power BI service Live Connect to On Premises and Push streaming datasets
  • Impala connector is now generally available
  • Amazon Redshift connector is now generally available
  • SAP BW connector – DirectQuery support (beta)
  • IBM Netezza connector (beta)
Query editing
  • “Add Column from Examples” enhancements

You can watch a video of the new features by clicking on https://youtu.be/YlNVE5dgcSI (Power BI Desktop Update – June 2017).  Remember that YouTube links can change from time to time so this link may change over time.


Create a SQL Server Utility Control Point

image

Figure 1 – SQL Server Utility Configuration Steps that show up on the Utility Setup

You may have read my previous post – Solving – WMI Provider Error, and how the issue was solved by creating the Utility Control Point (UCP). 

The Utility Tool has some excellent features that track the health of SQL Server.  So, what do you need to know about it?

Benefits of the SQL Server Utility

The SQL Server Utility models an organization’s SQL Server-related entities in a unified view. Utility Explorer and SQL Server Utility viewpoints in SQL Server Management Studio (SSMS) provide administrators a holistic view of SQL Server resource health through an instance of SQL Server that serves as a utility control point (UCP). The combination of summary and detailed data presented in the UCP for both underutilization and overutilization policies, and for a variety of key parameters, enables resource consolidation opportunities and resource overutilization to be identified with ease. Health policies are configurable, and can be adjusted to change either upper or lower resource utilization thresholds. You can change global monitoring policies, or configure individual monitoring policies for each entity managed in the SQL Server Utility. – from https://docs.microsoft.com/en-us/sql/relational-databases/manage/sql-server-utility-features-and-tasks

The information below describes that an organization can have many SQL Server Utilities. 

An enterprise can have multiple SQL Server Utilities, and each SQL Server Utility can manage many instances of SQL Server and data-tier applications. Every SQL Server Utility has one and only one utility control point (UCP). You must create a new UCP for each SQL Server Utility. Each managed instance of SQL Server and every data-tier application is a member of one and only one SQL Server Utility, and is managed by a single UCP.+

The UCP collects configuration and performance information from managed instances of SQL Server every 15 minutes. This information is stored in the utility management data warehouse (UMDW) on the UCP; the UMDW file name is sysutility_mdw. SQL Server performance data is compared to policies to help identify resource use bottlenecks and consolidation opportunities.  – from https://docs.microsoft.com/en-us/sql/relational-databases/manage/create-a-sql-server-utility-control-point-sql-server-utility 

The listing of requirements and recommendations is list at the same hyperlink noted above.

Solving – WMI Provider Error Invalid Namespace in SQL Reporting Services Setup

image

Figure 1 – SSRS error during setup of SQL Reporting

You’ve installed SQL.  Everything went well and you have all the different tasks showing as being successful.  Then you go to install SSRS Reporting Services, and you get the message….

I keep getting ‘Cannot connect to SERVERNAME’, ‘Report Server WMI Provider Error: Invalid namespace

The answer to fixing this error, at least the answer that worked for me, is:

To install/reinstall/repair SSRS, run the SQL Server setup utility and choose the advanced or custom option which will allow you to choose only the components you wish to install.

Big question – what does the Utility Control Point do?

The SQL Server Utility is managed through a utility control point using Utility Explorer in SSMS. The UCP is configured on an instance of SQL Server. It provides the central reasoningpoint for the SQL Server Utility using SSMS to organize and monitor SQL Server resource health.

1. To create the SQL Server Utility begin with opening the SQL Server Management Studio.  I am using SQL 2014.

2. Then click on VIEW, and find UTILITY EXPLORER, as below.

image

3. Click on UTILITY EXPLORER to open up the next window, and click on CREATE UTILITY CONTROL POINT.

image

4. This opens up the window below which gives you very clear steps to follow to create the Utility Control Point.  

image

The process of creating and validating the SQL Server instance cleared up the issues that I had with WMI not distinguishing instance names, and solved my problem.  I was able to install Reporting Services, and to configure SSRS reporting to suit my requirements.

How I Use OneNote

image

Figure 1 – My Technology notebook showing multiple sections

Thank you to the folks that have emailed me and asked me how I use OneNote in my daily work. 

I am happy to answer that question.  OneNote has a tiered organizational system that begins with notebooks, and divides the notebook into sections, and then lets you record notes in each section by page.

I have several notebooks.  However, the one that I use the most is my TECHNOLOGY notebook.  You can see how I break down the sections in Figure 1 above.

Below, in Figure 2, is a sample of the section – Dynamics GP – and an illustration of the different pages that I have in that section.

image

Figure 2 – Sample of pages from my section on Dynamics GP in OneNote

Everyone will arrange their information differently.  This is the arrangement that works for me.  Why I like OneNote so much is that it is online, and I can pull it up from any of my devices, or from a browser at a client site.  While it is easy to say that one should remember all the things that you have done on a software, I have learned that if you only do something once a year, sometimes you need to go back and look at the steps and rules.  I am often changing my pages because process and steps get updated during the passing of the year, either because the software was updated or because of third party add-ons that change the process.

Why I love working with OneNote

1) With OneNote Clipper, I can take articles or information from the internet and store it until I am ready to clean it up and add it to my notebook.

2)  If I am working on a research project, I can create a notebook for the research, copy it in, and then categorize it, and then wipe it out when I am done.

3) I don’t use them often, but the drawing tools are pretty good and let me create quick work flows or mind maps.

4) I love the fast SEARCH function.

5) The VIEW toolbar lets me pin my OneNote info so it is easy to get at.  See Figure 3.

image

Figure 3 – The VIEW Toolbar in OneNote, highlighting the DOCK to DESKTOP feature

As with starting anything new, using OneNote does require some practice and you may not get it right the first time.  I didn’t. The trick is to wipe it out and to start over until you get it right for the way that you work.

More on OneNote

Note: use CTRL+Click to go to sites

OneNote for Beginners
Insert online videos into OneNote 2016 for Windows
New Features Added to OneNote
How To Move from Evernote to OneNote
New Features in OneNote At January 2016

Microsoft Press Sale Until July 31 2017

image

If you are looking at writing any Microsoft exams over the next several months, then you will want to look at all of the Exam Reference guides that are on sale until July 31, 2017.  Click on this link to see all of the volumes that are available.

https://www.microsoftpressstore.com/promotions/cert-sale-save-up-to-55-on-exam-prep-books-ebooks-141071

There are two good reference on Office 365.

image

Update – Office 2007 support ends on October 10, 2017

image

Microsoft announced that the company’s support for Microsoft Office 2007 will end on October 10, 2017, a little over three months from now.

When Office 2007 reaches its End of Life on October 10, 2017, Microsoft will no longer provide:

  • Technical support for issues

  • Bug fixes for issues that are discovered

  • Security fixes for vulnerabilities that are discovered

In addition, as of October 31, 2017, Outlook 2007 will be unable to connect to Office 365 mailboxes, which means Outlook 2007 clients using Office 365 will not be able to receive and send mail.

Open Live Writer Version 0.6.2 Is Now Available

image

For those of you that missed it, Open Live Writer had an update in May 2017.  Remember, Open Live Writer works with many popular blog service providers such as WordPress, Blogger, TypePad, Moveable Type, DasBlog and many more.  This is my favorite blogging tool.

I have provided some information from the team’s release notes, but not everything that is changed is included.

From their website http://openlivewriter.org/

We’re happy to announce a new release of Open Live Writer. We hope you enjoy the new features as much as we enjoyed working on them. Read on to learn more about what issues have been fixed and what features have been added.

The next time you start Open Live Writer and are connected to the internet, it should get updated automatically. But if you can’t wait to try out the goodness, download the updated setup here.

Bug fixes

  • #562 Error: Can’t Publish Files- The remote server returned an error: (501) Not Implemented

This is the master issue for the Google Blogger image publishing problem. Other issues associated with this problem include #608, #600, and #564

  • #437 Blogger dynamic templates #438 Fixed WordCounter regex to support Hebrew/Arabic #521 Support atompub service link with relative url #487 Adding new intillesense db file to gitignore. Minor annoyance

Features

#450 Fix scaling of categories dropdown and options dialog #585 Implement per-monitor DPI Support #180 Add support to CSS3 templates

Sandbox Applications for Window 10

image

Figure 1 – Visual image of what a Sandbox environment looks like when a Sandbox is installed on a PC (Image from Comodo.com)

I have some testing that I want to do on my laptop, and I was looking for the safest way to create an environment for completing this testing.  I know that I can use the Hyper-V on my Windows 10.  However, I am finding that it is not so user friendly.  I wanted something really easy.

I found a great article on www.maketecheasier.com called “5 of the Best Sandbox Applications for Windows 10” https://www.maketecheasier.com/best-sandbox-applications-windows10/.

If you are wanting to create a Sandbox environment to test out software, take a look at the article.

Let me know which sandbox app that you choose with some feedback on how it works for you.