Discuss in the Community


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...
308 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...
200 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...
283 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...
261 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...
331 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...
519 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...
426 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...
928 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...
528 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...
506 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...
620 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...
599 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...
616 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...
497 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...
705 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...
638 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...
416 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...
506 0 /
Follow /20 Jul 2015 at 5:01pm / Toad for IBM DB2

The Easiest Way to Compare Database Objects

Need to roll out changes to your database objects? Here’s the fastest and easiest way to do it. With the object compare feature in the new DB Admin Module for Toad for IBM DB2, you can quickly compare database objects in different databases and...
997 0 /
Steven Feuerstein
Follow /20 Jul 2015 at 2:24pm / Oracle

Getting started: Sharing your Oracle Database Developer experience

Last week, I was emailing back and forth with Paul, who is a senior developer/architect at a major financial firm. He is widely respected within the company, a valued resource for many development teams. He has also garnered the respect of the PL/SQL...
539 0 /
Follow /20 Jul 2015 at 8:38am / SQL Server

SQL Server Polybase (2016)

What is SQL Server Polybase? Coming in SQL Server 2016 is the ability to query relational tables as well as data stored in Hadoop or Azure Blob storage.  This technology will allow you to continue to leverage SQL Server for your data warehousing and...
520 0 /
Deiby Gomez
Follow /20 Jul 2015 at 3:10am / Oracle

Los parámetros y su alcance

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. Los parámetros configuran el comportamiento de una base de datos y su instancia....
469 0 /
Follow /19 Jul 2015 at 5:40pm / SQL Server

HASSUG BI Developer Presentation on 7/14/2015

I presented on how to become a BI developer at the Houston Area SQL Server User Group (HASSUG).  This session resulted from feedback we received in the user group on differences between database developers and BI developers.  If you are interested in...
682 0 /
Follow /18 Jul 2015 at 11:27am / Oracle

sorting algorithm

I have to share this Picture which is really amazing and include all the sorting algorithm in one picture Cheers Osama
934 0 /
John Weathington

How to Rock Massive Requirements Gathering

Heavy Lifting Most of time, the workload on business analyst is pretty reasonable; however, sometimes a massive amount of requirements must be gathered in a short amount of time. I've helped many companies out of an audit, and it's never fun...
405 0 /