There is an SDK for SQL Compare from Red Gate. The other tools might have one as well

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

Disclosure: I work for Red Gate.

In terms of LS/Repl/Mirror, the OP doesn't look...

Media/format is a big deal. I didn't cover it, but I've tried to set archive files as CSV so that they can easily be converted later.

Are there delimiters? Really you need to just find the logic that will allow you to find the fields. Are they are certain positions? Or do they come after a...

First I'm confused why you would want to use a cursor? SQL Server isn't very efficient with cursors and this seems like it could easily be a set based solution.

create...

I'm not sure what you mean with user column. You add a user to your database. You can then assign this user rights, or map them. In SQL 2000, you...

The buffer pool is managed separately for each instance, so if you have separate instances (check your licensing before you decide on this), you can assign xx memory to each...

I would like to get back to the Columbus SQL Saturday, but it will depend on my schedule over the next month. Already life is busy, and not sure I...

As Craig mentioned, everything goes through the transaction log. That's how database consistency and ACID is enforced. There are tricks to minimize the impact, but depending on what you are...

You should be able to remove the db_owner role from the user. Is this just a "change permissions" thing?

Does this user own the database? You can use T-SQL to change...

Good advice from Grant, but I might argue that the code and work being done in development is important and it's a "kind of production" level of stuff that you...

Haven't seen much written on RAId 50. I suspect it suffers the same write penalty that Raid 5 has.

Raid 5 worked well for me for years, and continues to do...

In addition to what Craig said, you pay for bandwidth, so factor in the cost of doing a backup, deploying code, testing on Azure, etc.

The "savings" might not be anywhere...

Congrats, Grant, and thanks for all the help over the years.

rmaw-1095848 (2/16/2011)

---

This is scare mongering. Exactly how is a "breach" detected? A system sophisticated enough to be able to detect illegitimate access is most likely set up properly to prevent...

WayneS (2/13/2011)

---

Are any Threadizens going to SQL Saturday #69 (Philadelphia) on March 5? I just read the email where my presentation has been selected to be presented! :w00t::w00t::w00t:

I'd love to...