ThatJeffSmith

Tag: SQL Server

Oracle SQL Developer is for Oracle Database

What is Oracle SQL Developer? Well, according to this document on OTN… What is SQL Developer? Date: May 2014 Oracle SQL Developer is the Oracle Database IDE. A free graphical user interface, Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and keystrokes. A productivity tool, SQL Developer’s […]

Similar Posts by Subject Areas: , , ,

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

Similar Posts by Subject Areas: , , ,

Hint Abuse: SQL Server vs Oracle

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 hand, I suggest you go listen to […]

Similar Posts by Subject Areas: ,

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

Similar Posts by Subject Areas: , , , , ,

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

Similar Posts by Subject Areas: , , , , , ,

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 I’ve […]

Similar Posts by Subject Areas: , ,

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’ […]

Similar Posts by Subject Areas: ,

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

Similar Posts by Subject Areas: , , , , , , , , , , ,

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

Similar Posts by Subject Areas: , , , , , , ,

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

Similar Posts by Subject Areas: , ,

Introducing Toad for SQL Server, Part 1

For those of you who have been living under a rock for the past decade, Toad is one of the most popular database administration and development tools for the Oracle RDBMS. It just so happens that Toad is also available for Microsoft’s SQL Server platform. Skip to Part II Skip to Part III This blog […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,