Expert Blogs - Toad World

Expert Blogs

Blogs

Iggy Fernandez
Follow /29 Apr 2016 at 2:00pm / Oracle

Why Brian Hitchcock and I (probably) know more about Oracle Database than you‏

Click on the picture to download the latest issue of the NoCOUG Journal Brian Hitchcock’s secret is simple. For twelve years, he has been reading books on Oracle Database. And taking extensive notes. And publishing them in the NoCOUG Journal...
257 0 /
Fernando Garcia
Follow /29 Apr 2016 at 12:47am / Oracle

Expresiones Regulares en Oracle (. + ? *)

Hoy nos metemos de lleno con ejemplos de uso de expresiones regulares en Oracle. Veamos la primera lista de metacaracteres: Punto (.) Suma (+) Asterisco (*) Interrogación (?) Hace algunos días he publicado una breve...
84 0 /
Thomas LaRock
Follow /28 Apr 2016 at 7:13pm / SQL Server

The Server Draft

If you were given the chance to build the ultimate server, what would you draft first? The post The Server Draft appeared first on Thomas LaRock . If you liked this post then consider subscribing to the IS [NOT] NULL newsletter: http://thomaslarock.com...
89 0 /
Brendan Tierney
Follow /28 Apr 2016 at 7:26am / Oracle

DAMA Ireland: Data Protection Event 5th May

We have our next DAMA Ireland event/meeting coming up on the 5th May, and will be in our usual venue of Bank of Ireland, 1 Grand Canal Dock. Our meeting will cover two topics. The main topic for the evening will be on Data Protection. We have Daragh O'Brien...
86 0 /
Brad Wulf
Follow /27 Apr 2016 at 11:07pm / Toad for Hadoop - Blog

Toad for Hadoop – Using Spark SQL on Hortonworks

With the release of Toad for Hadoop 1.5, the Toad team has introduced Spark SQL support. Following are step by step instructions to help you set up a Spark SQL environment quickly and connect to it with Toad for Hadoop . For some users it may be a...
331 0 /
Michael J. Swart
Follow /27 Apr 2016 at 5:24pm / SQL Server

You Can’t Force Query Plans If They Use TVPs With PKs

Have you ever played “Fortunately/Unfortunately”? It’s a game where players alternately give good news and bad news. It goes something like this: Databases such as SQL Server make it easy to retrieve sets of data. Unfortunately ...
72 0 /
Denny Cherry
Follow /27 Apr 2016 at 5:00pm / SQL Server

Differences between data types between SQL Server and Oracle

