Ask the Experts

SQL string functions

SQL expert Rudy Limeback explains how to use string functions. Continue Reading
What's the best tape backup strategy for 10g RAC?

An Oracle user asks for the best tape backup strategy to use to backup the database and nodes for an RAC system. Continue Reading
How does an INSERT/UPDATE statement behave when executed compared to a SELECT statement?

An Oracle user asks expert Brian Peasland: How does an INSERT/UPDATE statement behave when executed compared to a SELECT statement? Continue Reading
Can I resize the SYSTEM tablespace?

An Oracle user asks if they can resize the SYSTEM tablespace. Continue Reading
Can I add multiple datafiles and make use of all the temporary datafiles at the same time?

An Oracle user asks: Can I add multiple datafiles and make use of all the temporary datafiles at the same time? Continue Reading

Why am I getting an Oracle error when issuing the RECOVER DATABASE command?

An Oracle user asks why they are getting an error when issuing the RECOVER DATABASE command. Continue Reading
Checkpoint vs. commit process

An Oracle user asks if there is a relationship between CKPT and commit in Oracle. Continue Reading
How to use the OPatch Utility in Oracle

Expert Brian Peasland explains how to use the OPatch Utility to find the CPU patch level applied to the particular database. Continue Reading
The USING BACKUP CONTROLFILE clause in Oracle commands

An Oracle user asks how a command with the USING BACKUP CONTROLFILE clause works. Continue Reading
Backup and recoveries of Oracle RAC 10gR2

An Oracle user asks expert Brian Peasland a few questions about taking a backup and recovery for RAC 10gR2. Continue Reading
Backup and recovery of Oracle 10g with forgotten admin password

An Oracle user asks how to take backup and recovery of Oracle 10g after forgetting the admin password. Continue Reading

How to recover a control file

An Oracle user asks how to recover their control file in the case of media failure. Continue Reading
Oracle DBA interview questions

A SearchOracle.com user asks what questions they can expect in an interview for the position of a DBA. Continue Reading
SQL for hourly totals for the last 48 hours

SQL expert Rudy Limeback explains to an Oracle user how to user asks how to generate datetimes or use left outer join to get hourly totals for the last 48 hours in SQL. Continue Reading
Normalizing a crosstab table

SQL expert Rudy Limeback explains how to use a UNION query to normalize a crosstab table. Continue Reading

Google takes a run at enterprise cloud data management

New Google Cloud boss Thomas Kurian is putting databases and data management at the forefront at Google. The vendor has forged ...

4 factors to consider in a Hadoop distributions comparison

Examine the key characteristics necessary to evaluate in a Hadoop distribution comparison, focusing on enterprise features, ...

Kafka at center of new event processing infrastructure

Events are as important as data in emerging applications underlying many e-commerce efforts. Streams of events tell a company ...

SearchBusinessAnalytics

How to integrate Power BI and SharePoint via embedded reports

Expert Brien Posey explains two methods for including Power BI reports on pages in SharePoint Online's cloud service: publishing ...

Data-rich organizations turn focus to ethical data mining

As data analytics have increasingly become a core component of organizations' strategies, concerns have arisen around how data is...

Cloud AutoML, BigQuery ML upgrades expand Google stake in ML

Google introduced a raft of updates to its cloud-based machine learning and AI products, including expanded capabilities for its ...

SearchSAP

SAP partner program promises to focus on customer happiness

SAP's partner program shifts from sales emphasis to customer happiness; to lead the efforts, SAP named Karl Fahrbach as the ...

Overview of SAP HANA features and how it's being used today

There has been a lot of hype around SAP HANA since it became available nearly a decade ago, but what is it exactly and what role ...

SAP executive board shuffle raises questions about its strategic direction

Some analysts believe SAP's recent executive changes mean the new leaders must prove their development credibility as the company...

SearchSQLServer

Pros and cons of using SQL Server audit triggers for DBAs

Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But ...

How to resolve and avoid deadlocks in SQL Server databases

Deadlocks are a real hindrance to SQL Server users, but database administrators can avoid them by taking steps to limit them and ...

SQL Server auditing best practices: 3 key questions for DBAs

Acing a SQL Server database audit starts with careful monitoring of how sensitive data is accessed and used so you can answer the...

TheServerSide.com

Red Hat replaces Oracle as OpenJDK 8, OpenJDK 11 steward

Red Hat has taken control of two popular versions of the open source Java implementation, so developers can continue to build ...

JavaScript popularity drives TypeScript adoption among devs

More developers choose to work with JavaScript to build web, server-side and mobile applications, while TypeScript has quickly ...

Encrypted computing approaches practical app development

A new technology could make it easier to write apps that don't have to decrypt data and, therefore, improve security without a ...

SearchDataCenter

Build a comprehensive outline for your data center budget

Including all necessary data center expenses during budget planning can be daunting. IT managers can start with costs for ...

Open source virtualization expands VM hardware and OS options

Dive into open source virtualization software with VirtualBox, KVM or QEMU. Each offers customizable VM management capabilities ...

4 considerations for choosing a private cloud provider

Key features to look for from a private cloud provider include interoperability, scalability and how familiar admins are with the...

SearchContentManagement

Business objects are the future of content services platforms

The focus of enterprise content management must shift from a CSP-based approach to a business object services model in order to ...

5 unusual ways to use AI in content management

AI offers great opportunity for enhancing enterprise content management. Here are some more unusual use cases for AI that ...

Use data to create personalized content customers actually want

As customers demand authentic, personalized content, CX teams have turned to personalization engines. But without the right data,...

SearchHRSoftware

Diversity in hiring a key to eradicating AI bias

HR is turning to AI systems to help rank and sort job candidates. But the systems like these are mostly designed by men, who may ...

Technology can aid diversity and inclusion in HCM, with caveats

Vendors are increasingly building AI applications to be bias-free to address concerns around diversity and inclusion. The ...

As baby boomers exit, AR and VR tools help to capture their expertise

Demand for virtual and augmented reality tools is soaring, and the need to capture expertise from retiring baby boomers may be ...