ThatJeffSmith

Category: Toad® Stuff (Retired)

Elevenses

Everyone likes to read into numbers and significant dates. Numerology (wiki) attributes a connection from the world of numbers to the physical world. Even though I don’t believe in such things, I can’t help but take advantage of the opportunity to focus on the number ‘11.’ It’s eleventh day of 2011. Toad’s Development Manager is [...]

Toad for SQL Server: Program Your SSMS SP Keys

It happens more often than I like to admit, but I was asked a question about Toad that I could not figure out. A co-worker was trying to help a customer emulate a SSMS feature – the ability to program stored procedures to a keyboard shortcut or keystroke sequence. I got part of the way [...]

Three (4) Ways to get Data into Excel with Toad

I have been really hard on Excel lately. Excel is an excellent tool. Tools can be misused and abused, but it’s not their fault. I should know this being an advocate for Toad, but I digress. Updated on 1/5/2011 to include 4th Method and add note on ‘Display all results in grid’ option. You want [...]

Toad for Oracle Tip: Custom Queries

There are SO many little nuggets in Toad that you can take advantage of. To list all of them would be a daunting task. Here’s one that you may have overlooked, Custom Queries. If you right-mouse-click on an object in the Schema Browser, you’ll see a list of operations you can perform. Take a second [...]

Replaying Activity in SQL Server

Load testing is an interesting topic. Application load testing is what most people are familiar with. They either use something like LoadRunner, or they ask half the company to ‘jump on the website and start clicking buttons.’ But what about the database? In this case, what about SQL Server? Will it be able to sustain [...]

Date Night

For most couples, ‘date night’ is something to look forward to, but unfortunately does not come around often enough. For others, even the word ‘date’ sends a chill down their spine. It’s not an adverse reaction to their partner, but rather a unpleasant reminder to the daily toil that is working with DATE formatted data [...]

My Toad Bible

Ok, I admit, I threw that title up because I wanted to draw attention to my site, guilty-as-charged. However, this is pretty close to being my ‘Toad Bible‘, i.e. my authoritative take on Toad. I reckon it’s my job to educate the market on all things Toad, so that’s where the authoritative piece comes in. [...]

Quest Backup Reporter for Oracle

Quest just released a new tool into the wild. DBAs and systems administrators can now get a better handle on the state of their Oracle backups with a very light-weigh easy to install tool called Quest Backup Reporter for Oracle. You can read a complete overview of the product here, but here are the basics: [...]

Toad on an iPad

No, we have not added native support for Toad to run on a platform other than Windows. No, I can’t tell you when that will happen. In the meantime, I thought you might enjoy a story about someone who has successfully setup his iPad to run Toad. @BigJim is a friend of mine on Twitter [...]

Reverse Engineer Views into an ERD

ERD – Fancy way of saying Entity-Relationship Diagram Since version 10.0 of Toad for Oracle, users have been able to select a table and have an ERD generated that automatically includes any related tables via Referential Integrity. However, what if you are trying to document a view which may bring in one or more other [...]

One Click to Rule Them All

This feature has been around for awhile in the Toad product family (SQL Server, DB2, MySQL, and Data Analysts), however it was upgraded for Toad for SQL Server, version 5.0. Here’s a quick run-down: Open the Editor Load up your T-SQL and get ready to have fun. You will need to activate the ‘Group Execute’ [...]

INTRODUCING TOAD FOR SQL SERVER PT III

Up to this point, I have demonstrated my mastery of the Roman Numeral System, Toad’s IntelliSense and Group Execute technology, and Toad’s SQL Optimization technology. In this post I’ll finish the conversation with an overview of Toad’s Compare and Synch feature set. For your reading enjoyment and my time constraints and sanity, I will show [...]

Introducing Toad for SQL Server Pt II

That’s right folks! Toad for SQL Server has been recognized AGAIN as the best development tool for SQL Server. In a previous post I talked about Toad’s IntelliSense and Group Execute features. Skip back to Part I Skip ahead to Part III Let’s continue the conversation now with a quick introduction on our SQL Tuning [...]

SQL Server vs Oracle Via Toad

This is not a volley in the RDMBS wars. This is a quick cheat sheet for getting started using Toad for SQL Server if you are already used to using Toad for Oracle. Pages not Windows Toad for Oracle is a classic Windows application that utilizes a classic MDI presentation. Toad for SQL Server uses [...]

Sneak Peek at Toad for Oracle v10.6

I really should be more honest. In this case I’m referring to the title of this blog. ‘Sneak Peek’ infers I’m being naughty and showing you something that is secret or not available to the masses. The real story here is that any licensed user of Toad current on maintenance is able to participate in [...]