Discuss in the Community


Follow /30 Jul 2015 at 12:09am / Oracle

Presentation will be

There is no much left for 2015 but there is too much work waiting me, presenting in different country means a lot of work and preparation, i am still waiting different events but till now this is confirmed:- SIOUG2015 HROUG2015 OOW15 UKOUG TECH15 So Excited...
88 0 /
Follow /30 Jul 2015 at 12:06am / Oracle

Database Certified with EBS 12.2

After Waiting too long finally I can upgrade my Oracle EBS Database ,Regarding to Oracle Blog "Database Certified with EBS 12.2". You can Read more about this here Cheers Osama
74 0 /
Dan Hotka
Follow /29 Jul 2015 at 4:57pm / Oracle

SQL Tuning- lessons learned from a lifetime in Explain Plans (part 7)

Hi! I have been discussing how I would find and tune problem SQL. Datatype mismatch has always been a problem for the optimizer. Oracle only compares like data types (more importantly, the same data types). So, if you are comparing a number...
112 0 /
Deiby Gomez
Follow /29 Jul 2015 at 3:30pm / Oracle

OTN Tour - Guatemala

Note: This article was written originally in Spanish. If you are reading this article in other language it is because of the automatic translator of ToadWorld. OTN TOUR 2012 Tuve la oportunidad de participar en el primer OTN Tour que se realizó...
197 0 /
Deiby Gomez
Follow /29 Jul 2015 at 8:26am / Oracle

Oracle y la función APPROX_COUNT_DISTINCT

Note: This article was written originally in Spanish. If you are reading this article in other language it is because of the automatic translator of ToadWorld. Como parte de las nuevas características con las que cuenta Oracle, tenemos...
179 0 /
Follow /28 Jul 2015 at 10:55pm / NoSQL

9 Elements of the Modern Data Center

Data centers are becoming increasingly important in today’s modern world. They hold and disseminate information to people when they need it. Because these data centers are crucial to how we run our lives and businesses it is important to understand...
375 0 /
David Fitzjarrell
Follow /28 Jul 2015 at 10:36pm / Oracle

It Isn’t The Index

