In MS SQL Server database, a PFS (Page Free Space) page has one byte for each of the pages existing in the file interval it maps. This byte contains a bit that indicates that the associated page is a mixed page. An IAM page includes a mixed page array, which is an array of eight [...]
To resolve logical damages in MS SQL Server database, an easy way followed by most database users is to execute DBCC CHECKB (with appropriate repair clause). This command after checking the logical and physical integrity of the database, repairs the database to the maximum possible level. However, if the command fails to repair, then it [...]
MS SQL Server uses indexes to quickly find the records when a query is executed. Actually the SQL Server uses the index in a similar way as you would read a book. If you want to search a particular topic, you do not have to traverse each and every page. You would just look for [...]
In this short FAQ style article we would like to introduce you – software developer, programmer, database administrator into Microsoft Great Plains Integration tools and options Microsoft Great Plains is main Microsoft Business Solutions product for US mid-market. Historically Great Plains Software designed Great Plains Dynamics and Dynamics C/S+ as multiplatform application and the integration [...]
Microsoft CRM was designed to be easily customizable. Microsoft CRM Software Development Kit (MS CRM SDK) which you can download from Microsoft website contains descriptions of the objects or classes, exposed for customization. It has sample code in C# and partially in VB.Net. In Visual Studio.Net you can analyze all the classes, used by Microsoft [...]
Microsoft Business Solutions Small Business Manager is scaled down Great Plains Dexterity based version of Microsoft Great Plains or former Great Plains Dynamics/eEnterprise. Small Business Manager first release 7.0 and all the following version was available on MSDE (MS SQL Server 2000 with limited usage and database size ? 2GB maximum). It is nice situation [...]
In our small article we’ll consider Microsoft Business Solutions Great Plains Sales Order Processing module as eCommerce backend. Plus we’ll cover what is possible and impossible in eConnect and why. Microsoft Great Plains is one of the most popular ERP in the US, Canada, Australia, New Zealand, Middle East, Latin America, UK and South Africa. [...]
Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions Great Plains was initially designed in the earlier 1990th as the extendable and modular application with its proprietary tool: Great Plains Dexterity, written in C programming language as a shell. This was popular tendency those days ?compare with SAP ABAP or Navision C/Side. Great Plains [...]
Microsoft Great Plains is main Microsoft Business Solutions accounting package for the US market. It has multiple customization/modification/reporting tools. Currently there is upgrade campaign to version 8.0 and due to the discontinuation of the technical support for Microsoft Great Plains Standard on Ctree and Pervasive SQL – we see substantial increase in migration needs: migration [...]
As you probably know, when Microsoft purchased Great Plains Software ? the whole strategy for Great Plains Dynamics/eEnterprise line was changed. Initial GPS strategy was to maintain DB platform independence ? via it’s C-written engine Dexterity, based on the believe that C programming language is platform independent. So ? Great Plains was running on MS [...]
