i agree with the comment above. merge statement is fabulous. you got your data instaging with a bulk load insert. then you can handle updates, deletes and inserts the way...

You can use the data flow plus component from cosyrock.

If you only use on BIDS (and not on sql server agent) it is free. You can then do true ETL...

I also agree with Jeff. I would not take any risk at the data tier. Your data constantly changes and it is your main dependancy for your applications to work....

jorge.rodriguez (2/1/2011)

---

When I try to partner the principal to the mirror I get the error:

The server network address "TCP://<server>:5022" can not be reached or does not exist. Check the network...

sireesha.budagala (2/1/2011)

---

How Can we modify the Login permissions on SQL Mirrored Database ?

for ex : 'abc' is the Login we need to reduce the level of permission from 'db_owner'...

This is a very nice little introduction by this article lacks of several issues that should be looked at.

- certificate authentication

- mirroring replication

- linked server failovering

- job failovering

I had the...

I do understand that everything handled properly will not alter too much performance but I do not think the use of triggers is a good practice. I prefer ETL/asynchroneous processes...

Hello,

The article is interesting but I believe we have to avoid triggers at all price for performance and maintainability reason. I usually put a timestamp or datetime column like ModificationDate...

Excellent article!

Thanks for your feedback on my two remarks.

I think we are on the same page as you enable then disable xp_cmdshell.

When I meant within the line, I was referring to...

Hello,

I might have read the article too quickly. So I apologize if I miss some information.

The methodology you are taking is very similar to the methodology in place at my...

I feel the article is actually pretty poor. All the dbas know this kind of dynamic sql.

Someone suggested recompile and with (optimize) option and he is spot on!

I was able...

Very interesting. I alrady use cross apply (mostly with table-valued functions) and I use a lot of xqueries. I like the last t-sql code about xquery. I was not using...

I have performed recently a PCC-DSS Sql server audit and one of the best practice on the list was to avoid distributed transactions.

therefore if your industry requires stringent security rules,...

When I deployed the code, the linked server was not recognized (the name of my server is ServerName\Instance1.

It seems that the code does not work with named instance.

I set...