Tag: Sql Queries
Corporate Accounting System: Microsoft Great Plains ? Overview
Posted on Jul.19, 2009, under Computer and PC Tips No Comments
Corporate ERP/MRP selection might be tough one, especially considering very turbulent ERP world and fierce competition between Microsoft Business Solutions (Great Plains, Navision, Axapta, MS CRM), Oracle (Oracle Financials, PeopleSoft, JD Edwards), IBM (including Lotus Domino), SAP, Microsiga (Brazil, Portugal). We recommend you, IT director of large corporation, make your home work and decide on Microsoft or Java/EJB/J2EE platform (however you should consider vendor dependence minimization, and stake on both with XML streams integration between the two). In this small [...]
Perfectly New Database Query Tool – Foxy SQL Pro Released
Posted on Jul.09, 2009, under Computer and PC Tips No Comments
Are you a database professional? Do you work with a lot of databases? Do you use an SQL code? Do you want to connect to a new database to physically create its structure in no time and with ease? Are you tired of having to handle several client applications?
If your answer is "yes" to any of these questions, I recommend you to go on reading this article.
Let’s imagine you work with let’s say three databases. Whenever you feel the need [...]
Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights
Posted on Jun.26, 2009, under Computer and PC Tips No Comments
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise was introduced in 1993 as first Microsoft Windows and Macintosh based graphical accounting/ERP application for Mid-Size businesses. Considering the history of furniture retailer and custom assembly lines ? they showed up on the market about five decades ago and they have automated their business operations with Unix-based businesses in the late 1960th and earlier 1970th. You can find such furniture resale systems as Storis, which is Unidata based application, automating [...]
IT Department Skills to Support Microsoft Great Plains and Microsoft CRM
Posted on Jun.22, 2009, under Computer and PC Tips No Comments
Microsoft Great Plains as ERP and Microsoft CRM as Client Relation Management system is very robust combination and could serve midsize to large corporation as Business System. Being VP IT or IT Director you need to foresee the positions to have in your IT department to do internal MS Great Plains and MS CRM support. Let us give you the directions, based on our research and consulting practice. Microsoft SQL Server Specialist ? we specially do not name this position [...]
Microsoft Great Plains Data Conversion ? Overview For Developer
Posted on Jun.12, 2009, under Computer and PC Tips No Comments
Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.
If you are developer who [...]
Corporate ERP Selection: Microsoft Great Plains
Posted on Jun.10, 2009, under Computer and PC Tips No Comments
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. In this small article [...]
40/sec to 500/sec
Posted on Jun.01, 2009, under Computer and PC Tips No Comments
Introduction
Surprised, by the title? well, this is a tour of how we cracked the scalability jinx from handling a meagre 40 records per second to 500 records per second. Beware, most of the problems we faced were straight forward, so experienced people might find this superfluous. Contents
* 1.0 Where were we?
1.1 Memory hits the sky 1.2 Low processing rate 1.3 Data loss 1.4 Mysql pulls us down 1.5 Slow Web Client
* 2.0 Road to Nirvana
2.1 Controlling memory! 2.2 [...]
Selecting Corporate ERP: Microsoft Business Solutions Great Plains ? Estimation Parameters
Posted on May.17, 2009, under Computer and PC Tips No Comments
As we could imagine, if you are reading this article ? you are in the decision making mode, probably replacing legacy system with the new one or abandoning either Unix/Mainframe or Apple direction for your corporation. In any case, nobody should make an outside influence on your decision ? you should be maximally objective. Let us give you our estimates and the parameters to check on the pool of the possible ERPs/MRPs.
? Lifecycle. Each application has its lifecycle: from inception [...]
Great Plains Customization ? Programming Auto-apply in Accounts Receivable
Posted on May.14, 2009, under Computer and PC Tips No Comments
Microsoft Great Plains is one of three Microsoft Business Solutions mid-market ERP products: Great Plains, Solomon, Navision. Considering that Great Plains is now very good candidate for integration with POS application, such as Microsoft Retail Management System or RMS and Client Relation Systems, such as Microsoft CRM ? there is common need in Great Plains customizations and integrations, especially on the level of MS SQL Server transact SQL queries and stored procedures.
In this small article we’ll show you how to [...]
