Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Serena Software Case Study: Watkins Motor Lines, Inc.
- Watkins Motor Lines, Inc. is a nationwide, long haul common carrier with corporate headquarters in Lakeland, Florida. In-place solutions as well as other alternates lacked the integrated "roll together" capabilities of Serena ChangeMan DS and ZMF. This integration as well as the fingerprinting and footprinting functionality drove Watkins Motor Lines...
- Tags: Serena Software Inc., DS, Servers, Hardware
- Case studies
- What does a DBA do all day?
- Data integrity is a DBA's number one responsibility, but do you know what else they do all day? Bob Watkins outlines some of the basic duties of a DBA. by Bob Watkins
- Tags: Database Administrator, Data Integrity, Data, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Bob Watkins
- Blog posts 2008-06-26
- SolutionBase: Configuring a simple database in MySQL 5.0
- Even if you've never used SQL before, MySQL makes setting up a database fairly simple. In this article, Bob Watkins walks you through the procedure necessary to create databases in MySQL 5.0. by Bob Watkins
- Tags: screenshots, Database, MySQL, MySQL 5.0, Bob Watkins
- Image galleries 2007-07-30
- SolutionBase: Migrating a SQL Server database to MySQL 5.0
- Making the jump from Microsoft SQL Server to MySQL 5.0 might sound like an intimidating process, but it's not as bad as it may seem. In this article, Bob Watkins shows you how to migrate SQL Server databases to MySQL 5.0. by Bob Watkins
- Tags: screenshots, Database, Microsoft SQL Server, MySQL, MySQL 5.0, Bob Watkins
- Image galleries 2007-07-23
- Watkins Syndicate Singapore Now Covered by Cisco Unified Communications Technology
- Watkins Syndicate Singapore provides insurance solutions for Cargo, Hull, Energy, Marine Liability and Specie businesses for the whole of Asia. The Communications infrastructure was not scalable as the organisation grew in the last five years. There was need for advanced communication channels beyond those provided by traditional PABX telephone systems....
- Tags: Unified Communications, Cisco Systems Inc., Watkins Syndicate Singapore
- Case studies 2006-05-01
- Render SQL*Plus output in HTML
- Oracle's SQL*Plus query tool can create output as HTML tables in addition to plain text. The output format is controlled by the SET MARKUP command. Bob Watkins offers more details in this Oracle tip. SQL*Plus has traditionally been thought of as a plain text SQL query tool. But...
- Tags: HTML, Bob Watkins, Render SQL*Plus, markup, Oracle Tips Newsletter, Oracle Corp., SQL*Plus
- Technical articles 2007-05-23
- A change management primer for IT consultants
- Determining the ability of the client organization to cope with a major IT project can help consultants find the most appropriate solution. Learn how evaluating the client's roles, resistance, and resilience can help you gauge their capacity for change. by Bob Watkins
- Tags: Project, Change Management, Consultant, Information Technology, Change, Strategy, Recruitment & Selection, Management, Human Resources, Workforce Management, Bob Watkins
- Blog posts 2008-07-04
- 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. Bob Watkins shows you how in this Oracle tip. You may be running Oracle 10g Release 2, but the applications you're supporting may...
- Tags: Oracle Corp., Bob Watkins, LONG RAW, Oracle Tips Newsletter, Downside, Corporate Communications, Storage, Databases, Marketing, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2007-04-24
- Check out this easy way to find Oracle version information
- The PL/SQL package DBMS_DB_VERSION supplies several useful constants that you can use in your code to determine the currently running version of Oracle. Bob Watkins explains how this package makes version checking easier. When an application will be distributed to customers—or even to multiple sites within the same...
- Tags: Oracle Corp., PL/SQL, Databases, Bob Watkins, Programming languages, Oracle Tips Newsletter, TechRepublic Inc., Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2006-10-10
- Use multiple dump files for large Oracle exports
- Even as far back as Oracle 8i, the Export utility could handle large exports by splitting them into multiple output files. Bob Watkins reviews how this is done prior to Oracle 10g and what changes are necessary for 10g and later. Oracle's Export utility exp is a useful part...
- Tags: Oracle Corp., Storage, Databases, Bob Watkins, database, Oracle Tips Newsletter, Export, FILE Parameter, Application Servers, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2007-05-29
- Fifteen things DBAs should unlearn about Oracle
- Oracle 8i, 9i, and 10g have altered the facts behind several common practices followed by database administrators. Consultant and veteran DBA Bob Watkins suggests that 'products move on,' and the old way of doing things sometimes needs to be abandoned in favor of the methods that new features make possible....
- Tags: Database Administrator, Oracle Corp., Databases, Enterprise Software, Software, Data Management
- Download resources 2005-06-17
- Seagate to enter flash storage fray in full force
- It's official. According to the Wall Street Journal, Bill Watkins, Seagate's chief executive, has disclosed in an interview that the company will enter the market for flash-based storage devices as early as next year. Better known to us IT professionals as solid-state drives SSD, these will...
- Tags: Seagate Technology LLC, Storage, Manufacturing, Hardware, Paul Mah
- Blog posts 2007-08-22
- Set named restore points for easier flashback in Oracle 10gR2
- Oracle 10gR2 makes the FLASHBACK TABLE command easier to use with the addition of named restore points. Bob Watkins explains that one huge benefit to restore points is that they eliminate the need to know an exact System Change Number. Oracle 9i introduced a flashback query feature that displays...
- Tags: Oracle Corp., Bob Watkins, restore point, System Change Number, Oracle Tips Newsletter, Oracle 10gR2
- Technical articles 2006-08-29
- Import data via a network link in Oracle 10g
- Oracle 10g's import utility can use a network connection to directly import data from another Oracle database. Bob Watkins explains how it's done. Oracle's export and import utilities have historically used a disk file as intermediate storage when unloading or reloading the database. For large databases, this...
- Tags: Oracle Corp., Oracle Application Server 10g, Storage, Databases, Bob Watkins, network, database, Oracle Tips Newsletter, TechRepublic Inc., Hardware, Enterprise Software, Software, Data Management
- Technical articles 2006-11-07
- Resize BIGFILE tablespaces directly using ALTER TABLESPACE
- Database administrators can now resize Oracle datafiles at the tablespace level using the BIGFILE tablespace feature in 10g. Bob Watkins explains how in this Oracle tip. Oracle 10g introduced a new type of tablespace called BIGFILE. Unlike traditional tablespaces that are composed of up to 1,022 datafiles,...
- Tags: Oracle Corp., BIGFILE, Storage, RAID, Bob Watkins, datafile, tablespace, Oracle Tips Newsletter, TechRepublic Inc., Hardware
- Technical articles 2007-01-09
- Group by GROUPING SETS for custom rollups in Oracle
- The GROUPING SETS option of GROUP BY lets you generate custom sets of subtotals, without seeing as many rows of output as GROUP BY CUBE. In this tip, Bob Watkins offers code samples of how to use GROUPING SETS. When you use GROUP BY with the summary functions like...
- Tags: Oracle Corp., Bob Watkins, Sales strategy, GROUP-BY CUBE, Group-By, GROUP-BY GROUPING SETS, Oracle Tips Newsletter, Combination, Group, GROUPING SETS, CUBE, Corporate Communications, Sales Force Management, Storage, Databases, Sales, Marketing, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2006-11-14
- Enable Change Tracking in Oracle for faster incremental backups
- DBAs can do incremental backups made via Recovery Manager significantly faster by enabling a new Oracle 10g feature called Change Tracking. Bob Watkins explains how to enable the feature. Recovery Manager RMAN was introduced in Oracle 8.0 and enabled true incremental backups for the first time. Prior to...
- Tags: Oracle Corp., Backups, Bob Watkins, Change Tracking, backup, incremental backup, RMAN, Oracle Tips Newsletter, Database
- Technical articles 2006-12-05
- Designing relational tables with subtypes
- Relational tables often describe more than one type of real world entity. In this tip, Bob Watkins covers some things to think about when designing such tables. In an earlier tip, I showed a way to process a table that stored multiple entities in the same table. Let's...
- Tags: Bob Watkins, subtype, Oracle Tips Newsletter, Column, Table, Listing B, Corporate Communications, Storage, Databases, Marketing, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2006-10-17
- De-duplicate tables using Oracle's analytic functions
- Oracle 9i introduced analytic functions, which offer an easier way to remove duplicate rows in tables. Bob Watkins presents sample code that demonstrates how you can use ROW_NUMBER to remove duplicates in your tables. Tables that don't have a Primary Key constraint protecting them can have duplicate rows...
- Tags: Oracle Corp., ROW_NUMBER, Databases, Bob Watkins, analytic function, ROWID, Oracle Tips Newsletter, Row, Enterprise Software, Storage, Software, Data Management, Hardware
- Technical articles 2006-06-06
- << Previous
- page 1 of 1
- Next >>
