sayfrend,

Thanks for the license update. That must be a change from previously.

I think Google is just as bad as Microsoft has been, but I also think that this is the way most companies behave as they get successful. People want to...

I tend to agree with Jefferey here, but I'd say that you want to standardize so everyone knows in a DR situation which data to restore.

If there is non-SQL data...

You'd need to log from the plan, not the job. The job doesn't log enough.

The big thing with remote backups is that any hiccup in the network will fail it....

Something like this:

Select POBuyersItemKey

, substring( POBuyersItemKey, 1, 7)

, substring( POBuyersItemKey, 8, 1)

, '5967241' + '|' + '19-62006-9-20'

from ISFfactory

order by POBuyersItemKey

Be...

I read that gem. Had to read it twice to be sure that I wasn't misreading things.

Shaking head here all the while. Some days I think I should just go...

Here's the thing. You can use a hash to try and determine if you have a duplicate. Not for encrypting.

What I'd suggest is that you use a separate column...

[drive by post]

I'm lost again

[/drive by post]

Try also printing out the intermediate values. Either with PRINT or a SELECT to your query results. It will help you figure out what's being compared. You can also...

I think MS found it easier to say "varchar" rather then "charvar"

jay holovacs (5/28/2009)

......

SELECT * is typically resolved at compile time, and expanded to be the columns. So over time, if you've modified the schema, and a plan exists, this might not return...

AFAIK, you cannot create an instance programmatically using SMO. The setup program for SQL Server has to run, which is what VS does. It has a setup file set that...

Use the data import wizard to set up a basic package. From there, you can add to it.

there are lots of SSIS articles here on the site (http://www.sqlservercentral.com/Articles/SSIS) as well...

When someone said they ran the SQL, I said with the corrected question they couldn't get those results.

The newsletter is what the question goes out as, but it could potentially...