Expert Blogs - Toad World

Expert Blogs


Follow /28 Sep 2016 at 4:46pm / IBM DB2 Blog

Process to Justify an IBM DB2 Analytics Accelerator (IDAA) Part 2

The benefits of having an IDAA appliance is something that every mainframe DB2 shop should investigate.  Investigating and justifying an IDAA appliance can be done at no cost.  In the previous blog, I talked about the set up steps for getting an IDAA...
7 0 /
Steve Hilker
Follow /28 Sep 2016 at 1:16pm / Oracle Blog

Announcing Database Discussions!

Let the discussions begin. Starting on October 10, 2016, Toad World will be launching a new way to engage with our database experts simply called "Database Discussions". Database Discussions will be a round table discussion in blog format...
227 0 /
Follow /28 Sep 2016 at 12:18pm / SQL Server Blog

Query shortcuts in SQL Server Management Studio

Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you! Following on from my last post Changing connection colours in SSMS I thought I’d write another quick about this cool but also often unused feature in...
39 0 /
Deiby Gomez
Follow /28 Sep 2016 at 5:07am / Oracle Blog

How to Change the Protection Mode with Data Guard Broker

In this article we will see how to change the protection mode in a Data Guard configuration which is managed by Broker, If you want to read more about each Protection Mode you can read HERE . In this article we will focus on what is needed in order to...
102 0 /
Pinal Dave
Follow /28 Sep 2016 at 2:30am / SQL Server Blog

SQL SERVER – Hidden SSMS Gem: Find Dialog’s Unknown Functionality

I have an eye for details and I try to keep looking for something new to some of the tasks I have been doing for years together. This exploration and quest to learn new techniques is what has made me survive longer in this industry I suppose. So let me...
55 0 /
Fernando Garcia
Follow /28 Sep 2016 at 1:22am / NoSQL Blog

JSON, BSON y WiredTiger

JSON es uno de los estándares más utilizados en la web para el intercambio de datos. Gracias a la universalidad de las estructuras de datos que ofrece JSON, la mayoría de los lenguajes de programación modernos encuentran en...
53 0 /
Dan Hotka
Follow /27 Sep 2016 at 10:45pm / Oracle Blog

Oracle Open World 2016

Hi, OOW 16 is in the history books. Didn’t seem there were near the volume of people this year. The sessions I sat in on were full but not packed. I have a lot of material to share! The ACE Briefing (always the Thursday and Friday before)...
145 0 /
Follow /27 Sep 2016 at 9:56pm / SQL Server Blog

SQL Server: Monitoring Disk Space with FSUTIL command line utility

Table of Contents Introduction Pre-requisites Data flow Enable xp_cmdshell Download SQL Code Output Conclusion References See Also Introduction This article talks about one of SQL method to fetch the...
12 0 /
Ed Elliott
Follow /27 Sep 2016 at 8:23pm / SQL Server Blog

Refactoring in SQL Server Data Tools - SSDT

In this post I will talk about the in-built refactoring support in SSDT – the language is slightly different from my normal style as originally it was going to be published else but rest assured it is written by myself What is refactoring? In programming...
15 0 /
Chris Yates
Follow /27 Sep 2016 at 3:00pm / SQL Server Blog

Is ROI for Vendors Worth the SQL Saturday Investment?

Piggy backing onto the recent SQL Saturday post here in Louisville, I wanted to take a more in-depth look, from my perspective, on how vendors all fit into these events. Having the opportunity to work alongside these vendors has been both a learning...
12 0 /
Kenneth Fisher
Follow /27 Sep 2016 at 2:00pm / SQL Server Blog

Pinned Tabs

It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett ( b ) linked to my post Comparing Two Query Plans . Since I always find that interesting I followed the link and wound up at his post 3...
12 0 /
Arun Sirpal
Follow /27 Sep 2016 at 9:31am / SQL Server Blog

SSMS 2016& Azure SQL DBs

When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that I noticed when you are connected to an Azure (logical) SQL Server. So below I have 2 screen shots – 1 when connected to an “earthed”...
147 0 /
Pinal Dave
Follow /27 Sep 2016 at 2:30am / SQL Server Blog

SQL SERVER – How to Find Out When Your SQL Login Will Expire?

