Thanks, Mevio is having issues. I have pinged them.

I need a filter to whack multiple embedded quotes. It can be quite annoying.

you can use SQLCMD to connect to another server and export data, OPENDATASOURCE, or use SSIS to pull data over.

I thought I heard the 2012 certs would be released this year, but I'm not sure.

However Koen has a good point. If SQL Server 2012 is released in April (guess),...

Wow, excellent writeup. Nice rules of thumb as well.

Stephanie J Brown (1/30/2012)

---

I'm not sure I agree with the "companies who would use it don't need it; companies that need it would abuse it" philosophy that some have expressed....

Not that I know of. Named pipes is usually used for local connections. It's not listed as deprecated in the R2 docs: http://msdn.microsoft.com/en-us/library/ms187892.aspx

DO NOT POST HIPAA controlled information on the site. I have deleted the spreadsheet.

If you are seeking help with something from your work, you must use made up data, not...

And is the job running on the schedule and failing? Or just the one failure?

Are you sure the schedule is recurring?

It's not quite clear what your deployment is. And how this locks things.

If you're changing schema, then there's a lock while schema is altered. Most changes can flow through replication,...

I thought the API was included, but it's separate.

There's an SDK

http://www.red-gate.com/products/sql-development/sql-comparison-sdk/

1) I'd use the same database for all customers. If customerA has feature X and customerB has featureY, use separate tables. That way you can easily "turn on" features for...

What I do is more work to setup, but it works great, and handles failures of servers better, IMHO.

I have a db on each instance which is standard. It collects...

Don't use named pipes. Used TCPIP

Reference fixed.