sql developer

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Iterating through tables and databases in SQL Server

This tip presents two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so...

Tags: Databases, Sql Developer, Sql

Blog posts 2007-06-11

Comparing SQL Server constraints and DML triggers

Over the years, I have witnessed many developers be confused about when to use data-manipulation language DML triggers vs. when to use constraints. I have seen numerous occasions where both objects have been used incorrectly, which has led to problems. This article sheds some light on when to use constraints...

Tags: Sql Developer, Sql

Blog posts 2007-06-04

Oracle SQL Developer: New Article on OTN

I have a new article on OTN. Making the Most of SQL Developer Reports.The article walks through creating both very simple and somewhat complex reports. It also covers adding bind variables, customizing the bind dialog and creating drill down reports. SQL Developer has a lot of report...

Tags: SQL, Oracle Corp.

Blog posts 2006-07-12

New Version of Oracle SQL Developer (Raptor) Available

Oracle SQL Developer, i.e. Raptor, Early Adopter Release 4.1 was posted on Feb 17. SQL Developer is the new Oracle SQL and PL/SQL GUI....This post originally appeared on an external website

Tags: Oracle Corp., Oracle SQL, Raptor, SQL

Blog posts 2006-02-18

Additional Resources

Oracle SQL Developer for Database Developers

Oracle SQL Developer is a new, free graphical tool that enhances productivity and simplifies database development tasks. Designed for Oracle Database developers, Oracle SQL Developer simplifies development cycles and reduces the need to buy third-party tools for developing and debugging SQL and PL/SQL code. Using SQL Developer, users can browse,...

Tags: Developer, Oracle Corp., SQL, Oracle SQL Developer, Databases, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware

White papers 2006-03-01

Oracle SQL Developer Soars

Every craftsman needs a workbench. With a good workbench, people have room to work. Tools are at hand for immediate use and yet out of the way when not required. Ultimately, a good workbench is an extension of the person using it. Oracle has just released such a workbench in...

Tags: Developer, Oracle Corp., SQL, Workbench, Oracle SQL Developer, Storage, Databases, Programming Languages, Hardware, Enterprise Software, Software, Data Management, Software Development, Software/Web Development

White papers 2006-05-01

Extending Oracle SQL Developer

There are times when a tool does exactly what one needs it to do and times when one feels that a tool would suit the user better if a few extra features had been implemented. Suppose a tool one use regularly does not include some key functionality one needs, and...

Tags: Developer, Oracle Corp., SQL, Tool, Oracle SQL Developer, Productivity, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

White papers 2007-07-01

Making the Most of Oracle SQL Developer Reports

Oracle SQL Developer formerly Project Raptor is Oracle's new multiplatform Graphical User Interface GUI for developers and DBAs. Oracle SQL Developer offers many powerful features for developers, including graphical dialog boxes for database object manipulation, SQL worksheets, a PL/SQL editor, and a reporting facility. It's based on the Oracle JDeveloper...

Tags: Developer, Oracle Corp., SQL, Oracle SQL Developer, Report Facility, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

White papers 2006-07-01

Now Reporting

In March 2006, Oracle announced the availability of Oracle SQL Developer, a GUI for Oracle Database. Oracle SQL Developer provides an easy-to-install, lightweight, multiplatform GUI that enables database developers to do a variety of database activities, including browsing, creating, and updating data. In the area of reporting, Oracle SQL Developer...

Tags: Oracle Corp., Oracle SQL Developer, Storage, Databases, Hardware, Enterprise Software, Software, Data Management

White papers 2007-05-01

Validate Your Refactored SQL Queries With a New SQL Server 2005 Operator

Often a developer needs to do the refactoring without affecting the results. When a developer refactors a query that returns the correct result set, adhering to the Hippocratic principle of "First, do no harm" will ensure to maintain quality. In this case, the principle as applied is "Make sure one...

Tags: Developer, Microsoft SQL Server, Jupitermedia Corp., Principle, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management

White papers 2007-04-20

MSDN Webcast: Overview of the New Developer Features in SQL Server 2005 - Level 200

The release of SQL Server 2005 brings with it many new productivity enhancements for the database developer. The attendee of this webcast gives a brief overview of the major new developer features of SQL Server 2005.

Tags: Developer, Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management

Webcasts

Making Database Connections: Connect to Oracle and Third-Party Databases From Oracle SQL Developer

