Tips

Determining the hit ratio of Oracle databases

This script is useful for determining the hit ratio of your Oracle database. Continue Reading
Hot backup and recovery with Perl

This script is useful for DBAs who want to use Perl for doing hot backups. Continue Reading
Getting the last inserted sequence value

This function will return the last generated sequence value for a given table. Continue Reading
Five myths of data mining

Many successful companies have discovered is that the myths that have grown up around data mining are just that: myths. Continue Reading
Browsing OS files from TOAD or SQL*Plus

This tip describes the process required to browse operating system files from a PC application like TOAD or SQL*Plus. Continue Reading

Find who is executing what command using DECODE

Find who is executing what command using DECODE. Continue Reading
Joining tables in SQL queries

Discusses how to join tables in SQL Server queries. Continue Reading
Find what each Oracle process is doing

Here is a handy script that will correlate the operating system process with the Oracle process. Continue Reading
Truncate tables using PL/SQL

This tip truncates data from tables using PL/SQL for Oracle8i. Continue Reading
Growing up, and out: Opportunities expand for people willing to put time and effort into learning ne

Hot skills include knowledge of operating environments, people skills, networking smarts and Web-ifying the mainframe. Continue Reading
Duplicate Oracle installation

A procedure to install a duplicate Oracle database when typical installation via CD-ROM is not possible. Continue Reading

Script to include users in the PRODUCT_USER_PROFILE table

This script generates a script that includes users in the table PRODUCT_USER_PROFILE table. Continue Reading
Refresh value of a global variable only after commit

Refresh a value of a global variable only after a commit. Continue Reading
Small servers to have big role in data centers of the future

A panel of experts makes some predictions for the near future of data centers. Continue Reading
Problems with the DUAL table

Check the DUAL table to avoid problems with Oracle Applications. 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

How cloud services can empower the future of work

The Akumina Employee Experience Platform and Templafy show how cloud services are changing the way employees work, whether the ...

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 ...

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 ...