"If you want sense, you'll have to make it yourself." - Norton Juster, The Phantom Tollbooth One of the more confusing statistics in Oracle is, apparently, one called the clustering factor. Associated with an index (as evidenced by...
253 0 /
Lenka Vanek
Follow /28 Jul 2015 at 9:45pm / Toad for Hadoop - Blog

Apache Sqoop Direct Mode – Optimized Data Transfer

Many Hadoop analytic tasks are dependent on data traditionally maintained primarily in a relational database such as Oracle. For instance, an analysis of web logs might need to access the CUSTOMER table in Oracle to obtain the customer’s geographic...
387 0 /
Natik Ameen
Follow /28 Jul 2015 at 4:55pm / Oracle

Database Rankings July 2015

Here is an interesting Database rankings survey on the db-engines site, which measures the general interest in the different databases, based on the criteria below. This provides some insight into the trend in the adoption of these databases. Database...
37 0 /
Jen McCown
Follow /28 Jul 2015 at 3:00pm / SQL Server

Precon this week! The Enterprise Scripting Workshop #SQLSaturdayBR

You are cordially invited to a fantastic precon event before SQL Saturday Baton Rouge! The Enterprise Scripting Workshop is on Friday, July 31, and if you register before June 30 you’ll get the Early Bird rate of $99…it’s $125 to attend...
326 0 /
Follow /28 Jul 2015 at 12:00pm / SQL Server

SQL Server Audit: Getting Started

SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature.  Audited events can be written to the server application or security logs, or to a file where you specify the location (the most secure route...
381 0 /
Craig Mullins
Follow /28 Jul 2015 at 12:35am / IBM DB2

DB2 Compression: z/OS versus LUW

Data compression for non-mainframe DB2 is quite a bit different than it is for DB2 for z/OS. In mainframe DB2, specifying COMPRESS YES on the CREATE TABLESPACE statement will cause DB2 to implement Ziv-Lempel compression ( http://www.data-compression...
645 0 /
Follow /27 Jul 2015 at 7:46pm / NoSQL

Fears Over the Cloud are On the Decline

Cloud computing, or “the cloud” as it’s commonly referred to, is “the collection of data and use of related computing services via remote servers accessed through the internet.” Hundreds of cloud companies exist today to...
642 0 /
Brad Wulf
Follow /24 Jul 2015 at 5:21pm / Toad for Hadoop - Blog

Toad for Hadoop and Hortonworks - Like ordering off of the secret menu at In 'n Out Burger.

As a Hadoop user, it’s clear that you are an early adopter of technologies, and not afraid to roll up your sleeves and dig into a technology. In that spirit, we’ve recently heard from quite a few folks that are using Toad for Hadoop to connect...
1277 0 /
Sten Vesterli
Follow /24 Jul 2015 at 1:33pm / Oracle

First APEX 5.0 Patch

The most enthusiastic APEX developers jumped straight at APEX 5.0.0 as soon as it was released. This was a major, major change to APEX and a few kinks were to be expected. Oracle has already released APEX 5.0.1, fixing no less than 185 bugs . Given...
621 0 /
Fernando Garcia
Follow /23 Jul 2015 at 11:57pm / Oracle

Oracle y las arquitecturas de alta disponibilidad

Bajo el nombre “Oracle Maximum Availability Architecture (Oracle MAA)” Oracle define cuatro arquitecturas de alta disponibilidad que se ajustan a las necesidades de empresas e instituciones de distintos tamaños y líneas de negocio...
525 0 /
Porus Homi Havewala
Follow /23 Jul 2015 at 7:52am / Oracle

Enhancements to the Oracle Multitenant option in Oracle Database – Part XIV

In this blog post series, we are looking at noteworthy enhancements to the Oracle Multitenant option of the Oracle Database in In the previous post, we looked at Flashback Data Archive (FDA) which can now be enabled in 12c container databases...
630 0 /
Natik Ameen
Follow /22 Jul 2015 at 9:21pm / Oracle

BIWA Summit 2016 – Call for Speakers Open

BIWA Summit - The Big Data + Analytics User Conference. The call for Presentation Abstracts is now open. Submit yours today. The post BIWA Summit 2016 – Call for Speakers Open appeared first on VitalSoftTech .
19 0 /
Denny Cherry
Follow /22 Jul 2015 at 7:00pm / SQL Server

Updating All Jobs To Check For AG Primary Replica

One of the really annoying things about moving existing SQL Server databases into an Availability Group is setting up the jobs to work within the confines of the AlwaysOn Availability Group. This is because you have to manually create the jobs on each...
616 0 /
Dan Hotka
Follow /22 Jul 2015 at 4:55pm / Oracle

SQL Tuning- lessons learned from a lifetime in Explain Plans (part 6)

Hi! We have been discussing explain plan cardinality, the rows being returned by each line of the explain plan and the importance of these numbers, the useful and performance-related relationship these numbers have, and how Oracle11 is using actual...
625 0 /
Craig Mullins
Follow /21 Jul 2015 at 8:42pm / IBM DB2

Influencing the DB2 Optimizer: Part 4 - OPTIMIZE FOR n ROWS

In the first installments of this series of posts on ways to influence the DB2 optimizer we looked at standard methods like RUNSTATS and SQL tweaking techniques. Today, we will look at yet a nother method of influencing access path selection: specifying...
507 0 /
Follow /21 Jul 2015 at 7:49pm / SQL Server

SQL Server – New Database Backup Encryption with SQL Server 2014

With the release of Microsoft SQL Server 2014, we have the first version of SQL Server that supports encrypting database backups directly from the database engine without any third party software being installed on the SQL Server. Preparing the Instance...
713 0 /
Steven Feuerstein
Follow /21 Jul 2015 at 6:42pm / Oracle

PL/SQL Brain Teaser: how many ways can you define a cursor in PL/SQL?

According to the PL/SQL User Guide , A cursor is a pointer to a private SQL area that stores information about processing a specific SELECT or DML statement. So how many ways can you define a cursor in PL/SQL? Let's include in this ways in which you...
645 0 /
Ed Elliott
Follow /21 Jul 2015 at 7:38am / SQL Server

Keep your environments in-sync and your upgrade scripts fresh

Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are a few things that we should bear in mind to ensure we do not break existing databases. Why is it important? When you upgrade an application...
426 0 /
Denny Cherry
Follow /20 Jul 2015 at 7:00pm / SQL Server

If You Thought Database Restores Were Slow, Try Restoring From an EMC Data Domain

Recently I did something which I haven’t had to do for a VERY long time, restore a database off of an EMC Data Domain. Thankfully I wasn’t restoring a failed production system, I was restoring to a replacement production system, so I was getting...
516 0 /