Home / Blogs
Follow this blog:
RSS
Email Alert

The Enterprise Cloud

Selena Frye

Selena Frye

TechRepublic Staff

Selena Frye

Selena Frye
Selena has been at TechRepublic since 2002. She is currently a Senior Editor with a background in technical writing, editing, and research. She edits Data Center, Linux and Open Source, Apple in the Enterprise, The Enterprise Cloud, Web Designer, and IT Security blogs.
  • 8

    Handling NULL values in SQL Server 2005

    If you are a developer, you will almost certainly have to deal with NULL values at some point, even if the database is overly normalized. The more knowledge you have about dealing with these NULL...

    Posted by Tim Chapman | August 6, 2007, 12:23 PM PDT | Latest comment by arsinoe20

  • 80

    How do you do your back-ups?

    In the past, tape was the solution. The problem is that this still tends to be the answer. Either backup admins are complacent and don't want to change, or decision makers are unwilling to look at...

    Posted by Damon Howell | August 6, 2007, 7:00 AM PDT | Latest comment by James Speed

  • 9

    Avoiding TOO_MANY_ROWS errors in PL/SQL

    Oracle's PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the...

    Posted by Bob Watkins | July 31, 2007, 9:20 AM PDT | Latest comment by kwaltenberg@...

  • 4

    Four cool new features slated for SQL Server 2008

    SQL Server 2008 (code named Katmai) is scheduled to launch in February of next year, and the code isn't slated to be released to manufacturing until Q2 2008. But database gurus don't have to wait...

    Posted by Tim Chapman | July 30, 2007, 9:08 PM PDT | Latest comment by ho.nguyen@...

  • 0

    See how to install, configure, and use Microsoft's iSCSI initiator?

    Shared storage is no longer reserved only for large corporations. With ubiquitous Ethernet networks prevalent in most organizations, IT staff training costs for Internet Small Computer System...

    Posted by Mark Kaelin | July 30, 2007, 10:59 AM PDT

  • 1

    What you need to know about Cisco's Data Center 3.0

    Cisco has just unveiled its Data Center 3.0. Most of you have probably never heard of Cisco's Data Center versions 1.0 and 2.0. Even though I went to the Cisco Networkers conference last year, I'd...

    Posted by David Davis | July 26, 2007, 2:10 PM PDT

  • 5

    Shared block-level storage continues to become more accessible

    I considered entitling this post "Is storage becoming commoditized?" but the technical definition of "commodity" doesn't quite fit the bill. My question is this: Is the market for shared...

    Posted by Scott Lowe | July 25, 2007, 8:08 PM PDT | Latest comment by Scott Lowe

  • 7

    Round and truncate dates in Oracle

    Oracle's TRUNC and ROUND functions apply to date and time values as well as to numbers. Here are some examples of date manipulation using these Oracle functions.

    Posted by Bob Watkins | July 24, 2007, 8:34 AM PDT | Latest comment by Diganta77

  • 2

    Installing and Configuring MOM 2005 w/ SQL Server Part II

    In my last blog, we discussed, how to configure a virtual environment, install, and begin to configure MOM 2005 to monitor SQL Server. This blog will continue where the last one left off. We will...

    Posted by Steven Warren | July 23, 2007, 12:30 PM PDT | Latest comment by gulzar.elavia@...

  • 2

    Partition switching in SQL Server 2005

    Tim Chapman demonstrates how you can modify defined partitions in SQL Server 2005 so that you can easily and efficiently add new data.

    Posted by Tim Chapman | July 23, 2007, 11:21 AM PDT | Latest comment by victtim

  • 0

    Installing and Configuring MOM 2005 w/ SQL Server

    In this blog series, you will learn the basics of installing Microsoft Operations Manager 2005 as well as how to use MOM to monitor SQL Server. This article takes advantage of virtualization. We...

    Posted by Steven Warren | July 18, 2007, 11:53 AM PDT

  • 3

    Apply the D.I.C.E framework to determine your best backup server solution

    Your company's data is important, but how well do you protect it? What would happen in case of a fire, or if an employee accidentally (or purposely) deleted a large amount of data? You need a...

    Posted by Joshua Hoskins | July 18, 2007, 10:25 AM PDT | Latest comment by rvk@...

  • 0

    Compute the percentage of a total with Oracle's RATIO_TO_REPORT

    Computing a percentage of the total report usually requires a subquery. Oracle's RATIO_TO_REPORT analytic function does it in one step.

    Posted by Bob Watkins | July 17, 2007, 7:11 AM PDT

  • 7

    Creating table partitions in SQL Server 2005

    The typical usage scenario for a partitioned table is one that is very large and is experiencing degrading performance over time. Tim Chapman walks you through the steps of partitioning a large...

    Posted by Tim Chapman | July 16, 2007, 7:18 AM PDT | Latest comment by philip.grogan@...

  • 3

    Moving the Tempdb and Master Database in SQL Server

    There have been many occasions where I found it necessary to move the database and log files to different drives to increase performance. When you want to move a typical user database to a...

    Posted by Steven Warren | July 13, 2007, 3:00 PM PDT | Latest comment by teeeceee

  • 0

    SQL Backup

    I recently had the opportunity to work with a piece of software for my SQL Server backups. The product is called SQL Backup and it is made by Red Gate Software. With SQL Backup, you can perform...

    Posted by Steven Warren | July 11, 2007, 9:15 PM PDT

  • 0

    Copy Oracle's Automatic Storage Management files with DBMS_FILE_TRANSFER

    Oracle's Automatic Storage Management (ASM), introduced in Oracle 10g, provides an alternative to raw disk devices for storing Oracle-related files. Like raw disks, ASM volumes (called diskgroups)...

    Posted by Bob Watkins | July 10, 2007, 3:31 PM PDT

  • 6

    This is the year of the network attached storage device

    Network attached storage is quickly becoming a mainstream, small office, and dare I say it, consumer device. With the growing popularity of digital music and video comes a growing need for safe...

    Posted by Mark Kaelin | July 9, 2007, 2:15 PM PDT | Latest comment by castleon@...

  • 7

    Solid state drive storage: Good for the enterprise?

    Over the years, the good old magnetic platter has undergone many changes that have made hard drives a commodity and drastically driven down the cost of storage. Today, storage costs anywhere from...

    Posted by Scott Lowe | July 3, 2007, 10:40 AM PDT | Latest comment by ryanray@...

  • 0

    How do I... Query foreign data using SQL Server's linked servers?

    This information is also available as a PDF download. If you have a magic wand or a special relationship with some data fairy, all of your data is in the same database on the same server. Most of...

    Posted by Susan Harkins | July 2, 2007, 12:47 PM PDT

Keep Up with TechRepublic

Discover more newsletters

Follow us however you choose!

Media Gallery

View All

Hot Questions

Ask a Question
View All

Hot Discussions

Start a Discussion