back to homepage

sql server Free Articles

What are the Ways to Become a SQL Developer?

As an online training platform, many times we are posed with queries like How Can I become a SQL Server Developer? What is the learning path? What should I do to become a successful SQL Server DBA?

Read More

Microsoft Dynamics GP 10.0 Software Development notes

As Microsoft Great Plains consultant or programmer, you should be familiarized with GP modification, customization, reporting and data conversion migration tools. Expecting the situation, when you are new employee who was brought into GP world with something like Microsoft Visual Studio C#, or VB.Net expertise, plus strong MS SQL Stored procedures development skills, read this article to understand your options and future steps

Read More

Conversion from Great Plains to SAP Business One

First of all we would like to mention that data conversion scope should be limited. ‘Let’s convert everything’ is generally not a good idea.

Read More

Custom Emailing for Microsoft Great Plains Dynamics GP: SQL Mail

For Microsoft Dynamics GP ERP you can deploy Business Portal and BP module – Electronic Document Delivery, however it is not available for GP Business Ready product line, where you have to go for custom solution.

Read More

How to Customize Dynamics GP Great Plains

It is absolutely great that you posed this question. Microsoft Dynamics GP custom programming projects require homework on selecting the right tool. Let’s review the most popular tools, programming methods and languages.

Read More

Exporting Data from Dynamics GP Notes for Consultant

There might be situations, where you need to extract info from Microsoft Dynamics GP (formerly known as Great Plains Dynamics or Microsoft Great Plains) table. In this small publication we will describe you two scenarios.

Read More

Microsoft Dynamics GP (former Microsoft Great Plains) implementation: modification & reporting

For Microsoft Dexterity upgrade, GP customer should have source code: DYNAMICS.DIC dictionary file with dex source code sanscript not stripped out. Microsoft Dynamics GP customizations upgrade should be reviewed by GP professional technical consultant prior to making any decision to avoid business risks. In this small article we would like to give you some GP customization and reporting highlights

Read More

Corporate ERP Selection: Microsoft Great Plains

In our opinion, traditional approach when you select ERP/MRP system for large or mid-size company by functionality, database and hardware platform should be revised. We are convinced that new generation of Windows servers plus the reliability of relatively inexpensive database platform, such as Microsoft SQL Server, enable large corporation to decrease the cost of hardware, database and ERM software, plus have good internal support by hiring Microsoft certified professionals, available on the market in your area.

Read More

Microsoft Dynamics GP Great Plains Upgrade FAQ

Currently the latest version is 10.0. It is also common situation when ERP version is not current, but, say 2, 3 or even 5 years old. There are several version upgrade strategies. One of them is to go pace-in-pace with Microsoft Great Plains and apply each newly released service pack

Read More

SQL Server Hosting Can Handle Large Databases

Essentially, SQL server hosting is utilized to host databases. An SQL server is primarily used for little to medium sized database management, although lately SQL servers are becoming more and a lot more common for huge database use.

Read More

Great Plains Reports – how to create and typical design tools

Microsoft Dynamics GP reporting is essential part of GP implementation and post production ERP support. As for typical mid-size MRP application, you should expect multiple reporting tools, especially if you think about reports genre: financial reporting, business processes specific reports, etc.

Read More

Great Plains Consultant Chicago, San Diego Newsflash: version upgrade

Microsoft Dynamics GP is new name for very popular ERP and MRP platform – Great Plains Dynamics and eEnterprise. Each accounting application lifecycle requires maintenance, and periodic version update. Current GP version is 10.0.

Read More

Validate Your Proven Experience With MCAD Certification

Software training enhances your skills and updates you with latest information about the computers and software industry. Microsoft Certified Application Developer (MCAD) certification not only helps you to gain recognition as a trained application developer but enhances your skills.

Read More

Dynamics GP AP Historical Trial Balance Recreation in Crystal Report

From time to time you can hear Microsoft Dynamics GP users complains about Report Writer reports inflexibility, especially when you are trying to export something like GL Trial Balance or AP Historical Trial Balance report. Report Writer is Great Plains Dexterity coded module and its text file inflexibility is understandable (as Dex is a shell, in turn programmed in C language).

Read More

Dynamics GP Crystal Reports Design Notes

If you have Microsoft Dynamics GP implemented in your organization as Corporate ERP platform (formerly it was also known as Great Plains Dynamics, eEnteprise and its predecessor Great Plains Accounting for DOS, Windows and Apple Macintosh), we recommend you some advises on such industry reporting tool as Crystal Reports.

Read More