Oracle SQL Developer enables developers and DBAs to browse, create, and update data in a database. Before one can perform those actions, however, one must create at least one database connection - an Oracle SQL Developer object containing the information needed to connect to a specific database as a specific...

Tags: Developer, Oracle Corp., SQL, Oracle SQL Developer, Storage, Databases, Hardware, Enterprise Software, Software, Data Management

White papers 2008-05-01

SQL Ultimate Debugger (zip)

SQL Ultimate Debugger is the ultimate developer tool for tracing and debugging SQL Server database code. It is the SQL server tool for developers who debug SQL server stored procedures, functions UDFs and triggers. This tool allows a developer to inspect values of ALL objects: simple variables, temporary tables, table...

Tags: Microsoft SQL Server, SQL, Tool, Lakeside SQL, SQL Ultimate Debugger, Productivity, Databases, Enterprise Software, Software, Data Management

Software downloads 2008-04-21

Configuring SQL Developer for MySQL

I rant against Oracle products a lot in this blog, but I have to admit I actually like a few of their products. One of them is SQL Developer. Strangely though, the feature I kind of like best is that SQL Developer can connect to non-Oracle databases like MySQL. This makes...

Tags: Developer, Oracle Corp., MySQL, SQL, Databases, Open Source, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Rex Baldazo

Blog posts 2007-11-27

Setup vs2005 for sql 2005 server dev. edtion

I am a student, and have just downloaded from msdnaa VS2005 and sql 2005 server developer edition.My installation went smoothly, but now for my problem...When i try to addcreate a new databasemdf inside VS2005 i get an this error:Connections to SQL server files(*.mdf)require sql server express 2005 to function properly....

Tags: Programming languages, Databases, kenichi@..., VS2005, SQL, server, Microsoft SQL Server, developer edition

Discussion threads 2007-08-03

Managing File Versions: Edit Files and Use Version Control in Oracle SQL Developer 1.5

Oracle SQL Developer 1.5 expands its file-based support by introducing tight integration with the CVS and Subversion version control systems. In addition to letting one browse and edit files in the file system, this Oracle SQL Developer release enables to import files into the source control system, check them out,...

Tags: Developer, Oracle Corp., SQL, Oracle SQL Developer 1.5, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

White papers 2008-07-01

Worth the Wait: Why SQL Server 2008 is Great

SQL Server 2008, released in the first half of 2008, is intended to provide a comprehensive data platform for both structured and unstructured data that is more secure, reliable, manageable, and scalable than previous releases. But how will it affect you as a working DBA and developer? ...

Tags: Database Administrator, Microsoft SQL Server 2008, Microsoft SQL Server, Quest Software Inc., Databases, Enterprise Software, Software, Data Management

White papers 2008-02-01

New certification options for SQL Server 2005 and Visual Studio 2005

With the release this week of SQL Server 2005 and Visual Studio 2005, Microsoft has also rolled out some new training and certification options. What's interesting to me is how much the new certifications are serving niches that are becoming more and more narrow. For example, there's now a "Microsoft...

Tags: Microsoft Visual Studio, Microsoft SQL Server, Microsoft Visual Studio 2005, Microsoft Corp., Microsoft SQL Server 2005, Quality, Microsoft Development Tools, Enterprise Software, Databases, Business Operations, Development Tools, Software Development, Software/Web Development, Software, Data Management, Jason Hiner

Blog posts 2005-11-11

MSDN Webcast: SQL Server MasterClass: User-Defined Types (Level 200)

Microsoft SQL Server provides the database administrator and the developer with a lot of functionality out of the box. In SQL Server 2005, there is a new feature that helps to define new data types for the applications. The attendee of this webcast will find out what is required to...

Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Databases, Enterprise Software, Software, Data Management

Webcasts 2006-01-31

MSDN Webcast: Building Data-Driven Web Applications With SQL Server Express (Part 3 of 3) (Level 200)

This webcast explains how to integrate Microsoft SQL Server 2005 Express Edition with Microsoft Visual Web Developer 2005 Express Edition to set up a project, create a SQL Server Express database, and explore the uses of the Microsoft ASP.NET Web site administration tool. Other topics that are covered in the...

Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Server, Microsoft Corp., Databases, Enterprise Software, Digital Media, Software, Data Management, Consumer Electronics, Personal Technology

Webcasts