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.
  • 44

    Speed up SQL Server database queries with these tips

    If you've worked with SQL Server databases for any amount of time, it's practically a given that you've run into slow running queries. Sometimes the reason for the slow response time is due to the...

    Posted by Tim Chapman | September 10, 2007, 11:06 PM PDT | Latest comment by ravishakya

  • 4

    Use host-based replication to keep data available

    One of the challenges for any IT department is to keep data available for those who need it. In fact, vendors and consultants have built whole businesses around the concept. Over the next few...

    Posted by Damon Howell | September 6, 2007, 7:42 AM PDT | Latest comment by daveb@...

  • 31

    Defragment your Windows Server 2003 hard drive on a set schedule

    You can defragment the hard drives on your Windows Server 2003 boxes on a set schedule by simply creating a batch file to defragment a drive and setting up a scheduled task to execute it.

    Posted by Derek Schauland | September 4, 2007, 12:00 AM PDT | Latest comment by sancretor@...

  • 7

    Understand when to use user-defined functions in SQL Server

    In the simplest terms, a user-defined function (UDF) in SQL Server is a programming construct that accepts parameters, does work that typically makes use of the accepted parameters, and returns a...

    Posted by Tim Chapman | September 3, 2007, 11:49 PM PDT | Latest comment by pixelwiz

  • 24

    Talking intelligently about virtualization

    Virtualization is being thrown at us from all directions. All the major vendors are moving into this arena: VMware (an EMC company) is not alone anymore. Just in case you need a refresher, a...

    Posted by Steven Warren | August 29, 2007, 9:00 AM PDT | Latest comment by Neon Samurai

  • 1

    What is your SQL Server backup strategy?

    Most database administrators (DBAs) know what it's like to be called away from home or dinner or even awakened in the middle of the night to answer a page or a cell-phone call concerning some type...

    Posted by Steven Warren | August 28, 2007, 9:00 AM PDT

  • 5

    Passing table valued parameters in SQL Server 2008

    SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer...

    Posted by Tim Chapman | August 27, 2007, 12:47 PM PDT | Latest comment by joshgeake

  • 0

    IIS 7.0 and Windows Server 2008

    Over the years, Internet Information Services (IIS), Microsoft’s flagship web server product, has taken a lot of flack for being hacked and compromised. But with Windows Vista finally released,...

    Posted by Steven Warren | August 27, 2007, 9:00 AM PDT

  • 0

    Building a Windows 2003 Cluster

    Microsoft has overhauled Windows Clustering Services to meet the greater demand for high availability and scalability that has come with the increased spread of the 24/7 marketplace. I'm going to...

    Posted by Steven Warren | August 26, 2007, 9:38 PM PDT

  • 0

    How Do I... Restore a SQL Server database to a new server?

    As a DBA, I have been in many situations where I had to move databases to a new server due to old hardware, failed hardware, failed drives, etc. You have two options you could use to carry out...

    Posted by Steven Warren | August 25, 2007, 7:58 PM PDT

  • 1

    Monitoring SQL Server Performance

    In Windows, you can monitor your system performance by using the Performance monitor console and its related counters. These counters allow you to view or save information about the overall...

    Posted by Steven Warren | August 25, 2007, 6:36 PM PDT

  • 0

    What data do you really need at your disaster recovery site?

    For a company creating a disaster recovery plan, one of the often overlooked issues is how much data you really need at your DR site. The easy answer is all of it, but this means that your company...

    Posted by Damon Howell | August 21, 2007, 7:01 AM PDT

  • 1

    Use virtualization to reallocate storage assets

    I sometimes mention specific products in my writing about storage topics.  But, believe it or not, none of the vendors pay a penny for my thoughts.  I tend to write about things I know and I've...

    Posted by Scott Lowe | August 20, 2007, 9:11 PM PDT

  • 0

    Write custom trace files in TSQL

    SQL Server 2005's default trace is great for monitoring system information and for finding out what happened on your server after problems occur. However, there are times when the events that the...

    Posted by Tim Chapman | August 20, 2007, 12:48 PM PDT

  • 0

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

    This blog post is also available in PDF form as a TechRepublic download, which includes the sample Excel D.I.C.E. worksheet. Your business has grown to the point where a few file shares on your...

    Posted by Joshua Hoskins | August 17, 2007, 8:32 AM PDT

  • 1

    More data isn't always a good thing in text mining

    In text mining it seems obvious that we should use all the data we can get our hands on for use in drawing conclusions. The temptation is always to use the broadest possible query to select the...

    Posted by Scott Spangler | August 15, 2007, 5:25 AM PDT

  • 1

    Monitor system information with SQL Server 2005's default trace

    Sometimes it is difficult to diagnose problems on your SQL Server after they have occurred. So find out why you should use SQL Server 2005's default trace feature to monitor certain events....

    Posted by Tim Chapman | August 13, 2007, 2:55 PM PDT

  • 7

    Streamline your data management with deduplication

    The concept of deduplication is simple - it's creating a single copy for all the duplicate bits or files that exist on a network. But how does it actually work and how do you use it? A little...

    Posted by Damon Howell | August 13, 2007, 12:37 PM PDT | Latest comment by damone@...

  • 14

    What kind of reliability can you expect from flash/solid state storage?

     How reliable will your flash or solid state storage device remain over time? This is the question I'll be exploring here, along with the basics of how these devices actually work. (I use the...

    Posted by Scott Lowe | August 10, 2007, 6:41 AM PDT | Latest comment by Absolutely

  • 2

    Practice using Oracle's Remote Diagnostic Agent before you need it

    Oracle provides a tool called Remote Diagnostic Agent that documents your Oracle installation. Becoming familiar with this tool before you need it can save time when you work with Oracle Support.

    Posted by Bob Watkins | August 7, 2007, 6:34 AM PDT | Latest comment by Gr8DBA2@...

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