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

|
|
Popular Posts