rexbaldazo, Author at TechRepublic

rexbaldazo

Latest from rexbaldazo

Data Management

Using SQL Server 2005 Integration Services variables from a Script Task

While it's not the best documented feature out there, it's actually pretty easy to use SQL Server 2005 Integration Services variables from within a Script Task. Here's a quick step-by-step example to get you started.

Data Management

Creating variables in SQL Server 2005 Integration Services

Creating and consuming variables in SQL Server 2005 Integration Services isn't always easy. But it's a powerful capability worth learning if you're planning to make the most of this powerful ETL tool.

Storage

What bargains did you find at CompUSA?

Many CompUSA stores had their final sales within the past week or two. Did you go and, if so, what deals did you pick up?

Project Management

How my memory of Ada code influences my current .NET code

Our early programming experiences influence us in so many ways. For instance, my previous experience with Ada rendezvous shaped the .NET concurrent code I wrote just this past week.

Data Management

SSIS has a strange little bug with set rowcount

SQL Server 2005 Integration Services (SSIS) has a strange little bug that ignores "set rowcount" but accepts "top xx" syntax. It's a little annoying, but if you know it's there, you can work around it without too much effort.

Data Management

SQL Server 2005 Integration Services makes a good first impression

You never get a second chance to make a first impression. This aphorism applies to so many things — dating and job interviews come to mind. It also applies to software, which I was reminded of when I got to use SQL Server 2005 Integration Services (SSIS) for the first time last week. It was ...

Open source

Installing Oracle on Linux is too difficult

Even though I’m not working in an Oracle environment any longer, I still want to maintain and expand my Oracle skills. Since I don’t have a company-sponsored Oracle database to use now, I needed to set up an Oracle database myself. I thought I’d use a Linux box for Oracle but, after struggling with the ...

Tech & Work

Is it okay to pronounce URL as a single syllable?

Rex Baldazo asks: Is it common practice to pronounce URL as "Earl," or is it more common for people to spell it out as U-R-L when they talk about a URL?

Developer

Handling HTML multi-selects in PL/SQL

Dealing with HTML multi-selects in Oracle’s PL/SQL is a bit trickier than I’d like. Depending on how many items the user picks out of the multi-select, you either get back a simple VARCHAR2 object or a special array object. This means you have to write two separate methods to deal with the two cases. Let’s ...

Developer

I can’t get a zero-length string in PL/SQL

One of the things I wind up doing a lot in my code is looping thru some data structure — say an HTML option list or a SQL result set — and concatenating the results into a single string so that it can be printed to a text file or an HTML stream. I often ...

PURPOSE This Media disposal policy from TechRepublic Premium provides specific instructions for ensuring organization data is properly protected when disposing of old storage media. From the policy: POLICY DETAILS When disposing of damaged, unusable, obsolete, off-lease, decommissioned, old, or end-of-service-life equipment and media, the organization requires that the guidelines outlined herein be followed: Hard drives, ...

PURPOSE To take some of the effort out of writing (and rewriting) emails to share with company staff and executives, TechRepublic Premium has assembled basic templates to handle the most common types of communications. Simply copy the text into your favorite word processor and customize it to fit your needs. Then, paste it into an ...

PURPOSE The purpose of this policy from TechRepublic Premium is to provide guidelines for developing mobile applications from a security, procedural and best practices standpoint. While it contains technical guidelines, it is not intended to serve as a programming guide but as a framework for operations. This policy can be customized as needed to fit ...

rexbaldazo

Using SQL Server 2005 Integration Services variables from a Script Task

Creating variables in SQL Server 2005 Integration Services

What bargains did you find at CompUSA?

How my memory of Ada code influences my current .NET code

SSIS has a strange little bug with set rowcount

SQL Server 2005 Integration Services makes a good first impression

Installing Oracle on Linux is too difficult

Is it okay to pronounce URL as a single syllable?

Handling HTML multi-selects in PL/SQL

I can’t get a zero-length string in PL/SQL

Media disposal policy

IT email templates: Upcoming software release

Mobile app development policy

New client audit checklist