I've found an interesting Discussion on CRM Experts Linkedin Group baout the search of CRM solutions for small businesses.
The debate has many responses and, apart from good advices, have come many proposals for CRM applications aimed at SMEs, so I've decided to create a list, that I hope to be useful..
Prelytis, the company recently surprised us by being the frist to adapt its Business Intelligence solution (or Dashboarding, more specifically) to Apple's iPad, also excels in the world of SaaS solutions with its proposal LifeDashBoard 4 Team, which is not is nothing but the cloud version of its software LifeDashBoard Dashboards.
It has the usual characteristics of SaaS software, and soon afte a user register and upload data from an Excel spreadsheet, for example, may have created an attractive dashboard. Collaborative options available, and also takes advantage of the features of mobile devices like the iPhone or IPAD.
But what makes this more special is that it's SaaS solution, but can be used without paying for its use, and without limitation in the number of users. A strong commitment by Prelytis, which seems to be really willing to put a dent in the world based BI innovative proposals.
Some information systems have exceeded the boundaries of the department and his knowledge has spread to all areas of the company. As the technologies are becoming easier to use and accessible for all business casuistry, his knowledge extends and extends beyond the field of "understood" by the experts, to be known by every company profiles. Concepts such as CRM, ERP, etc., Not long ago in companies known only to the department and the department involved (Marketing and Sales for CRM, ERP Operations, Human Resources for the intranet, etc.).. Concepts today are managed and understood by anyone in the business world.
As for Business Intelligence, I believe that unfortunately is still preserve of experts and technologists. Today it is very common to find a business decision makers are unclear about the functions, spheres of influence, potential and business benefits of a Business Intelligence system. The BI is still known by a few, there has been democratized, it has jumped the hurdles of technology to be part of each and every one of the departments of companies. In my opinion there are several reasons for this.
We put ourselves in position
In our environment we may need to have two replicas of a / s data base distinct environments (the classic example would be production and test). In deciding as we do the most common questions we must ask ourselves are:
- Is this new environment will be temporary? Does large data bases in terms of volume and / or load to be borne is high (even test)?
- Is there version SqlServer2008 development? That alone is at hand if you have an MSDN subscription ...
- Is there an extra server?
Based on these questions and all that it can happen one can opt for different solutions:
"The easiest and if the database to bear the burden are small we can use the same server for all databases (created on the same server with different names (_test) and Holy Easter ...). In order not to disturb each other we can use Resource Governor.
"The most" aseptic "if resources permit and where it would be worthwhile to mount on different servers (if we have the development version)
"Another option is a mixture of the above. Fit the two environments on the same server but different instances.
-Etc ...
1 server cpu n (n> 1) + 2 = 2 instances environments
MySQL, like most database managers, can easily modify the parameters that control memory sizes engaged in certain tasks, resource utilization, concurrency limits, etc.
Properly adjusting these parameters can be obtained many performance improvements, especially if the server / s of the database is not about resources, and if the SQL optimization can not be improved more.
I've recently made some basic settings in a MySQL database, so I take this opportunity to explain some of the process I followed for those who seek an easy way to make a first optimization of parameters in the database. This is not to say that this is the best way to do just that to me has worked out well;)
The first comment that can be very helpful to look in phpMyAdmin to the sections 'Show information about MySQL runtime' and 'Show MySQL system variables', normally accessible from the home page of the application.
The first displays information and statistics collected and maintained the system since its beginning. Pay special attention to the values of variables that are displayed in red, and the advice provided to the right of these values.
Please refer to the variables used to determine the current values of the parameters that could later be modified to improve performance.
Attached is a version of the plugin that addresses a number of challenges. No other changes.
Groups eGlu have been using this plugin with good results.
We have developed a transmission based on this component KPIs, really responded well.
Regards
Mariano
Have you ever wondered how to disable the autocommit option in Sql Server Management Studio?
The answer is quick. Simply uncheck the option SET IMPLICIT_TRASLATIONS. To do it follow next path from the menu:
Tools> Options> Execution of the query> SQL Server> ANSI, then Uncheck Option SET IMPLICIT_TRANSACTIONS.
It seems rather simple but is a common doubt when you start using SQL Server Management Studio. By sharing this tip I hope to save time to someone that wants to disable the autocommit option in SQL Management Studio.
[[ad]]
From Grupo eGlu, Dario Bernabeu and Mariano García Mattío, we have created a virtual machine (vmware) that contains a fully functional BI solution.
It has the following characteristics:
This demo also has the following modules:
These modules can be accessed through the taskbar side:
"The goal of Business Intelligence is to provide the information they need, when you need it and in a form appropriate to people who have to make decisions."
The aim of this paper is to support the Business Intelligence or BI should be, of all business software tools (including CRM, ERP, or BI himself), that is closest to the role of management, specifically the Executive Officer.
Since the computer revolution and the explosion of Internet, information is becoming more and more importance. Everything is or will soon be digitized, the amount of information available each year is multiplied and the activity of our business is computerized in most respects.
Studies tell us that the information maintained by companies is doubling every two years and that 80% of decisions are made with only 10% of the available information.
And all of this information is power! Is necessary, vital, to compete.
For those database administrators who have to deal with such a Dynamics Ax 2009 and his henchmen (developers, consultants, etc. 
) I leave here a couple of things you should know (or I should say) when we join ax2009 and sql server 2008. Sometimes you can point to the database as a source of the problem but not always. Some requirements to consider for installing Ax2009 are that the user you want access to the system should be user and DOMAIN in sql server role must be a member of securityadmin dbcreator and to create the new database from Ax installer. Once installed (or during the installation process) the problem with the database that we can find include:
This work is licensed under a Creative Commons Attribution-Share Alike 4.0 License.