I take this blog entry to retrieve the answers to three questions I posed Edgar Cateriano to participate as an expert in one article on Knowledge Management in the journal that published CLADEA . The participation was very low end, and I think are worth sharing the thoughts that arose from these questions...
We want to give more importance to our users, and better distinguish the personal profiles of the corporate community, in order to enhance each in his way.
When someone registers Dataprix, by default you get a personal profile that has its own blog, and you can open topics in the forum, comment on any content, update status, subscribe to content or communicate with others in the comunity , among other things.
If it is a company that wants to share content more corporate types, such as press releases, product information, success stories, events, etc. us has to seek and attach to your user profile so you can now also publish such content.
The novelty is that we have split this ranking in two ..
We have changed the hitherto category 'Free Software' from Dataprix a broader call 'Technology Trends. " In this way we include also other content and views on emerging technologies, such as the 'Cloud computing' or other new or emerging, or where someone wants to talk...
Last week I attended a Web Seminar Oracle that presented the new features of Oracle Business Intelligence 11g.
The truth is that I was pleasantly surprised, because these improvements solved what I considered so far the main weaknesses of the Oracle BI Suites .
Most significant to me is the integration efforts made in the portal since it can use most of the tools of the suite, and thus reduce the feeling of working with different products. For instance, you can create operational BI Publisher reports from the same portal, and has created an integrated scorecarding tool that allows you to define KPI's, and 'react' with Agents and Actions, another pending issue of the suite. The part of administración system has also been integrated into Enterprise Manager.
Other improvements are those which have been introduced in the creation and display Dashboard, the possibility of using interactive maps, and above all the possibility of using also Answers MOLAP data sources such as Essbase cubes, which enables integration Hyperion, greatly improves the analytic reporting and enables dynamic navigation for multi-dimensional hierarchies, and other features in the reports.
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.
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.
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
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]]
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 Unported License.