|
|
|
Data-Recovery: What You Need
Data recovery is something we hope that we will never need. Whether you simply make the mistake of deleting important software or you lose it all in a computer crash, that valuable asset of information may seem like it is lost forever. But, if you...
Hard Drive Crash? Avoid Making A Bad Situation Worse
If you experience a hard drive crash, it doesn't take much to
make a bad situation even worse. In the event of a hard drive
crash, in most instances, the data is completely recoverable at
first. However, as part of human nature, we often try to...
Paragon Drive Copy 8.0
Complete and reliable but at the same time easy-in-use solution
for migrating your home and corporate data and applications
online
December, 2005- Paragon Software Group, the European specialist
for innovative data security and data...
Secure offsite backup services and software, online file backup and storage, remote online backup
Although you may not list it in on your IRS form, information is
your business' primary asset. From your customer database to
your financial records to your proprietary product information,
information is the key element to maintaining both...
Top 5 Backup Tools You Can Pick Up For Pennies
1. Acronis True Image 8.0 - 25% Off Special www.deprice.com/acronistrueimage.htm Based on the exclusive Acronis Drive Snapshot disk imaging technology, Acronis True Image allows you to create an online system disk backup without reboot to keep the...
|
|
| |
|
|
|
|
Schreiber, Johansson Build A 'Bridge' To A Classic
Liev Schreiber and Scarlett Johansson are starring in a widely praised revival of Arthur Miller's <em>A View From The Bridge</em>. They tell reporter Jeff Lunden that as in all great tragedies, this one's clashes and catastrophes have something of the inevitable about them.
Stargazing At The Opera
The Hayden Planetarium in New York takes opera to the moon with a new production of <em>Il Mondo Della Luna.</em> Diane Paulus and Philip Bussmann talk about merging cosmos footage with music, how science can enhance the arts and the future of technology and theater.
Obama 'The Musical' Opens In Germany
A new theater production <em>Hope: The Obama Musical Story</em> opened this week in Frankfurt, Germany. It tells the story, in song and dance, of America's first black president. It is likely to be a big success in a country where President Obama is still immensely popular.
|
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
Amazon Expands Streaming With Viacom Deal
Amazon announced Wednesday that it will expand the selection on its streaming service through a new deal with Viacom. Included in the deal are Paramount movies, as well as shows from Comedy Central, Nickelodeon, MTV and more. This deal isn't exclusive, in that much of the material is on other streaming services already such as Hulu and Netflix.
How to Avoid Everyday Sales Mistakes
Avoiding Every Day Sales Goofs A client of mine once said to me, Its better to do the right thing badly than the wrong thing very well. So it goes in sales. Try to do the right things, even if not very well, even if it hurts.
...
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
|
|
|
|
|
|