Wednesday, 14 September 2016

Wednesday, 24 August 2016

8 Ways to Use Abacasys Remote DBA Services



24x7 Coverage
Get around the clock coverage & support needed to ensure serious issues are addressed efficiently & appropriately. Either you need off-hours coverage or support during vacation days, holidays and sick days, Abacasys is there. You will not worry about DBA absences, nights or weekends affecting your performance.
Full DBA Support
Abacasys Meet 100% of your database administration needs. We become your team & expect complete duty regarding the usefulness, security, execution, accessibility and change of your database surroundings. You get the expertise, availability and best practices of over 100 DBA experts for less than a single, in-house resource.

Supplemental DBA Support
Build up your existing team & produce high-level support when & how you need it. We help you fill gaps in skill sets, refine team productivity & handle increasing workloads without a headache or cost of hiring additional in-house resources. Enlarge the capacity and power of your team with the help of Abacasys.
Proactive Monitoring
Secure real-time monitoring & ready warnings for your mission critical situation.  Our Database Operations Center (DOC) is staffed with master experts committed to ensuring the availability & performance of your environment. We will tell you quickly when basic occasions or issues happen. Proactive monitoring is standard with DBA support or available on its own.
Off-Hours Support
 Leverage high level, off-hours support for your database environment. Abacasys help you meet 24x7 business demands, improve team productivity & produce complete of your environment without offshoring or burning out your DBAs. Give your team time to relax by letting Abacasys work late shifts.

 Auditing and Protection
Secure your most important & sensitive data from external threats & malicious insiders by being alerted to attacks in real time & closing sessions that break predefined security policies.

Multi-Platform Support
Get high-level support and expertise for different platforms. Since most DBAs are only well-versed in one database technology, those working with many platforms are particularly vulnerable to mistakes. Abacasys helps you ensure that all platforms are handled expertly.          
                                                                                                        
Database Optimization
Optimize the security, performance & availability of your database environment. Poorly performing, unorganized environments affect your ability to meet business requests and keep availability. Abacasys helps you clean up and optimize your work space so you can meet growing business needs and influence all database elements & functionality & efficiently.

Sunday, 7 August 2016

How to get back deleted or updated records from a table?

It’s a normal day as always when I receive a call from one of my clients in panic, he deleted computer data of his last month of work had been erased by mistake. He had tried everything he knows but failed to recover his data. As a last option, he called me to know if I had one last idea : How to get back deleted or updated records from the table?

My method was simple:
Step 1. Get the new version of DB-Forensics, able to get back your data.
Step 2. Enjoy your success and export it on an excel file or in another database.

Wednesday, 27 July 2016

Display Checkmarks for Yes values in APEX report.


Working with Apex report, I have a table with an "active" flag column that generally stores values in either Y or N.In an Apex report, its better if it displays as green checkmark for Y & X for N, instead of displaying the literal letter. So here it is I am gonna show you how you can implement all this. I wrote few couple of custom classes utilizing the Font Awesome icon library.

I implement these two CSS classes into my global CSS file:

.check-Y:before {
 content: "\f00c";
 color: green;
}
.check-N:before {
 content: "\f00d";
 color: red;
}

The values for the content attributes can be gotten from the Font Awesome cheatsheet (ignore the &#X characters).


 You can see in image shown below. I added the following HTML expression in my APEX report ACTIVE coloumn:



When the report executes, the HTML expression will return either check-Y or check-N, thus referencing the classes with the green check mark or the red X.


Create Apex based Application for your Business from Abacasys.
Send service related queries @ info@abacasys.com or Call us @ +1-678-666-0125

Thursday, 21 July 2016

Oracle releases its Biggest-ever Security update: Around 159 flaws removed



Oracle released its largest- ever set of security patches, mentioning much critical vulnerability in software & hardware products that can be exploited remotely & main part without credentials. Beating the previous record of 248 in January, this year in July 2016 oracle latest patch update resolves 276 security fixes.

In July update Company’s insecure Java framework receives fixes for 13 issues, 9 of which are exploitable remotely. Sun systems product suite & Oracle’s Fusion Middleware receive the most of the patches, with 39 & 34 each respectively.
Enterprise business applications such as JD Edwards, E-Business Suite, Siebel CRM & others are in the list those got the patch.

MySQL database gets 22 security updates & 9 fixes are available for the flagship Oracle Database.Among all critical vulnerabilities, five are evaluated as having high regular vulnerabilities scoring score of 9.8. 

Company said that they received reports that attackers had succeeded in hacking Oracle customers who failed to apply patches that are available & strongly recommended the updates the applied immediately.

"Oracle systems are complex and multi-component, not speaking about numerous customizations every company usually has," said by ERPScan.

For regural updates visit our Blog & for services Visit Abacasys