Database Blog
Still Think Your Business is Too Small for Big Data?
Just because your business isn’t that big doesn’t mean you don’t have “big data” issues or a need for big data-style analytics to remain competitive. “Big data” is a relative term—relative to needs and capabilities for making business decisions, that is. Nearly every...
4 Key Use Cases for Oracle’s Multitenant Architecture
If you’re thinking of moving to Oracle Database 12c, “the first database designed for the cloud,” one of the most compelling reasons could be the Oracle Multitenant Architecture option. In this revolutionary new architecture, you can “plug” many Oracle databases into...
Get Your Oracle Databases Ready to Go Mobile
One of the big questions on the minds of more and more Oracle database users is “How do we leverage our Oracle investment to enable mobile applications?” Mobility isn’t just about using a tablet or mobile phone. It’s about providing secure, reliable and fast access to...
You Need More than a Firewall to Protect Your Oracle Databases
Unless you’ve been in suspended animation for the past few years, you know that major government agencies and global enterprises are hacked with numbing regularity despite their best efforts to defend themselves. Whether from nation states, cybercriminals or...
5 Reasons Not to Put Your Oracle Databases in the Cloud
As I blogged about recently, Database-as-a-Service (DBaaS) is an important option for many Oracle database customers. But “data in the cloud” is not right for every business, and there are important issues to be aware of as you consider how or if to leverage DBaaS....
Is Database-as-a-Service Right for Your Company?
According to recent research, Database-as-a-Service (DBaaS) is projected to grow at almost 90% year over year, to about $2 billion by 2016. The key drivers, as you might expect, are costs and time saved. From SMBs to multinationals, organizations are moving Oracle...
Compliance 101 for Oracle DBAs
Regulatory compliance issues are top-of-mind for today’s senior executives. New laws and industry regulations are changing how organizations acquire, store, manage, retain and dispose of data. Every Oracle DBA should be aware of these changes because of their sweeping...
The High Cost of Bad Data—And How To Avoid Paying It
How much is bad data costing your organization? Data is only useful if it is timely, relevant and reliable. Incorrect, redundant and incomplete data introduces risks that negatively impact business operations and skew business analytics/decision-making. Poor data...
Anatomy of a Database Security Assessment
Data security is not a “set it and forget it” condition—it’s highly dynamic, changing as your environment evolves, new threats appear and new vulnerabilities are introduced. And as the recent rash of high-profile breaches in retail databases illustrate, securing your...
Top Oracle Database Security Threats Come from the Inside
Your Oracle databases contain some of your company’s most valuable assets: financial data, customer data, intellectual property, corporate secrets and so on. That means they’ll be among the top targets of cybercriminals—both outside and inside the firewall. The fact...
Should You Outsource Oracle Database Patching and Upgrades?
Upgrades and patches are a primary cause of planned downtime for Oracle databases and the applications that rely on them. Therefore, you need to have a strategy and process for your Oracle database upgrades that minimizes business disruption but does not postpone...
3 Oracle DBA Strategic Responsibilities to Outsource for Maximum Business Value
Many organizations have limited their Oracle DBA outsourcing to tactical/operational functions like monitoring, backup and patching. But the changing technology landscape is transforming the DBA role and requiring greater expertise. Today’s enterprise data stores are...
Is Your Oracle DBA a Big Data DBA? 3 Key Skills Can Help.
Does your organization have key Oracle DBA skills that can help you to derive value from big data? And what is “big data” anyhow? Does it just relate to big (like petabyte-sized) databases? Or is there more to it? Besides being simply “big,” big data has two other key...
Financial Services Spotlight: Risk Data Aggregation and Risk Reporting
The finance, risk and compliance departments of any financial services firm all need fast and comprehensive access to business data in order to measure performance, manage risk and report to regulators and clients. But each department needs a specific view, whether...
MySQL Fabric: The Best of NoSQL and Relational Databases
Oracle Corp. is currently the world’s second-largest software vendor—and it isn’t going to let a little thing like unstructured data stand in its way. With the recent release of its MySQL Fabric technology, which is meant to meet the demands of cloud- and web-based...
Does Big Data Make Oracle DBAs Irrelevant—or Irreplaceable?
Profiting from big data means changing how your organization views data. Big data is often unstructured, and wringing value from it demands advanced analytics. Does this mean that conventional Oracle DBAs, with their relational database focus, are irrelevant in this...
5 Reasons—Besides Cost—to Outsource Your Oracle DBA
Even in this “age of outsourcing,” Oracle database administration (DBA) outsourcing is still often overlooked. Despite some predictions to the contrary the overall percentage of organizations outsourcing their DBA has remained relatively small and stable in recent...
Privileges missing after Oracle full import
While performing a migration from Oracle 10g to Oracle 11g (on new hardware) recently, we encountered a familiar frustration that I am surprised is not resolved yet. Privileges missing after Oracle full import. There are multiple ways to migrate a database from one...
Oracle In-memory Database—Speed and Simplicity Meet Up. Have you tried it out yet?
One of the major announcements Oracle made during the Open World was the launch of Oracle In Memory Database Option. The In-Memory option to Oracle Database 12c is 100 percent compatible with existing applications and leverages all existing Oracle Database...
Using the Data Dictionary to find hidden data in SQL Server
A client asked me recently how he could find a string in his SQL Server database without knowing what table or column it was in. The string was a translation of a code that appeared on one of the UI screens. This was a packaged CRM database and he had no documentation...