Upgrading your software can be daunting, Microsoft knows. The fast pace of business makes it easy to tell yourself, “I’ll do it later when I have time.” Microsoft gets it! But here are five key reasons to make time to upgrade to SQL Server 2016, which was named DBMS of the Year in 2016 by DBengines.com.
Seamless step-up without rewriting apps. Thanks to November’s SQL Server 2016 Service Pack 1 (SP1), SQL Server now has one programming surface across all editions. If you switch from Express to Standard, or Standard to Enterprise, you don’t have to rework code to take advantage of additional features. Time saved! In addition, the change brings access to innovative features across performance, security, and analytics not previously available in Express or Standard—a great reason to upgrade applications that run on those editions. The Enterprise edition of…
Recently I was tasked with the task of creating an automatic extraction and importing solution using PowerShell Scripts. To do this I created two files one for export and extracting with the other in charge of pack and importing the solution. I was using the Visual Studio template of CRM Package that comes with the sdk.
Export and Extracting The Solution
First thing I did was implement the export and extraction of the CRM solution. The PowerShell script first exports the solution from the web using a module called Microsoft.Xrm.Data.PowerShell. Then it extracts the downloaded zip into a folder for the correct file structure. A nice thing about using the Microsoft.Xrm.Data.PowerShell dll is the fact it gives you additional CRM commands you can do. For example before downloading the solution it allows you to change the version number of the solution before downloading.
Quick measures, a new feature Microsoft released in their April Power BI Desktop update, lets you quickly create new measures based on measures and numerical columns in your table. These new measures become part of your model and can be used in any of your charts, just like manually created DAX calculations. You can also see the underlying DAX, and edit it if you need to tweak the results.
You can create measures based on 19 different calculations across five different categories. Let’s take a look at those five different categories.
Aggregate within category
These calculations let you apply different aggregates at different levels in your data. For example, you can sum revenue up to the month level, and then take an average of that total to display at the year level.
The result would look something like this:
The calculations included in the Aggregate…
This is the error I received when trying to import a managed solution into an organization where an early version of it already existed.
From the import log :
Plugin Types import: FAILURE. Error: Plugin: [PluginAssemblyName], Version=188.8.131.52, Culture=neutral, PublicKeyToken=c66c1d5121b276ee of PluginTypeName: Microsoft.Crm.Entities.PluginType and PluginTypeNode: System.Xml.XmlElement caused an exception.
This one was new to me and caused me to have to do some digging, first I had to be reminded how to start digging, and the first step should be to enable tracing, which you can find here : https://support.microsoft.com/en-us/help/907490/how-to-enable-tracing-in-microsoft-dynamics-crm. Then after that do your import and go to the TraceDirectory to find the internal exception causing this import exception.
That lead me to this exception from the trace logs :
>Crm Exception: Message: Plugin Types import: FAILURE. Error: Plugin: [PluginAssemblyName], Version=184.108.40.206, Culture=neutral, PublicKeyToken= of PluginTypeName: Microsoft.Crm.Entities.PluginType and PluginTypeNode: System.Xml.XmlElement caused an exception., ErrorCode: -2147188718, InnerException: Microsoft.Crm.CrmException: A managed…
The Microsoft Educator Community recently launched a new bot built with the Bot Framework to provide educators with a personal human-like assistant that can direct them quickly to relevant content. One of the key roles of the bot is to help educators better engage with Office 365 and develop their teaching skills with Microsoft’s Office products.
Since the bot was added to the site in January, engagement with the bot has been high, with over 40,000 messages from educators being exchanged. Educators have found the bot to be human-like, valuable, and easy to use. They shared positive praise for its assistance and helpfulness. In fact, Microsoft is beginning to see a trend towards educators preferring to start their engagement on the site with the bot. Educators who use the bot during their visit to the site have 3-times longer session duration…
We have all encountered intranets in our professional lives. Often, the intranet is where information goes to die and is forgotten. How do we break away from this pattern? Depending on whom you ask, some users may view the intranet as a tool to find HR Related information; others may use it to work collaboratively with a team who works remotely, and some will simply resist using it at all.
The road to overcoming common intranet missteps and misconceptions begins with a proper envisioning. We will discuss the process of envisioning a successful intranet, starting with a handful of factors: user and business stakeholder interviews, project requirements, documentation, and being mindful of the unique needs of your users as intranet solutions are not one-size-fits-all between companies—or even between departments within a single company.
The first group of people you are going…
While cloud security continues to be a top concern, Microsoft recently shared insights from a survey that show overall concern has dropped significantly since 2015. They’re now at a stage where half of organizations contend the cloud is more secure than their on-premises infrastructure. In conversations Microsoft has with their customers and partners, they hear increasingly about how using the cloud improves an organizations’ security posture. As many organizations push forward on their digital transformation through increased use of cloud services, understanding the current state of cloud security is essential.
Maintaining a strong security posture for your cloud-based innovation is a shared responsibility between you and your cloud provider. With Microsoft Azure, securing cloud resources is a partnership between Microsoft and their customers, so it’s essential that you understand the comprehensive set of security controls and capabilities available to you on…
Introduction – Part 2
Part 1 of this post focused on the first category of how the Analysis Services Multidimensional (MD) duplicate attribute key error can arise. It reflects the perspective of an atomic attribute – an attribute having no attribute relationships other than with the dimension key attribute.
This post focuses on the second category of this error, which can arise when an attribute does have attribute relationships besides the (required) one with the dimension key attribute.
As is well known, creating attribute relationships is a best practice in Analysis Services MD for improving query performance. The most common reason attribute relationships are created is to support a natural hierarchy – so your data model has to have one for this to arise. The next most common reason is to support attribute properties, such as a sort order – i.e. when the…
In the modern workplace, an organization’s most important assets are its people. The knowledge, skills and expertise found throughout your carefully recruited teams are tantamount to individual and collective success.
All too often, however, this specialized knowledge is obfuscated by physical and organizational barriers. People know what information they need, but are unable to track down the answers they’re looking for. The popular adage “It’s not what you know, it’s who you know” reminds us that the best-connected employees get the most done.
That’s where Office 365 can help. As Microsoft works to reinvent productivity for the modern workplace, their goal is to put people at the center of the connected suite experience. When you’re able to tap into the hidden knowledge throughout your organization and leverage your talent pool, you’re able to achieve more.
Starting today, Microsoft is rolling out an extended…
Office 365 customers, known as tenants within the configuration, all share Microsoft’s global datacenter infrastructure, which is composed of hundreds of thousands of servers located all over the world.
Within the tenant, customer data is housed in a region, based on their location and settings, as shown from the drop-down box displays.
Microsoft replicates customer data automatically across at least two datacenters at any given time to minimize against losses during any failover.
When you choose a region, you can see what data is where (when at rest) between the zoomed view and the details in the right margin:
Microsoft operates over 100 datacenters globally and continues to open more datacenter regions for Office 365 for business services. That being said, not every datacenter is used to host Office 365 and its services, but they do add to the available capacity (storage) and other…