SQLServerCentral.com ArticlesArticles posted on SQLServerCentral.comDefining cascading referential integrity constraints in SQL Server- June 20, 2008 By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.http://www.sqlservercentral.com/redirect/articles/63392/ Best Practices for Database Design- June 20, 2008 One of the few things that SQL Server does not automatically help you with is the design of your tales, views, and other database objects. Having standards and design techniques can greatly ease the maintenance of your schema as well as ease the transition to having others work with the database. New author J.D. Gonzalez brings us some of his naming techniques to keep things organized.http://www.sqlservercentral.com/articles/Naming+Standards/bestpracticesfordatabasedesign/1... Startup Weekend in Ann Arbor, MI, June 20-22- June 20, 2008 Calling all developers! Does the idea of going from a concept to a prototype in a 54 hour marathon weekend of design and coding sound fun to you If so, join us!http://www.sqlservercentral.com/articles/User+Groups/63414/ Introduction to XQuery in SQL Server 2005- June 20, 2008 This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features.http://www.sqlservercentral.com/redirect/articles/63190/ Scripting Trace's for SQL 2005- June 19, 2008 How to Script Traces for SQL and Analysis Serviceshttp://www.sqlservercentral.com/articles/Profiler/63097/ SQL Server 2005 Build List- June 19, 2008 Build List Updated with Cumulative Update 8 for SP2.http://www.sqlservercentral.com/articles/Administration/2960/ |