Jonathan Kehayias (5/1/2011)

---

Jeff Moden (5/1/2011)

---

Solomon Rutzky (4/30/2011)

---

Jeff Moden (4/29/2011)

---

I know little about deploying CLR's so please bear with me. Does the creation of the Asymetric key make it so...

Jeff Moden (4/29/2011)

---

I know little about deploying CLR's so please bear with me. Does the creation of the Asymetric key make it so that a low privileged user can...

Jonathan Kehayias (3/22/2010)

---

Ron Jennings (3/22/2010)

---

Jonathan,

This function is exactly what I was looking for as part of a SQL Server Disaster Recovery solution I'm developing. The only additional thing I would...

Todd M. Owens (4/27/2011)

---

...if a table only allows inserts in a version type approach, there is no reason to add columns that capture UpdateDate and/or UpdateUserID. If a table's...

mar10br0 (4/27/2011)

---

That is because the new table and its constraints, indexes, etc, although...

Hi Todd. ...

ModestyBlaise84 (4/26/2011)

---

Every change made in the production database should be considered as a release.

For example, adding a trigger could affect performances and should be planned ahead, tested, released, monitored.

Where does...

mar10br0 (4/26/2011)

---

Great article Solomon!

I do however avoid triggers like the plague in production-code as a principle...I much more take rbarbati's approach in an earlier reply-post, for this I prepare ALL...

rbarbati (4/26/2011)

---

Good article, great topic.

I agree with the use of change tracking in 2008, and would add that triggers are not always straight forward. You must consider referential integrity, cascading...

Amol Naik, Jason AKA CirqueDeSQLeil, and belgarion:

Thanks! I'm glad you enjoyed the article. 🙂

Take care,

Solomon...

Todd M. Owens (4/26/2011)

---

Compliment: great article.

Caveat: If you are in a Microsoft technology-only shop with .NET, C# and other such technologies then no worries. Otherwise be careful with using non-ANSI...

noeld (4/26/2011)

---

The article was well explained and straight to the point.

The title on the other hand is *VERY* misleading (seconds?) Apparently you don't count the time you spent setting AND...

jvrakesh-858370 (4/26/2011)

---

This is a very good article . My Client here would do enahancements to the application frequently and I end up adding columns to the table with over...

Hello. The amount of time it takes to...

Luke C (4/26/2011)

---

Solomon, this is a great post and thanks for sharing! Just this last week I took a similar approach with 4 large tables that had multiple columns...