SQLCAT Blog: Managing Schema Changes (Part 2) Question: What are best practices for managing schema changes in SQL Server 2005? What are the fastest, least intrusive techniques for high availability? Answer: In Part 1, we outlined the behavior of SQL
Read More...
Another pattern that can cause too many round trips to the database is when each object is treated as a black box and is responsible for retrieving and saving its own data. This by itself is not the problem; it’s when the object hierarchy reaches three
Read More...
Question: What are best practices for managing schema changes in SQL Server 2005? What are the fastest, least intrusive techniques for high availability? Answer: A common requirement as business requirements evolve over time is managing schema changes.
Read More...