ORACLENERD!

Connecting to Access, DB2, MySQL, SQL Server, Sybase, & Teradata with SQL Developer

SQL Developer is built by Oracle, for Oracle. It’s the database IDE. That’s my current elevator pitch, at least. But, SQL Developer is also a fully featured data modeling solution (have you been enjoying my data modeling posts?) AND a 3rd party database migration platform.

The migration piece is the Migration Workbench. Since we support migrations [...]

Hint Abuse: SQL Server vs Oracle

Hints, UK – to be visited in moderation!

I’ve overheard the SQL Server folks talking about the challenges of support applications where the NOLOCK (or is it NO_LOCK?) hint has been deployed to make transactions and queries go faster.

This probably causes more problems than it solves, and rather trying to rehash what I’ve heard second [...]

Moving Data to Oracle with Migration Workbench

I’ve been referring customers to SQL Developer’s Migration Workbench for a few months now. I thought it might be a good idea to give it a try myself before I send any more children out to play with the wolves.

Kudos to Oracle for using Foreign Keys!

This is NOT a formalized review. This is a [...]

SQL Server VS Oracle: Index Monitoring

Jealousy is not an emotion I generally feel for the SQL Server technology stack. I covet their Twitter camaraderie, but I ‘know’ that Oracle can counter just about anything thrown at it.

People that Helped Me with this Post

I was reminded that even old dogs can be taught new tricks while monitoring the #SQLSaturday conversation going [...]

Oracle vs SQL Server, Take II

Missed PT I?: Read Part I my favorite aspects of each RDBMS platform
Update: Read PT III where I talk about monitoring indexes

I had the pleasure of hanging out with @oraclenerd and @SQLChicken earlier this year in Tampa, FL. It was remarkable for a couple of reasons, but what I remember most is playing translator. [...]

Oracle Vs SQL Server

Disclaimer and Update: I now work FOR Oracle. So keep that in mind when you read these posts. Of course I wrote them BEFORE I started at Oracle, but I still figure you ought to know that…does that mean I think that Oracle wins the debate now? I’ll let you guess how that works [...]

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’ panel by [...]

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 the Server [...]

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 feature.

SQL [...]

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 [...]

Related Posts Plugin for WordPress, Blogger...