Recently there has been some talk online about how SQL Server processes data type conversions compared to how Oracle’s method for type conversion. I figured that I would clear up some of the confusion that’s out there. When concatenating a number (like...
120 0 /
Ayman El-Ghazali
Follow /27 Apr 2016 at 1:03pm / SQL Server

PolyBase: I now Pronounce you SQL and Hadoop

  Are you interested in Hadoop? With SQL Server 2016 just around the corner, a powerful new feature is being included called PolyBase.  To summarize what it is, just think about it as a marriage between SQL Server and Hadoop.  It is a way to store...
196 0 /
Deiby Gomez
Follow /27 Apr 2016 at 8:33am / Oracle

Mi Recorrido con Tecnologia Oracle (Parte 4)

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. En la Parte 3 de mi recorrido con tecnología Oracle terminé con las siguientes...
227 0 /
Scott Mattie
Follow /27 Apr 2016 at 8:01am / SQL Server

Understanding the configuration file order for Wyse Thin Clients

Problem In an earlier article , I went over how you can configure your system to use a FTP server with DHCP option tags to automatically configure the device. Today, I am going to go over these configuration files, plus the processing hierarchy. My...
64 0 /
Fernando Garcia
Follow /27 Apr 2016 at 12:38am / Oracle

Utilizando expresiones regulares en Oracle

Oracle soporta el uso de expresiones regulares en la base de datos. Podemos utilizar expresiones regulares en el lenguaje SQL. Pero, ¿qué es una expresión regular? ¿Para qué sirve? Una expresión regular especifica...
142 0 /
Chris Shaw
Follow /26 Apr 2016 at 9:50pm / SQL Server

Timing your SQL Server Maintenance Jobs

Maintenance in General is a necessity for SQL Server.  No different than changing the oil in your car or going to the Doctor for the annual exam.  There is going to be times when you are going to need to run maintenance on your server.  The tricky part...
68 0 /
Mohamed.Houri
Follow /26 Apr 2016 at 9:44pm / Oracle

Why my execution plan has not been shared – Part I

For most people troubleshooting SQL query performance problems is a necessity rather than a preference. Very often they are using a trial and error strategy to overcome those frustrating situations. Unfortunately the trial and error method is not reliable...
62 0 /
Dan Hotka
Follow /26 Apr 2016 at 8:29pm / Oracle

Oracle Linux 5 to 6

Hi! I just discovered this migration tip…Oracle Linux users…take note… When migrating to the latest Oracle Database Appliance Patch Bundle, it includes migrating from Oracle Linux 5 to Oracle Linux 6. Input from a member...
68 0 /
Clarisa Maman Orfali
Follow /26 Apr 2016 at 7:23pm / Oracle

Cómo usar Elementos de Aplicación en Oracle APEX 5.0

En nuestra aplicación en APEX generalmente usamos los elementos a nivel página y no a nivel aplicación. Los elementos que son a nivel de aplicación lo usamos para mantener el estado de la sesión. Estos elementos se pueden...
72 0 /
prashanthjayaram
Follow /26 Apr 2016 at 4:50pm / SQL Server

MongoDB : How to get Top, Bottom,Middle and Range of records

In MongoDB,the limit() method is used to limit the result set to be returned. You can also use this with various methods such as sort() and skip() for various combination of requirement. The MS SQL equivalent is TOP function >SELECT TOP 10 * FROM...
235 0 /
Brad Wulf
Follow /26 Apr 2016 at 1:11pm / Toad - Mac Edition

Toad Mac Edition & Amazon RDS Quick Start

Thinking of trying MySQL on the cloud? Sometimes the question isn’t that clear. Perhaps another way to look at it is to answer the following questions: Are you thinking of moving legacy RDBMS to MySQL, MariaDB or PostgreSQL? Is provisioning...
298 0 /
Steven Feuerstein
Follow /26 Apr 2016 at 12:39pm / Oracle

Minimize context switches and unnecessary PL/SQL code: an example from the PL/SQL Challenge

On the PL/SQL Challenge , when you click on a link to play a quiz, you are taken to the "launch" page. We give you an opportunity to review assumptions and instructions, and then press the Start button when you are ready (your score is based...
74 0 /
Sten Vesterli
Follow /25 Apr 2016 at 2:07pm / Oracle

Critical Patch Update - patch your database, WebLogic, Java, MySQL

The Oracle Critical Path Update (CPU) for April is out, and as usual there are some vulnerabilities on the list that you definitely want to patch. The bad ones (who score highest score on the Common Vulnerabilities and Exposure (CVE) standard Version...
137 0 /
Jen Stirrup
Follow /25 Apr 2016 at 1:45pm / SQL Server

SQL Server 2016 Business Intelligence and Dataviz Masterclass

Join me in Edinburgh on 10th June for a one day Masterclass in SQL Server 2016 Business Intelligence and Data Visualisation! You’ll get  takeaway notes and experience hands-on labs  that focus on: Power BI Excel R AzureML SQL Server...
127 0 /
Porus Homi Havewala
Follow /24 Apr 2016 at 4:07am / Oracle

Find Data Guard Enabled targets in your Enterprise

A friend wrote: “As part of our Cloud environment, we wanted to know what databases have Data Guard Enabled and the respective physical standby server details. We have thousands of databases running in 12c cloud control (Enterprise Manager),...
122 0 /
Deiby Gomez
Follow /23 Apr 2016 at 11:36pm / Oracle

My memories from Collaborate16

This year was the second year I have attended Collaborate 16, I had the opportunity to meet a lot of my friends that are in a different country like Gleb Otochkin, Heli Helskyaho, Tim Gorman, Kellyn Pot'Vin-Gorman and Nelson Calero. Collaborate...
166 0 /
DBAFromTheCold
Follow /22 Apr 2016 at 8:55am / SQL Server

Setting up powershell remote sessions

Hey guys, differing from usual this is a quick post on setting up powershell remote sessions. I know you can remotely connect to powershell sessions using the Server Manager that comes with Windows Remote Administration Tools but it’s a bit of a...
155 0 /
Ajith Narayanan
Follow /21 Apr 2016 at 10:50am / Oracle

How To Create Local YUM Repository On RHEL 6

In this post, I will by showing how to create a yum local repository on RHEL 6 1) You must be having a RHEL cd with you for creating the YUM repository -- Load the physical CD to your CD ROM, In case its a physical server, Mount the CD into a mount point...
316 1 /
Melissa Coates
Follow /20 Apr 2016 at 9:21pm / SQL Server

How to Create a Demo/Test Environment for Azure Data Catalog

Azure Data Catalog is a Software as a Service (SaaS) offering in Azure, part of the Cortana Intelligence Suite, for registering metadata about data sources. Check this post for an overview of Azure Data Catalog key features. (I'm a big fan of what...
195 0 /