Over the last few years, Microsoft has been making significant investments in the cloud. Unfortunately, that means that Windows Server 2008 and SQL Service 2008 will reach the end of support. But don’t worry, Microsoft has created a pathway for companies ready to make the switch to the cloud.
Why should I make the switch to the cloud?
Moving to the cloud is no longer an intimidating transition. Companies of all sizes have made the switch to the cloud, and we don’t see that trend slowing down any time soon.
Here are a few trends that are noteworthy:
- In 2016, 16.1 ZB of data was generated. In 2025, 163 ZBs of data will be generated.
- More than 80% of organizations now adopt cloud-first strategies as part of an overall digital transformation
- Investment in AI, top of mind for many companies, increase by an astounding 300% in 2017
When is the deadline and what happens if I do nothing?
It’s better that you act now and not later, time is running out. Extended support for SQL Server 2008 and 2008 R2 ends on July 9, 2019 and Windows Server 2008 and 2008 R2 ends on January 14, 2020. These deadlines are around the corner; you need to give yourself time to migrate and explore your options.
If you decide to do nothing, then be prepared for no security updates, compliance concerns and missed innovation opportunities.
What are your options?
You have options, for both on-premise and cloud migrations. If you plan to stay on-premise, you can upgrade to Windows Server 2016 and get cloud and DevOps ready. If you decide to move the cloud, you can migrate Windows Server 2008 and 2008 R2 workloads to Azure VM.
For more information about upgrade options across cloud and on-premise, visit: www.microsoft.com/lifecycle
1. IDC White Paper, Data Age 2025: The Evolution of Data to Life-Critical
2. Building Trust in a Cloudy Sky:https://www.mcafee.com/us/resources/reports/rp-building-trust-cloudy-sky.pdf
3. A Trillion-Dollar Boost: The Economic Impact of AI on Customer relationship Management: https://www.salesforce.com/content/dam/web/en_us/www/documents/white-papers/the-economic-impact-of-ai.pdf
Retrieving data and metadata for reports In Microsoft Dynamics CRM can be done using SQL views. In Dynamics CRM, users can run queries on SQL views that are automatically created. As the image below shows, names within the SQL views are easy to identify. A Microsoft tip sheet notes that SQL-based reports in Dynamics CRM use the filtered views provided for each entity to retrieve data for the reports.
To obtain the query, users can download the SQL Server Management Studio (SSMS) online.
Apart from being automatically created, Filtered Views offer the benefit of being updated for custom entities, having security embedded in the view, and being supported after patches, service releases and upgrades.
Linz Tan, Web Marketing Assistant, WebSan Solutions Inc. a 2014 Ontario Business Achievement Award Winner for Service Excellence.
For some of the more technical Microsoft Dynamics GP users, you may want a little more control and customization when reporting on your GP data. SmartLists provide a fairly quick and dynamic option to custom reporting, but they may not be visually satisfying. On the other hand, integrating BI360 with GP will allow you create very clean and organized reports in an Excel-like environment, but won’t give you that rudimentary control that your technical mind may crave. If you’re looking for some sort of middle ground between these two options, take a look at SQL Server Reporting Services (SSRS) for Dynamics GP.
The key to creating effective SSRS reports is having a good knowledge of SQL – or at the very least, a fairly strong knowledge of databases. This is what scares away some users, but for those that have this type of background, SSRS Reports could be your salvation in the pursuit of both visually appealing and fully customizable reports.
While SSRS Reports can be easily viewed within Dynamics GP, they are created in Microsoft Report Builder – a separate software program that is offered for free by Microsoft. Using Report Builder allows you to take a custom SQL query that you have created (either from scratch or by using Report Builder’s intuitive Query Designer) and turn it into an appealing report. With the ability to easily create tables, charts, and even visual scales/gauges, you can turn a simple list of data into a work of art!
If you have SSRS Reports deployed in your GP environment, you can view them by going into any series and selecting the “Reporting Services Reports” item in the Navigation Pane.
By: Rahim Jiwani, Application Specialist, WebSan Solutions Inc.
The release of Microsoft Dynamics GP 2010 R2 is very feature rich. Of all the features, there are a few that really stand out and that you should know about.
We’ve compiled a list of the top three enhancements of Microsoft Dynamics GP 2010 R2 based on feedback we’ve receive from our clients. Their willingness to help us enhance our services makes this a more complete solution for small and medium-sized businesses, putting you in a better position to enhance your organization successfully.
SQL Server Reporting Services - Create report packages with predefined settings so that your employees can use the work independently.
Word Templates - Amped up even more templates, the ready to use Word forms now include orders, invoices and returns.
Smart List Builder - Publish multiple Excel reports at once. You can use the new Bulk Deploy Excel Reports window and select multiple Excel reports to publish at once, rather than publishing them individually.
We encourage you to share your thoughts and reactions with us at any time.