- Subscribe to this page:
- RSS
- Email Alert
rex baldazo
(51 results)-
Blog Post
Using SQL Server 2005 Integration Services variables from a Script Task
April 28, 2008 5:51pm PDT
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...
4 Latest comment by vkg4093
-
Blog Post
Creating variables in SQL Server 2005 Integration Services
April 14, 2008 6:34pm PDT
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.
2 Latest comment by tish.whalen@...
-
Blog Post
What bargains did you find at CompUSA?
March 6, 2008 8:35pm PST
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?
38 Latest comment by Blackbeagle2
-
Blog Post
How my memory of Ada code influences my current .NET code
March 2, 2008 6:28pm PST
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.
3 Latest comment by mark.peterson@...
-
Blog Post
SSIS has a strange little bug with set rowcount
February 25, 2008 7:44pm PST
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...
6 Latest comment by nmcdermaid@...
-
-
Blog Post
Installing Oracle on Linux is too difficult
February 12, 2008 3:37am PST
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...
144 Latest comment by KamranAgayev
-
Blog Post
Is it okay to pronounce URL as a single syllable?
January 27, 2008 9:29am PST
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?
216 Latest comment by mlleeder@...
-
Blog Post
Handling HTML multi-selects in PL/SQL
January 19, 2008 8:23am PST
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...
3 Latest comment by kayhan.yuksel@...
-
Blog Post
I can't get a zero-length string in PL/SQL
January 13, 2008 12:54pm PST
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...
9 Latest comment by lgood58@...
-
Blog Post
A little JavaScript + Google Charts = quick pie charts
January 5, 2008 6:42am PST
See how TechRepublic blogger and self-confessed political junkie Rex Baldazo whips up a CNN-style pie chart using JavaScript and the Google Chart API.
11 Latest comment by Brett.Blatchley@...
-
Blog Post
My Christmas wish is more open source for programmers (and an ultralight MacBook for me)
December 21, 2007 3:43pm PST
I haven't posted to this blog for a few weeks mostly because I've been slammed at work trying to help stabilize our Oracle Portal system that kept crashing every few days. We appear to have gotten...
50 Latest comment by apotheon
-
Blog Post
Poorly written LDAP code can really affect your Portal
November 30, 2007 4:22pm PST
If you have an LDAP newbie write a lot of your LDAP code, you should have somebody with real LDAP experience audit the code. The potential performance benefits are tremendous.
2 Latest comment by RexWorld
-
Blog Post
Configuring SQL Developer for MySQL
November 27, 2007 5:56pm PST
I rant against Oracle products a lot in this blog, but I have to admit I actually like a few of their products. One of them is SQL Developer. Strangely though, the feature I kind of like best is...
4 Latest comment by MariposaLibre
-
Blog Post
Setting up a bbPress dev environment with XAMPP
November 19, 2007 6:28pm PST
When Rex Baldazo recently tried to put the latest release of bbPress software on his OraclePortalSucks.com site, the upgrade failed. He walks you through the steps he took to create a fully...
2 Latest comment by RexWorld
-
Blog Post
Blogs Oracle developers should bookmark
November 12, 2007 4:38pm PST
Check out Rex Baldazo's favorite Oracle-related blogs. He says that sometimes these blogs are much more useful than Oracle's own documentation.
8 Latest comment by meusman
-
Blog Post
Sometimes a variables table is better than hard coding into a package
October 31, 2007 3:39pm PDT
When writing PL/SQL packages, there are times where it's better to store a variable in a table instead of coding it into the package. It's most useful for a variable that you might want to change...
19 Latest comment by Jaqui
-
Blog Post
A surfeit of caches
October 23, 2007 3:28pm PDT
A cache is useful in theory. By storing a temporary copy of some page or image, the servers can deliver it faster to the client computer. But if you've ever been stuck trying to debug a problem...
2 Latest comment by Justin James
-
Blog Post
Switching Oracle Portal to a new database is easier than Oracle Tech Support says
October 15, 2007 4:48pm PDT
If you do not have to support an Oracle Portal, consider yourself lucky. We recently ran into a problem that forced us to quickly move to a new metadata database. Once again, the lousy Oracle...
5 Latest comment by Justin James
-
Blog Post
Should I make Google part of the programmer's interview?
October 9, 2007 6:15pm PDT
I've noticed lately that even though everybody in IT uses Google, not everybody knows some of the quick basic tips that can really help when trying to zero in on the answer to a particular search....
16 Latest comment by Justin James
-
Blog Post
Sending blob attachments in e-mail with utl_smtp
September 30, 2007 5:48pm PDT
Last time, I showed how to send an HTML-formatted e-mail from an Oracle PL/SQL application using utl_smtp. I promised I would extend the package a little with a second method that allows you...
20 Latest comment by han_helmy