If you are a SQLDBA, you must have created a login and you must have known about enforcing password policy to SQL Logins. Once of my client asked to provide script to find expiry details about SQL Login.  It was an easy task. I went to books online and...
63 0 /
Clarisa Maman Orfali
Follow /26 Sep 2016 at 11:19pm / Oracle Blog

Cómo colocar Logo y Texto en simultaneo en nuestras aplicaciones en APEX 5.0

En este artículo sencillo te maestro cómo puedes colocar el logo y un texto al lado del logo en nuestras aplicaciones en Oracle APEX 5.0. Si recuerdas, en la página de inicio de nuestra aplicación, tenemos el botón...
56 0 /
Deiby Gomez
Follow /26 Sep 2016 at 10:32pm / Oracle Blog

Notes from Oracle Open World 2016

September began with good conferences for me, I was speaker in " Training Day 2016 " an event designed for entrepreneurs where several Speakers with a good case of life were presenting. This year the event had Speakers like Benjamin Sywulka...
291 0 /
Follow /26 Sep 2016 at 8:38pm / Toad for Oracle Blog

Sharing Toad Project Manager files

With the addition of Toad Intelligence Central into the Toad ecosystem it has become increasingly easier to collaborate across the organization. You can not only share data, automation, and SQL files but essentially any file that you would like to share...
94 0 /
Denny Cherry
Follow /26 Sep 2016 at 6:18pm / SQL Server Blog

Your PASS Summit Speaker Idol Judges

Last week I announced the PASS Summit 2016 Speaker Idol contestants .  This week it’s time to announce the judges.  We’ve seen most of the judges at speaker idol before, so we know how great a job they’ll do.  Last year we had 5 j udges...
62 0 /
Steven Feuerstein
Follow /26 Sep 2016 at 5:59pm / Oracle Blog

Looking for stories about using Hibernate with Oracle Database

I recently (well, OK, not all that recently) received this request: Our Java developers think that the work can be done faster with Hibernate by basically eliminating the "middle-men" and "middle-women" (ie. the database developers...
93 0 /
David Fitzjarrell
Follow /26 Sep 2016 at 4:55pm / Oracle Blog

“My Kingdom For A Histogram”

"Don't you know anything at all about numbers?" "Well, I don't think they're very important," snapped Milo, too embarrassed to admit the truth. "NOT IMPORTANT!" roared the Dodecahedron, turning red with fury...
59 0 /
Brendan Tierney
Follow /26 Sep 2016 at 4:49pm / Oracle Blog

Machine Learning notebooks (and Oracle)

Over the past 12 months there has been an increase in the number of Machine Learning notebooks becoming available. What is a Machine Learning notebook? As the name implies it can be used to perform machine learning using one or more languages and allows...
59 0 /
Follow /26 Sep 2016 at 3:16pm / Oracle Blog

Why my execution plan has not been shared – Part III

In the previous instalment of this series we looked at four reasons from gv$sql_shared_cursor view and explained the situations and criteria for which Oracle is forced to compile a new execution plan. We used reproducible examples to demonstrate these...
94 0 /
Craig Mullins
Follow /26 Sep 2016 at 2:35pm / IBM DB2 Blog

Use a Little SQL Magic to Clean Up Your Data

Data integrity sometimes can be a vexing problem to overcome. Data gets brought into our systems in many different ways: through data entry clerks, online by customers, purchased data, ETL, and on and on. And there is no guarantee, many times, that the...
88 0 /
Kenneth Fisher
Follow /26 Sep 2016 at 2:00pm / SQL Server Blog

Nil to Speaker: Improving your PowerPoint skills

As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve been collecting a few links with examples and instructions I have been using to improve my skills. Some awesome PPT slides by Edwin M Sarmiento...
53 0 /
Chris Webb
Follow /26 Sep 2016 at 1:30pm / SQL Server Blog

SSAS Multidimensional Caching-Related Performance Problems With Power BI Tables

Last week I was doing some performance tuning for a customer using Power BI on top of a large SSAS Multidimensional cube via a Live connection. Some of their reports were performing particularly badly and I uncovered a problem with the DAX generated by...
46 0 /
Follow /26 Sep 2016 at 9:50am / Oracle Blog

ORA-12154: TNS:could not resolve the connect identifier specified” error during DBCA

While trying to install Oracle Database 11gR2 on Windows 2012R2 I faced the following error :- ORA-12154: TNS:could not resolve the connect identifier specified” error during DBCA After checking the logs and investigate about the issue :- The password...
63 0 /