Expert Blogs - Toad World

Expert Blogs

Blogs

Fernando Garcia
Follow /29 Mar 2017 at 8:55pm / Toad Data Point Blog

Obteniendo resultados de manera más rápida con herramientas de preparación de datos

Hay una expresión del mundo del Big Data que vengo escuchando cada vez con más frecuencia. Me refiero al término “dataprep”. En Big Data, la palabra “dataprep” alude a la “preparación de datos”...
56 0 /
Fernando Garcia
Follow /29 Mar 2017 at 8:51pm / Toad Data Point Blog

Getting faster insights from Big Data with emerging dataprep tools

There is an expression in the Big Data world that I have been hearing more and more frequently. It is the term " dataprep ". In Big Data, the word "dataprep" means "data preparation" and it refers to all the activities related...
22 0 /
Deepak Vohra
Follow /29 Mar 2017 at 7:32pm / Postgres - Blog

PostgreSQL Database with Kubernetes for Performance and Collaboration

By: Deepak Vohra In some earlier tutorials we introduced Kubernetes cluster manager and discussed using it with MySQL database, Oracle Database, and Oracle NoSQL Database. Kubernetes cluster manager orchestrates a cluster of Docker containers, providing...
28 0 /
Brendan Tierney
Follow /29 Mar 2017 at 5:36pm / Oracle Blog

OUG Ireland 2017 Presentation

Here are the slides from my presentation at OUG Ireland 2017. All about running R using SQL. Embedded R Execution using SQL from Brendan Tierney
36 0 /
Fernando Garcia
Follow /29 Mar 2017 at 5:21pm / NoSQL Blog

Big Data: Obteniendo resultados de manera más rápida con herramientas de preparación de datos.

Hay una expresión del mundo del Big Data que vengo escuchando cada vez con más frecuencia. Me refiero al término “dataprep”. En Big Data, la palabra “dataprep” alude a la “preparación de datos”...
25 0 /
Fernando Garcia
Follow /29 Mar 2017 at 5:10pm / NoSQL Blog

Getting faster insights from Big Data with emerging dataprep tools

There is an expression in the Big Data world that I have been hearing more and more frequently. It is the term " dataprep ". In Big Data, the word "dataprep" means "data preparation" and it refers to all the activities related...
102 0 /
Dan Hotka
Follow /29 Mar 2017 at 4:24pm / Toad Data Point Blog

Data Prep Using Toad Data Point

By Dan Hotka Hi, Toad Data Point has been around a while. Its primary use is preparing data and assisting with data analysis. The power of this tool is that it can pull and include data from just about any data store, and mix that data for specific...
32 1 /
John Weathington

Finding Flow with High Collaboration

This is Flow The first time I found flow is an experience I'll always remember. Just around the turn of the century, I was asked to help Hitachi Data Systems improve the way they track, test, and manage data storage configurations. We had a lot...
18 0 /
Robert Catterall
Follow /26 Mar 2017 at 10:45pm / IBM DB2 Blog

DB2 for z/OS: Running REORG to Reclaim Disk Space

Think of why you run the DB2 for z/OS REORG utility, and a number of reasons are likely to come quickly to mind: to restore row order per a table's clustering key; to reestablish free space (for inserts and/or for updates ); to remove the AREO* status...
31 0 /
Porus Homi Havewala
Follow /25 Mar 2017 at 2:57am / Oracle Blog

Enterprise Manager Functionality without the Packs

A friend asked: “I know we can use Oracle Enterprise Manager without the packs. However, is there any document that shows in detail what database monitoring and alerting functionality is provided by Enterprise Manager (12c version) without using...
144 0 /
Porus Homi Havewala
Follow /25 Mar 2017 at 2:55am / Oracle Blog

It works : Multiple Grouping Technique for Database Backups

This blog post is about some questions and answers plus feedback about suggestions. This is to do with a technical article that I had written and which was published on the Oracle Technical Network (OTN) in January 2014. The article was “Back...
124 0 /
Clarisa Maman Orfali
Follow /23 Mar 2017 at 5:56pm / MySQL

How to create an instance of a MySQL database in Amazon RDS

By Clarisa Maman Orfali In a previous article we learned how to create an account in Amazon Web Services (AWS). Besides knowing what Amazon RDS is, we learned how to configure an Oracle Database Instance in Amazon RDS. Here are the links for each...
100 0 /
orawiss
Follow /23 Mar 2017 at 5:16pm / Oracle Blog

