|
|
|
Business Needs vs. Network Performance: Critical Challenges Facing Network Managers
Networking is getting tougher. Networks must deliver a growing range of services, from ERP, CRM and email to VoIP and web services applications, each of which has its own idiosyncrasies and requirements. Each new service introduced onto the...
How Multiple Server Hosting impacts your website's uptime
Please consider the following article for your ezine, ebook or web site. It is free to use as long as you include the resource box at the end. It contains 792 words. If you use this article, please send a brief message to let me know where it...
Protecting Your Identity On The Internet
Afraid that someone is monitoring your PC or installed a keylogger to record every single keystroke? Find out which tools you need to get to make sure you are protected. X-Cleaner Deluxe http://www.deprice.com/xcleanerdeluxe.htm X-Cleaner is a...
Secure Your Data - Windows Data Backup Computer Software
In nowadays computers have entered almost every imaginable domain in our lives - from our homes to space shuttles. As they hold more and more precious data - in material or merely sentimental way - securing that data is not only option, but a must....
TeoSoft CleanSpace 9 Software
Computer progress has given us many new opportunities. Today we
can do everything what we want by using a computer. People can
make purchases, study, listen to the music or news, watch TV or
movies by only one mouse click. All this we can use due...
|
|
| |
|
|
|
|
|
|
SQL Administrator Skills Required To Support Microsoft Great Plains
Microsoft Great Plains is becoming more and more popular and we see new purchases among midsize and large corporations, where, in our opinion, Microsoft SQL Server DB administrator position is a must. If you are database administrator and you are part of the decision making team, purchasing Microsoft Business Solutions Great Plains for your corporation, we would like to set your expectation on the level of SQL knowledge, skills and experience needed to support Microsoft Great Plains in-house
Data querying. Microsoft Great Plains has decent ReportWriter, which allows users to create and modify existing reports, however the recommended tool, and you will soon understand that if you need really challenging reports (Sales Commissions, Bill of Lading, Sales Order Status with Purchasing info, Regional Sales, etc.) you need to deploy Crystal Reports or Crystal Enterprise. Crystal Report itself is usually based on the view or stored procedure. So you should expect to be familiar with Great Plains tables architecture and be capable to create select statement with multiple joins and unions
Data Repair. You should be ready to save GP table prior to data repair: select * into SOP10100_Copy from SOP10100 and then use update statement to fix incorrect values. If you need to load SOP10100 back from the backup table first drop DEX_ROW_ID column and then use: insert into SOP10100 select * from SOP10100_Copy.
Backup and Restore. Great Plains has DYNAMICS database which stores system info, such as users, security, companies, etc. and each company has its own database. You should be able to restore mostly company databases from the backup. This seems to be trivial routine.
Technical Support. When you have issues with posting or need help from Microsoft Business Solutions Technical Support, you place case through customer source and you should expect the technician provide you with SQL scripts to fix your data.
Some Useful Scripts. You need to be able to delete locked user: delete activity where userid=TOM, also very popular
is batch recovery script, you need to unlock the batch in SY00500 table: Posting Definition Master
Do not expect. Replications (except probably snapshot) it adds GUID column and then Great Plains Dexterity runtime can not upgrade the modified tables. Referential Integrity is not used, Varchar or NVarchar are not used the reason is Dexterity architecture, which was initially designed with database independence in mind. Logins and access management Great Plains uses its own security, which is translated into SQL logins with encrypted password.
Moving Great Plains on the new SQL Server. It is often confusing for the DB Admin. Besides physical move through backups or detach/attach DB you need special scripts to transfer GP security and users logins, these scripts are available through MBS tech support or feel free to call you MBS partner.
Advanced Techniques. If you need to notify your GP users on the specific event in GP such as invoice was paid, you can deploy SQL emailing: xp_send_mail. This procedure could be called in the trigger for the apply payments table.
Data Integration. XML inbound and outbound streams for the integration stored procedures is becoming defacto standard. Also you should be familiar with heterogeneous SQL queries: OPENROWSET and linked server conceptions.
Happy implementing! You can always appeal to us to help you with your system. Give as a call 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com
About the Author: Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ( http://www.albaspectrum.com ), Microsoft Business Solutions Great Plains, Microsoft CRM, Navision, Microsoft RMS, Microsoft Business Portal customization company, serving clients in Chicago, Boston, New York, Miami, Atlanta, Houston, Dallas, Denver, Los Angeles.
Source: www.isnare.com
|
|
|
|
|
| Data Recovery Software and Undelete from R-TT |
| Disk management software including utilities for data recovery, drive imaging, disk wiping and access control. |
| www.r-tt.com |
|
| Data Recovery | Email Data Recovery by Ontrack |
| Data recovery services, data recovery software, file repair software, and diagnostic software from Ontrack. Software for email recovery, file recovery and ... |
| www.ontrack.com |
|
| Data Recovery by DriveSavers | Hard Drive Data Recovery |
| Worldwide data recovery service for all operating systems and storage media. Authorized by all drive manufacturers. |
| www.drivesavers.com |
|
| Hard Drive Data Recovery Software Tools, Disk Recovery Utilities ... |
| Offers data recovery software,data recovery services for hard drive recovery and data safety software services for your computer. Buy award winning data ... |
| www.stellarinfo.com |
|
| Data Recovery by FADV Hard Drive, RAID, Tape, Database and more ... |
| Offers data recovery services for all hard drive models. RAID, MS SQL, Exchange, Tapes, Camera and USB media, CD and DVD. Service available 24/7. |
| www.datarecovery.net |
|
| Data Recovery Software - File System Utilities |
| Data recovery software for all Windows file systems. Recover deleted files, corrupted hard drives, and partitions. |
| www.runtime.org |
|
| Professional Data Recovery Software from Bitmart. File Recovery ... |
| Data Recovery Software Restorer2000. Undelete & File Recovery utility for FAT and NTFS file systems. Data Recovery from damaged disks and partitions. |
| www.bitmart.net |
|
| Data Recovery Services - ActionFront - Critical Server Data Recovery |
| ISO certified data recovery services with labs in Atlanta, Santa Clara, Dallas, Chicago, Toronto (also Buffalo and Tokyo Japan) |
| www.actionfront.com |
|
| Hard Drive Data Recovery Software: Recover Deleted Files- Recover ... |
| Data recovery software for recovering files that have been deleted or lost due to the hard drive format, virus infection, unexpected system shutdown or ... |
| www.recovermyfiles.com |
|
| Data Recovery Group - Hard Drive Data Recovery Services |
| Data Recovery is Our Only Business! Data Recovery Group's a complete data recovery service that specializes in recovering data from hard disk drives. |
| www.datarecoverygroup.com |
|
| Data Recovery by CBL: Hard Drive Recovery Services |
| Worldwide Data Recovery Services at CBL. Specializing in data recovery, hard drive recovery, hard disk drive recovery and RAID data recovery. |
| www.cbltech.com |
|
| Data Recovery Software, File Repair Utilities, Hard Disk Recovery ... |
| Hard drive data recovery software to perform data recovery & recover deleted files from Novell, Linux, Unix, Mac, Windows & data recovery services for hard ... |
| www.nucleustechnologies.com |
|
| AT&DR: Data Recovery and Liabillity |
| Associated Technologies offers complete data recovery solutions with services for any type of data storage device, including the following: hard drives, ... |
| www.datarecovery.com |
|
| Ontrack UK - Data recovery services & recovery software - hard ... |
| Ontrack offers data recovery services & software for: hard drive recovery, file recovery, server recovery, email recovery, tape recovery, RAID recovery. |
| www.ontrack.co.uk |
|
| Beginners Guides: Hard Drive Data Recovery - PCSTATS.com |
| Beginners Guides: Hard Drive Data Recovery - PCSTATS.com. |
| www.pcstats.com |
|
| File Recovery and Data Recovery Software. Hard Drive recovery utility |
| Data recovery software for FAT, NTFS, Ext2FS file systems. File recovery after FDISK, MBR destruction, FAT damaged, virus infection. Dynamic disk support. |
| www.data-recovery-software.net |
|
| Data recovery - Wikipedia, the free encyclopedia |
| Data recovery is the process of salvaging data from damaged, failed, ... Although there is some confusion as to the term, data recovery can also be the ... |
| en.wikipedia.org |
|
| Active@ UNDELETE Data Recovery. Recover Deleted Files. Windows XP ... |
| Active@ UNDELETE - Data Recovery Software for all Windows File Systems. Recover deleted files from lost, damaged, formatted or reformatted partitions. |
| www.active-undelete.com |
|
| New Zealand Data Recovery & Computer Forensics Experts |
| New Zealand data recovery specialists & computer forensics investigation experts. Recovering lost data for businesses or legal evidence is all we do. |
| www.datarecovery.co.nz |
|
| Canada Data Recovery Services: Hard Disk Drive Recovery, Raid Data ... |
| Provides data recovery solutions for companies experiencing data loss from failed hard drives, raid arrays, and server systems. |
| www.datarecovery.ca |
|
|