Package Configuration files kinda suck. You're much better off using environment variables for configuration - no issues with the deployment. That's what I did. 🙂

IceDread (4/10/2012)

---

SpeedRoush (4/9/2012)

---

In case you didn't know, when i went to mass on Sunday the priest said the bunny rabbit was the first to see Christ when he was Resurrected...hence...

Good article, but rather obvious (who would have thought - automate 🙂 )

One sentence that has value to me is: "The key thing with automation contrary to typical DBA practices...

Elliott,

The error that ingoba.ningthouja might be getting (and I am getting) is "the file ... already exists". This happens during build when CreateDeploymentUtility is set to true, and 2...

Bob,

A multi-value parameter doesn't allow for the value to be typed in. I actually don't know of any type of parameter that does. Is there one? Tx.

?

What would a treshold (in the number of index pages), below which we should not worry about fragmentation and don't have to rebuild?

"Reserve 1 Gigabyte (GB) of RAM for the Operating System (OS)"

Are you sure? Shouldn't it be 2GB?

Can you provide an example of such expression? Tx.

Steve,

How would you do this if you needed to loop through a list of TABLES and copy data from each table to a table with the same name in another...

Thanks. I again lost hope to capture the query that caused blocking in...

Jonathan,

I've received the below for the blocked process:

<inputbuf>

Proc [Database Id = 14 Object Id = 1311948665] </inputbuf>

</process>

This is a stored procedure that doesn't touch the...

Use...

Agree and disagree: 🙂 🙁

"repetitive tasks, or as in the case of CmdExec, any task that leaves the SQL Server environment is much simpler from the PowerShell subsystem.

Disagree:

Any repetitive SQL...

- Cool.

ALZDBA (12/29/2011)

---

- granting auth at windows level ( e.g. to push backup files...