Recent content by HogHunter

Unfortunately, I needed to fix that domain so I moved the DNS to another DNS server that I knew was working. With that in mind, I do have a similar domain that is not working, SEEMUG.COM. It is managed via the same DNS server that the other one was. By the way, thanks for the input.

Last night my hosting facility changed backend providers. I got a slew of new IP addresses. Well everything is working fine for those Domains that are not being managed on my internal DNS machines. The ones that I have on my DNS timeout before responding. I checked and if I directly query...

Yes it does, my question / problem is where does the behavior for error handling occur? Is it configurable? If so, how? I ave search a large number of books on this topic an not found one that addresses database mail much further than how to configure it out of the box. I have it going with...

I have setup database mail on my SQL 2005 server. It works fine. I am using it to send subscription mail. If the email addresses are good, it works fine. If there is a bad email address rather then skipping that email address, it shuts down and quits the rest of the process. Is there a way...

I am trying to install Apache / Perl / PHP and MySQL on my Windows machine. I am trying to follow the instructions I found at http://www.ricocheting.com/server/index.html but I can't get past the perl install. When I try to load the printenv.pl file, I get errors that say: The system cannot...

I totally agree with the concept of using surrogate keys (SKs). We use them exclusively but only on the dimensional side. In the facts, we combine the SKs to make up the primary key (PK). We never, ever use natural keys as primary keys on the warehouse. I guess I didn't make that clear. It...

I agree that you ought to look at your transaction log whenever performance suddenly changes. How large are the tables you are copying? Are you copying the entire table or selected rows? You may want to do a two phase process for moving the data. Many ETL products work this way. Export the...

Before you judge MySQL too harshly look at the book MySQL Enterprise Solutions. It discusses how some very large organizations are effectively using MySQL for their enterprise level servers. I am a MS SQL fan. I am a MS parner and I support many MS SQL implementations. So don't take this as...

Can you determine how the data is being queried? Look in the .ASP files a see if you can find a "SELECT" statement. If you can, is there a ORDER BY clause? If so, you can change the sort order by altering the ORDER BY clause. Otherwise, it may be that the ASP page is calling a stored...

Both Query Designer and Query Analyzer offer you opprotunites to screw up. :-) Unless you are issuing commands you do not know about you should be ok in Query Analyzer. Especially if you stick to SELECT statements. The benefit of using QA is that it forces you to write the statements and...

From a design perspective, I would recommend that you store NULLs not blanks so the data can be ignored.

We have a star schema data warehouse that has an order fact that we update nightly. We use the natural key from the source (Order Number) to locate the fact row and apply changes. The source system is preparing to purge old orders so they can reuse order numbers. They will maintain a table...

John Herman I agree with your assessment, having said that, do you see any issues with the design? Thanks again, Thom

Anand, Thanks again for your reply. I don't know that I agree with your definition of a conformed dimension. Laura Reeves, who co-authored Kimball's The Data Warehouse Lifecycle Toolkit gives the following definition in her class at TDWI: Conformed Dimension - A dimension that is shared...

Anand, Thanks for you comments, I wonder why you say the solution I outlined implies there will no longer be a conformed dimension. In fact, that was the very reason I was willing to go through the effort. In the case of, the type 1 side, the dimension conforms to the type side because they...