Discuss in the Community - Toad World

Discuss in the Community


Ryan Adams
Follow /9 Oct 2015 at 1:50pm / SQL Server

Thank You Community

All I can say is, “Wow…Thank you!”.  I won a seat on the PASS Board of Directors and it’s very surreal.  I am beyond excited, but not for what happened.  I’m excited and energized for what is to come.  PASS is young and our...
21 0 /
Sten Vesterli
Follow /9 Oct 2015 at 1:20pm / Oracle

Vote for the Oracle Database Developer Choice Awards

Oracle has started a brand-new appreciation program for database developers called the Oracle Database Developer Choice Award. There are five categories: SQL PL/SQL APEX Oracle REST Data Services Database design Oracle users worldwide...
65 0 /
Mark Broadbent
Follow /9 Oct 2015 at 1:09pm / SQL Server

How I learned to stop worrying and love the b̶o̶m̶b̶ MVP

still not cutting the mustard I would like to say a big thanks to those few people who recently voted for me to receive an MVP award. Being nominated by someone you look up to or your peers is quite frankly awesome, but anyone who knows me will (I hope...
19 0 /
Brad Wulf
Follow /9 Oct 2015 at 12:05am / Toad for Hadoop - Blog

Hadoop is not a panacea, but here's what you need to know to make it a competitive differentiator for your Organization!

Hadoop World New York was last week, this is my 4th such event and the ecosystem is more vibrant than ever. Full disclosure, i spent most of the first Hadoop World I ever attended struggling to understand why anyone would need yet another entire Database...
196 0 /
Kellyn PotVin
Follow /8 Oct 2015 at 11:05pm / Oracle

Indianapolis, ECO, IOUG and Oracle Education Foundation, Ohm My!

I’ve been a bit busy traveling and speaking, but I wanted to discuss the great events I’ve been lucky enough to be part of the last couple weeks. Indianapolis Oracle User Group I spoke at the INOUG back on September 17th.  The user group...
97 0 /
Mark Kurtz
Follow /8 Oct 2015 at 10:15pm / Toad Data Modeler

Using Toad Data Modeler to Convert from Oracle 12c to SQLServer 2012.

I just needed to do a simple conversion from Oracle to SQLServer. I didn't have the need to spend time trying to customize anything but I did come across a couple of 'extra' steps that I thought I would share with you. I opened my Oracle...
110 0 /
Denny Cherry
Follow /8 Oct 2015 at 8:29pm / SQL Server

Your PASS Speaker Idol 2015 Judges

I’m pleased to announce the judges for this PASS Speaker Idol 2015 are: Mark Simms Joey D’Antoni Allen Hurt Andre Kammen Hope Folly These judges will be joined by Karen Lopez at the final session so that we have a judge who...
48 0 /
Stuart Ainsworth
Follow /8 Oct 2015 at 2:00pm / SQL Server

Coding naked.

Me, circa 1992. This is not the most embarrassing picture of me from that time period. True story: when I was in college, I was the lead singer (if you can call it that) for a goth rock Christian rave band called Sandi’s Nightmare.  I had zero...
46 0 /
Stuart Ainsworth
Follow /8 Oct 2015 at 2:41am / SQL Server

Protected: Coding naked.

This content is password protected. To view it please enter your password below: Password:
56 0 /
Julie Hyman
Follow /8 Oct 2015 at 12:14am / Toad Intelligence Central

Are You Giving Your Data Analysts the Tools to Work Like a Team?

If your data analyst or data preparation teams are like most, chances are your organization is producing and sharing a lot of data in different output formats that cannot be easily tracked. This means you never have full visibility into the amount of...
31 0 /
Julie Hyman
Follow /8 Oct 2015 at 12:08am / Toad Data Point

Are You Giving Your Data Analysts the Tools to Work Like a Team?

If your data analyst or data preparation teams are like most, chances are your organization is producing and sharing a lot of data in different output formats that cannot be easily tracked. This means you never have full visibility into the amount of...
175 0 /
Mladen Prajdic
Follow /7 Oct 2015 at 11:05pm / SQL Server

SSMS Tools Pack 3.6 is out with support for SSMS 2016 CTP's and new database data search.

This new feature brings the following improvements: Support for SSMS 2016 CTP 2.3 and up: With each new SSMS 2016 CTP the compatibility might break. Future updates will come as soon as possible. Search Database/Table Data: Completely...
68 0 /
Arthur Olcot
Follow /7 Oct 2015 at 7:57pm / SQL Server

SQL Server Contracting – The first 14 months (or so)

Crikey, where did that time go! I have been so busy adjusting to my new work life style I have completely neglected my blog.. Well now that I seem to be adjusted to the world of contracting (or rather adjusted to working more than a mile away from where...
58 0 /
Larry Leonard
Follow /7 Oct 2015 at 6:55pm / SQL Server

Finding All Databases Where User is not in Role

This script will find all the databases (matching a certain pattern) on the server where a given user is not a member of a given role. Because sometimes you need to know that. -- Be sure to change the User and Role variables. declare @Sql nvarchar(4000...
55 0 /
Denny Cherry
Follow /7 Oct 2015 at 5:00pm / SQL Server

Basic Database Mirroring Monitoring

If you have database mirroring setup and running, you’ll notice that it has a lack of built in monitoring. And if you have a lot of databases having monitoring for each potential state that each database can be in can flood you with email if the...
50 0 /
Jen McCown
Follow /7 Oct 2015 at 3:59pm / SQL Server

You DO have outstanding, free backup and maintenance, right?

It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on MidnightSQL.com, or that you read about it on MinionWare.net (or one of our newsletters). Or it’s...
56 0 /
Follow /7 Oct 2015 at 3:17pm / SQL Server

Get Hyper-V Host To Talk To Guest VM’s With This Simple Trick - WaterOx Consulting

The Assumption I assume you already have a Hyper-V basic configuration on... The post Get Hyper-V Host To Talk To Guest VM’s With This Simple Trick appeared first on WaterOx Consulting .
56 0 /
Follow /7 Oct 2015 at 2:00pm / Oracle

Why go to Oracle OpenWorld?

We’re a shade under a month away from the biggest event in the calendar for those that work in the Oracle marketplace – the Oracle OpenWorld Conference. It runs every year in San Francisco and draws a massive 60,000 attendees from 145 countries...
58 0 /
Kenneth Fisher
Follow /7 Oct 2015 at 1:00pm / SQL Server

Finding the error from a failed job.

This is a fairly simple one once you’ve seen it, but then so are lots of things :) . Let’s say you have a failed SQL Server job. Here is our job that will fail: Pic1 Then we run it and it fails! And when we click on the error...
50 0 /
Abu Fazal Abbas
Follow /7 Oct 2015 at 11:50am / Oracle

ONLINE statistics collection in Oracle Database 12c : Part 2

Today’s discussion is again on the ONLINE statistics collection in Oracle database 12c. In one of my earlier post , I had discussed about the extensions/enhancements made to the online statistics collections in Oracle 12c. We have seen that Oracle...
106 0 /
Dan Hotka
Follow /6 Oct 2015 at 9:41pm / Oracle

SQL Tuning- lessons learned from a lifetime in Explain Plans (part 13)

Hi! Here is a cool tip. When tuning SQL with sub-queries, did you know since Oracle10 there is a label you can add that shows up in the PLAN_TABLE? I submitted my findings to the Toad crew and they added it to Toad! The QB_NAME(<label>...
77 0 /
Dan Hotka
Follow /6 Oct 2015 at 9:36pm / Oracle

The Importance of Index Monitoring

Hi! One might wonder, indexes are good, why do I need to monitor them? Well, monitor their usage then. Indexes are good for SQL when they are used. Oracle10 was a big change for the cost-based optimizer (CBO). The older CBO and the old rule...
95 1 /
Syed Jaffar Hussain
Follow /6 Oct 2015 at 9:28pm / Oracle

Managing & Troubleshooting Exadata - Upgrading & Patching Exadata

As part of managing & troubleshooting Exadata article series, I shall be discussing various administrative and troubleshooting topics on Exadata. This part of the article is mainly focused on the need of Exadata patching, patching path & tools...
61 0 /
Thomas LaRock
Follow /6 Oct 2015 at 8:58pm / SQL Server

HOW TO: Improve Database Performance Without Changing Code

I’ve stated before that great database performance starts with great database design. So, if you want a great database design you must find someone with great database experience. But where does a person get such experience? We already know that great...
99 0 /
Craig Mullins
Follow /6 Oct 2015 at 8:44pm / IBM DB2

Sorting by Day of the Week in DB2

Today's blog will walk you through a sorting "trick" that you can use when you are dealing with days of the week. A relatively common problem involves sorting a column that contains a day-of-the-week not in alphabetical order by in the order...
26 0 /