Support for SQL Server 2008 Is Ending… What should I do?

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

 

Continue reading
  2699 Hits

Retrieving Data in Microsoft Dynamics CRM

MS Dynamics CRM vs SalesforceSign up for a free CRM course!Learn more about CRM's features

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.

To learn more about how WebSan Solutions can support your Dynamics CRM projects and implementation, visit our Solutions page or contact us

Continue reading
  6687 Hits

SSRS Reports in Dynamics GP

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.

[caption id="attachment_674" align="aligncenter" width="300" caption="SSRS Reports in Dynamics GP"][/caption]

Continue reading
  9994 Hits

The Top 3 new enhancements in Microsoft Dynamics GP 2010 R2

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.

Continue reading
  6552 Hits

Multi-Award Winning

Gold Microsoft Partner

Microsoft Partner of the Year

Dynamics 365 Business Central

Microsoft Canada Impact Award

Business Applications

Microsoft Inner Circle

Business Applications

© Copyright 2022 WebSan Solutions Inc.WEBSAN is a trademark of WebSan Solutions Inc. Registered in Canada and other countries.