Database Blog

  • 3 Oracle DBA Strategic Responsibilities to Outsource for Maximum Business Value

    by Robert Buda | Aug 5, 2014 | Database Architecture , Oracle DBA

    Reading Time: 2 minutes 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 increasingly massive and architecturally complex. They must support e-commerce and other critical applications that are web-based and demand continuous availability, on-demand scalability, robust security, maximum performance and mobile device support. Further, more and more of the data that drives these…..

    Read more Add new comment
  • Is Your Oracle DBA a Big Data DBA? 3 Key Skills Can Help.

    by Robert Buda | Jul 28, 2014 | Oracle DBA

    Reading Time: 2 minutes 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 attributes: It can also include a heterogeneous mix of structured and unstructured data types, and It tends to come at you hard and fast! The business…..

    Read more Add new comment
  • Financial Services Spotlight: Risk Data Aggregation and Risk Reporting

    by Robert Buda | Jul 17, 2014 | Best Practices , Oracle DBA

    Reading Time: 3 minutes 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 strategic, operational or a combination of the two. Risk data aggregation in particular has garnered considerable attention since the Basel Committee on Banking Supervision (BCBS) published Principles for effective risk data aggregation and risk…..

    Read more Add new comment
  • MySQL Fabric: The Best of NoSQL and Relational Databases

    by Robert Buda | Jul 12, 2014 | MySQL , NoSQL , Oracle DBA

    Reading Time: 2 minutes 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 applications, Oracle is positioning itself to dominate the big data landscape. Most enterprise data is still stored in relational databases written in SQL. To handle diverse data types and increase the…..

    Read more Add new comment
  • Does Big Data Make Oracle DBAs Irrelevant—or Irreplaceable?

    by Robert Buda | Jun 20, 2014 | Oracle DBA

    Reading Time: 2 minutes 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 new world order? Or do big data challenges make the Oracle DBA role more vital than ever to business operations? Personally, I think any claims that Oracle DBAs are diminishing in relevance to today’s enterprise…..

    Read more Add new comment
  • 5 Reasons—Besides Cost—to Outsource Your Oracle DBA

    by Robert Buda | Jun 12, 2014 | Oracle DBA

    Reading Time: 2 minutes 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 years. Perhaps this is because Oracle DBA outsourcing is most often treated as a cost-based, tactical decision rather than a strategic move. But with the right partner, the benefits of outsourcing your Oracle DBA can extend well beyond…..

    Read more Add new comment
  • Privileges missing after Oracle full import

    by Robert Buda | Mar 12, 2014 | Backup and Recovery

    Reading Time: 2 minutes 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.  There are multiple ways to migrate a database from one version to another. One of the oldest and easiest ways is to create your database in the target location and then use data pump (formerly Export and Import) to bring the data out of the source database and…..

    Read more Add new comment
  • Oracle In-memory Database—Speed and Simplicity Meet Up. Have you tried it out yet?

    by Robert Buda | Dec 19, 2013 | Oracle , Oracle In-memory Database

    Reading Time: 2 minutes 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 functionality. At first look, some key benefits jump out: Though this is a paid option, it promises a high ROI It takes just one change in parameter to turn it on From published information, it…..

    Read more Add new comment
  • Using the Data Dictionary to find hidden data in SQL Server

    by Robert Buda | Jul 12, 2013 | Data Dictionary , Database , SQL Server

    Reading Time: 2 minutes 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 on the schema. With hundreds of tables whose names were not obvious, he had no idea where the translation might be kept, but…..

    Read more Add new comment
  • MySQL Parser Deficiencies

    by Robert Buda | Jul 5, 2013 | Best Practices , Database , MySQL

    Reading Time: 3 minutes MySQL is a very popular database for many applications. But the parser has some important deficiencies that developers need to be aware of. The parser is inconsistent and not robust in the way that it enforces statement syntax. This may lead to ambiguity and application defects that are very difficult to find. I include one example below and link to another blog article that discusses another. Inadequate Group By Parsing The MySQL group by function…..

    Read more Add new comment