Expert Blogs - Toad World

Expert Blogs


Steven Feuerstein
Follow /29 Sep 2016 at 2:51pm / Oracle Blog

Develop a keen eye for unnecessary code

We've been offering quizzes on the PL/SQL Challenge (and now the new Oracle Dev Gym - still in an "early adaptor" user testing phase) since April 2010. We've covered hundreds of topics in PL/SQL, and hundreds more in SQL. Most quizzes...
34 0 /
Arun Sirpal
Follow /29 Sep 2016 at 8:42am / SQL Server Blog

My application to Microsoft

I have been eager to write this blog post for a while now. I want to share my experience of the process that I went through (last year) when I applied to Microsoft for a SQL PFE (Premier Field Engineer) … Continue reading →
39 0 /
Pinal Dave
Follow /29 Sep 2016 at 2:30am / SQL Server Blog

SQL SERVER – SSMS Trick – Switching Columns in Grid Output

Yesterday when I wrote about what I learnt from Vinod’s session at the SQL Server User Group meeting, one of my friends wrote back asking what else was discussed. Though I knew some of the tips and tricks he showed as part of the sessions, there were...
49 0 /
Sten Vesterli
Follow /28 Sep 2016 at 10:46pm / Oracle Blog

But Where's the Business Logic?

In the U.S., there was an ad where a customer was presented with a very large hamburger bun. When she opens it, she exclaims: But where's the beef? Just back from OpenWorld, I have the same feeling. It was all about the snazzy UIs you can build...
128 0 /
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...
27 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...
434 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...
68 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...
230 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...
70 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...
63 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)...
172 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...
28 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...
30 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...
29 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...
26 0 /
Follow /27 Sep 2016 at 12:00pm / IBM DB2 Blog

Ember’s Best Practices for Runstats and Reorgs

A number of new clients I’ve worked with lately have had minor or major runstats or reorg issues. I have tons of advice on runstats and reorgs across many blog entries, but I don’t have one place where all that advice is brought together....
7 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”...
170 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...
71 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...
63 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...
310 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...
101 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...
68 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...
101 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...
66 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...
61 0 /