Discuss in the Community - Toad World

Discuss in the Community

Blogs

Clarisa Maman Orfali
Follow /6 Feb 2016 at 2:46am / Oracle

Access Control List (ACL) y JasperReports Integration Kit

Hola amigos, el otro día un amigo me comentó que tenía problemas al trabajar con el JasperReports Integration kit cuando cambiaba de Workspace. Básicamente cuando trabajaba con una aplicación en el workspace1 funcionaba...
26 0 /
Paul Turley
Follow /5 Feb 2016 at 7:51pm / SQL Server

Gartner Magic Quadrant for BI/BA and the Lone Three Leaders

History clearly confirms that good things come in threes!  As far as I know this is the first time that only the three most widely recognized Business Intelligence platforms have been placed in the top-right leaders/visionaries space of the Magic Quadrant...
35 0 /
Denny Cherry
Follow /5 Feb 2016 at 7:19pm / SQL Server

DCAC Now Has 2 VMware vExperts

I’m thrilled to report that Denny Cherry & Associates Consulting now has not 1, but 2 VMware vExperts in our ranks.  No we didn’t go off and hire another consultant.  VMware has decided that this year they will recognize both Myself (Denny...
35 0 /
sqlsanctum
Follow /5 Feb 2016 at 3:58pm / SQL Server

Get Drive Sizes using SQL or PowerShell

There are countless methods to obtain drive size information, each with its own set of benefits and limitations. I use a few different methods depending on if I have to type out the solution quickly or if I need a comprehensive view. Method 1 –...
38 0 /
Chris Webb
Follow /5 Feb 2016 at 11:48am / SQL Server

New Ways To Concatenate Text In Excel 2016 With CONCAT() And TEXTJOIN()

I don’t normally blog about Excel topics outside of Power Query and Power Pivot , but I think anyone who has ever done any serious work in Excel has found how difficult it is to concatenate more than two text values (although there are plenty of blog...
43 0 /
Gethyn Ellis
Follow /5 Feb 2016 at 10:00am / SQL Server

Its been a busy start to the year

Its been a busy start to the year at gethynellis.com. I have been involved in a Big Data training courses in Alexandria - a suberb of DC, followed by the same course running again in London a week later. This was followed by a SQL Server 2012 skills upgrade...
40 0 /
Clarisa Maman Orfali
Follow /4 Feb 2016 at 11:59pm / Oracle

Personalizar Botones con Imágenes almacenadas en nuestro Espacio de Trabajo usando CSS

Muchas veces nos encontramos en la necesidad de personalizar nuestros botones en nuestras aplicaciones en Oracle APEX, es por ello que el día de hoy te voy a enseñar cómo puedes colocar una imagen en el botón que se encuentra...
90 0 /
Kellyn PotVin
Follow /4 Feb 2016 at 6:23pm / Oracle

Importance of Network to the Cloud

I’ve been discussing for years about the importance of network to database performance, especially once I started working on VLDBs, (Very Large Databases) but its a topic that often is disregarded.  Now that I’m working more and more in the...
90 0 /
Henrik Loeser
Follow /4 Feb 2016 at 3:04pm / IBM DB2

How to Navigate Bluemix - My Starter Guide

22 0 /
Syed Jaffar Hussain
Follow /4 Feb 2016 at 10:58am / Oracle

Storage difference between 2 identical Exa boxes. How and why?

We noticed around 1.6TB storage difference between two Eight (1/8) Exadata boxes while configuring Data Guard. Wondered what went wrong. The Exa box configured for DR was around 1.6TB short compare to the other Exa box. Verified the lun, physical disk...
39 0 /
Fernando Garcia
Follow /3 Feb 2016 at 10:29pm / Oracle

La inteligencia de negocios y el Datawarehouse.

La inteligencia de negocios (BI) y un datawarehouse nos permiten convertir los datos alojados en nuestras bases transaccionales en información que nos ayudará a tomar mejores decisiones de negocio. Oracle define a un datawarehouse como...
115 0 /
Brad Wulf
Follow /3 Feb 2016 at 10:12pm / Toad for Hadoop - Blog

Toad for Hadoop – Impala SQL Editor

With the release of Toad for Hadoop 1.3.0 we’ve introduced Impala SQL on Hadoop editor support! To configure, select Window | Preferences | Ecosystems | <your ecosystem with Impala> | SQL Check the ‘Use Impala’ checkbox and enter the Impala...
14 0 /
Svetoslav Gyurov
Follow /3 Feb 2016 at 6:09pm / Oracle

Exadata onecommand fails at cell disk creation

I was installing another Exadata last month when I got an error on create cell disks step. I’ve seen the same error before when I was extending two to three rack Exadata configuration but thought it was one-off. The cell disk creation failed as...
85 0 /
James Serra
Follow /3 Feb 2016 at 4:00pm / SQL Server

Scaling Azure SQL Database

One of the advantages  Azure SQL Database has over on-prem SQL Server is the ease in which it can scale.  I’ll discuss the various options for horizontal scaling, vertical scaling, and other similar features. Horizontal scaling refers to adding...
121 0 /
Kenneth Fisher
Follow /3 Feb 2016 at 2:00pm / SQL Server

Blogger questions: What if someone else wrote about the same subject?

I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a lot of posts (twice a week for > 3 years). Over 340 of them in fact. Because of this a friend asked me what I do if I write a blog and then...
66 0 /
Michael J. Swart
Follow /3 Feb 2016 at 1:00pm / SQL Server

You’re Probably Taking Sort Order For Granted Somewhere

As many people will point out , you can’t depend on the order of results without using the ORDER BY clause. So it’s easy to say “Simple! Don’t write code that expects unsorted data to be sorted”. But it’s very difficult...
54 0 /
Denny Cherry
Follow /3 Feb 2016 at 7:00am / SQL Server

Fixing a storage pool that doesn’t have an read-write server

Recently I was working on a clients file server cluster and while doing some troubleshooting with Microsoft Support one of the clustered disks wouldn’t respond correctly.  Now this file server cluster is setup in Azure so it is using SIOS Data Keeper...
53 0 /
Abu Fazal Abbas
Follow /3 Feb 2016 at 6:55am / Oracle

Oracle 12c RAC: Clusterware logs are now centralized

When dealing with a Oracle Real Application Cluster (RAC) issue, a DBA generally needs to jump around multiple directories to find the relevant logs. Those days are now history as Oracle has centralized all the Clusterware (RAC) log files in a common...
162 1 /
Steven Feuerstein
Follow /2 Feb 2016 at 11:06pm / Oracle

PL/SQL Challenge approaches 1,000,000 answers....how should we celebrate?

Chris Saxon , the PL/SQL Challenge Database Design Quizmaster and Oracle Database Advocate for SQL and member of Ask Tom Answer Team, reminded me yesterday that the number of answers submitted on the PL/SQL Challenge is getting close to 1M. Now in the...
45 0 /
Marlon Ribunal
Follow /2 Feb 2016 at 2:30pm / SQL Server

How to Install Microsoft R Server for Windows

Microsoft R Server, or Revolution R Enterprise (RRE) as it is formally known for now, is basically a platform for advanced analytics designed to tackle big data statistics, predictive modeling, and machine-learning capabilities. The open source R is limited...
169 0 /
Derik Hammer
Follow /2 Feb 2016 at 1:00pm / SQL Server

Availability Group Architecture – Adding a Second Site

Last time, I discussed the simplest Availability Group architecture, with only a single site. In this post I will expand upon the same architecture, adding in a second site to achieve more than just high-availability. Cross sub-net availability group...
158 0 /
Porus Homi Havewala
Follow /2 Feb 2016 at 12:46pm / Oracle

Enhancements to the Oracle Multitenant option in Oracle Database 12.1.0.2 – Part XIX

In this blog post series, we are looking at noteworthy enhancements to the Oracle Multitenant option of the Oracle Database in 12.1.0.2. In the previous post, we looked at the new Attribute Clustering feature, which along with the Zone Maps feature, can...
141 0 /
ember.crooks
Follow /2 Feb 2016 at 12:00pm / IBM DB2

Preventing Log Saturation

A few days ago, I was involved in a conversation on Twitter with Ember and Erwin Hattingh, a DB2 DBA from the Netherlands whom I met at IDUG in Dublin last November. Ember expressed her surprise at how well DB2 handled a nasty situation: It's...
120 0 /
Craig Mullins
Follow /2 Feb 2016 at 12:00pm / IBM DB2

The Most Misunderstood Features of DB2 – Part 2: Optimize vs. Limited Fetch

Welcome to Part 2 in my on-going blog series on The Most Misunderstood Features of DB2. In Part 1 of the series we tackled the topic of locking, which IMHO is easily the most misunderstood feature of DB2 (probably of most DBMSes). Today's topic is...
229 0 /
Henrik Loeser
Follow /2 Feb 2016 at 8:32am / IBM DB2

Parse shutting down, move your data

33 0 /