Database Jumping

Copy legacy Oracle tables with SQL*Plus

Tables with a LONG datatype cannot be copied via the CREATE TABLE AS SELECT syntax. They can, however, be copied with the SQL*Plus COPY command. This Oracle tip shows you how.

Capturing SQL Server 2005 database file size information

It's very important to capture trends of the sizes of your SQL Server 2005 database because it allows you to plan for future space needs, notice types of problems, and plan for time periods of heavy volume. I'll show you the simple method that I use to capture this information.

Drizzle: MySQL slims down on Aker's diet

Brian Aker, MySQL's director of architecture, has unveiled Drizzle, a database project aimed at powering websites with massive concurrency as well as trimming superfluous functionality from MySQL.

Render SQL*Plus output in HTML

SQL*Plus has traditionally been thought of as a plain text SQL query tool. But since Oracle 8i, it has also had the capability to render its output using HTML.

Encrypt backups using Oracle 10gR2's RMAN

No IT pros want their company to make headline news because of a data breach. You can make your data less vulnerable to theft by using a new feature in Oracle 10g Release 2 that lets you make encrypted backups via Recovery Manager.

Comparing SQL Server constraints and DML triggers

This article sheds some light on when to use constraints and when to use DML triggers.

Iterating through tables and databases in SQL Server

We look at 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 on.

Using NOLOCK and READPAST table hints in SQL Server

Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server.

Explore Oracle 10g's updated sample schemas

Each new release of Oracle database brings with it new features to explore. It can be a challenge to create adequate sample tables to play with a given feature.

Control null data in Oracle using the ORDER BY clause

NULL data, which is sometimes called "absent" data, can be difficult to work with in relational databases. Learn how to control null data in Oracle using the ORDER BY clause.

Defining cascading referential integrity constraints in SQL Server

By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.

Execute SQL statements in Integration Services

This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary.

Understanding roles in Oracle-stored procedures

Permissions in Oracle granted indirectly via roles are not available when compiling stored procedures, functions, and packages. Direct grants are required when creating these objects in the database.

How do I ... reject alpha characters in a SQL Server character column?

Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analyses and reports.

Finding dependencies in SQL Server 2005

This tutorial will show how you can write a procedure that will look up all of the objects that are dependent upon other objects.

1234Next >

Delivered Thursdays

Behind every great information application is an even better database design. Every Thursday we help tune and improve the data store, whatever your taste in database.

Log in


Sign up | Forgot your password?

Blogs

RSS feed

  • Staff Share a keyboard and mouse with Synergy

    Even in the era of virtualization, many IT pros (including myself) have a small army of computers sitting on, under, and around their desks. Read more »

    -- posted by Staff

  • Staff Android devs less than gruntled

    Yet more discouraging news on the Android front. Having hacked off its developer community by releasing updated SDKs to just a small group of chosen devs, Google has now given the brush-off to a petition that called for more to be given to the wider community. Read more »

    -- posted by Staff

  • Staff VMware shows how not to do it

    As a developer there will be a time when you ship a bug -- be it a stub that you left in, or a flaming, crashtastic segfault. The next time this happens and your bosses come baying for blood, point them in the direction of VMware, who this week gave the developer world a great example of how to ship a showstopper bug. Read more »

    -- posted by Staff

What's on?

  • Club Builder: Captain Obvious vs the Crackpots

    In the case of the bleeding obvious, IBM says open source needs good designers; a claim is made that China can activate your phone to snoop on you; and we take a look at the Defcon conference.