Great article. The best ones tend to fire off the most discussion

You can avod the stored procedures. They add complexity without a positive.

I took a more brute force...

Great article.

Your kidding though. The FTP task is smart enout to keep the connection open because I might want to send more files in the same SSIS session. ...

Obs (1/17/2012)

---

I'm not a fan of this. Aside from it being a maintenance issue (editing the SSIS package every time a new folder is needed or removed), you could...

I have a client on R2 so:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard...

You said; "Aren’t we all destined to have so much uncategorized stuff and as long as we limit it to one drawer, does it matter?"

So, getting back to database design,...

I confront the "Universal Hammer" syndrome. "If all you have is a hammer everything looks like a nail." Much as I love it not everything is a SQL...

Letting someone else...

So OLE DB is going away. Yet you have said nothing about ODBC going away. If I were to set up an ODBC connection to one of my...

Good article and points well taken. I just could not resist:

Funny you should mention this. Not long...

I agree with points from both Nadrek and TravisDBA.

Right on with having to hold for legal reasons. I got that. Many of my customers are food producers or...

I get wrapped into a tight loop on this subject. As an industry we have data retention rules and regulations, either on us directly or the customers we serve....

Wow!

Has it been that long?

Well like the frog said:

You mentioned specifically "Postnet" barcodes. There is something that you should no about barcodes.

Many times the symbology (what type of code the barcode uses) does not matter. Modern...

Great article and series.

I am curious though. You use "Description" and SSMS for columns uses "MS_Description". Is that because you are intending the article to be a teaching...

Another trick is to set up a Generic/Text Only printer on your PC and redirect that to a file.