I've done a couple of projects where we upgraded Access to link to SQL server.  I would not do it again.

With .Net click once deployment I would just code the...

"This would be like the Republican National Committee (RNC) purchasing CNN."  Or the DNC buying Fox.

Bias in media is something that we have been fighting in the US for a long...

Congrats to you three.  It's good to see people make some serious green from something that they love.  That's the good side - just don't wind up like Wally Amos.

Thanks...

In the days before good databases were avaialable for PC's I was having to retrive data from random files in an ordered manner.  We used bianry files to store the...

Great article Joe.  Thanks a bunch.  Your take on extent switching was new to me.  I'm in hopes that the rest of your series will help clear up a mystery...

Thanks Brian.

I had looked at that last week.  Good article.  Unfortunately SCPTXFR is not part of 2005.  I tried to move it to my 2005 box but it is tied into...

You said "although it appears to be missing in SQL Server 2005 beta."  While that might be true it seems to be missing from the release version as well.  Could...

I'm in the enviable position of being both a developer and DBA.  For CREATE TABLE you should not have much of a problem.  We have to do our replication...

1. Create new tables for the import. Naming convention is important.
2. Do the import
3. Check the import
4. Drop old tables
5. Rename imported tables

If the thing fails then you just drop the new tables and wait...

You can do this in your app.

1. Encrypt the data using your approved algorythm.  This will likely result in binary data even if the original data was all  text.
2. Use BIN-64 to...

Hi Web,

You don't say how you are running your OSQL command.  You can always pipe the output of OSQL to a file and run something to analyse the output.

Too bad...

We get lot's of "requests" during our career.  Complying with those requests may put one in a touchy situation.  Ethics!  I had a high placed indivdual tell me that there...

You asked: "Which method is best in terms of efficiency and ease of maintenance of the list?"  The key word is "best".  Best for whom?

What skill set does the person,...

Hers is a plan.

1. Prepare a snapshot
2. Use that to extract historical data to permanent media.
3. Off-line the extract.

In this way the snapshot acts like it should.  A "freeze frame" of the database...

I agree with Stephen too.  I also agree with you.

GOTO's served a purpose for a time but got misused and the misuse was what was actually bad.  Same thing for...