Testing in an Agile Development Environment: TDD vs. BDD

By Wissem El Khlifi with Tanja Bach, Certified Scrum Product Owner (Scrum Alliance), UX Consultant and Agile Evangelist Introduction In a traditional environment development and testing are separated into two phases: developers who build features...
151 0 /
Deiby Gomez
Follow /22 Mar 2017 at 3:32pm / Oracle Blog

Taking Care of Block Change Tracking While Duplicating Databases

By Deiby Gomez Before Oracle 12c, pluggable databases didn’t exist; whenever we wanted to clone a database we had use either RMAN Backup and Restore or RMAN Duplicate (Active or from backup location). There are several use cases to consider...
549 0 /
Arun Sirpal
Follow /22 Mar 2017 at 1:00pm / SQL Server Blog

My path from a junior to a senior DBA

A non-technical post but something I have been asked about few times so I thought that I would put pen to paper and tell you about my journey on becoming a senior DBA. You might find it fun to read. Time … Continue reading →
130 0 /
Steven Feuerstein
Follow /21 Mar 2017 at 9:22pm / Oracle Blog

Tightening security in your PL/SQL code with 12c new features, part 1

Oracle Database 12c offers several enhancements to improve security in your PL/SQL program units. These features include: Code-based access control: fine-tune access to database objects inside program units by granting roles to program units , rather...
182 0 /
Pinal Dave
Follow /21 Mar 2017 at 1:30am / SQL Server Blog

SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved Because it is a Work Table Page – TempDB Files

This blog is an outcome of an email communication with my client. The issue was that they were having big tempdb files. They had multiple files and of uneven size. As soon as they restart SQL, the initial size itself was huge and when they tried to shrink...
104 0 /
Clarisa Maman Orfali
Follow /20 Mar 2017 at 9:45pm / MySQL

What is PhpMyAdmin and how to manage a MySQL database with this tool

By Clarisa Maman Orfali In this article we are going to give an overview of this application called PhpMyAdmin , which is one of the most popular applications for the management of MySQL databases. Throughout my professional career I have used this...
64 0 /
Dan Hotka
Follow /20 Mar 2017 at 8:03pm / Oracle Blog

Index Clustering Factor and Oracle

Hi, There is quite the scenario that the Oracle Cost-Based Optimizer (CBO) uses when deciding when to use indexes to process your SQL. I go into this in great detail in my SQL Performance Tuning course ( click here for details ). Clustering factor...
220 0 /
Henrik Loeser
Follow /20 Mar 2017 at 1:57pm / IBM DB2 Blog

IBM Bluemix in Germany, includes dashDB and Cloudant

42 0 /
Arun Sirpal
Follow /20 Mar 2017 at 6:30am / SQL Server Blog

TDE: Looking inside your database and backups

TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too. I fancied looking inside the MDF and a backup of my database before enabling TDE and comparing it to … Continue reading...
93 0 /
Nakul Vachhrajani
Follow /20 Mar 2017 at 3:30am / SQL Server Blog

#0403 – SQL Server – CAST/CONVERT to string – Pad zeroes or spaces to an integer

Padding zeroes to an integer is often required during data migrations and integrations. Here is the approach I use in such data conversions.
96 0 /
Pinal Dave
Follow /20 Mar 2017 at 1:30am / SQL Server Blog

SQL SERVER – sp_readrequest – Long Running Process

Just another day while doing performance tuning engagement , Senior DBA of the organization and I both noticed that one of the SP sp_readrequest  is continuously listed as long running SP. Well, the good part was that it was not taking too much of the...
101 0 /
o.mustafaoracle
Follow /19 Mar 2017 at 2:58pm / Oracle Blog

Create Backup On Demand On the Cloud

In This Post i will show how to create backup for Dbaas :- Open the Oracle Database Cloud Service console. Click the database deployment for which you want to create a backup. Click the Administration tile. Click Backup Now and then confirm the action...
201 0 /
Pinal Dave
Follow /19 Mar 2017 at 1:30am / SQL Server Blog

How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #114

Question: How to Find How Many Rows Each Query Returned Along with Execution Plan? Answer: During my performance tuning consultancy engagement, this is one of the most asked questions. Everyone wants to know how many row any query returned and what...
108 0 /