http://www.ExtremeExperts.com This is the syndication feed for ExtremeExperts.com. Every software development project requires a proper build process for delivering a quality product. Generally, the build process involves many repetitive and time consuming manual steps. Automating these steps not only reduces time and resource utilization but also helps to implement other processes like Continuous Integration, nightly or daily builds. By this, you can always ensure a stable product at any point of time during the development.This article explores the new build automation tool "Team Build" from Microsoft and it explains how to use Team Build scripts to implement other processes, like nightly build and continuous integration. http://www.ExtremeExperts.com/Net/Articles/AutomatingTeamBuild.aspx Saravana Kumar Nov 25, 2006 Exception handling is critical to all applications for troubleshooting the unexpected problems in the application. Windows Communication Framework (WCF) provides several options for handling exceptions in WCF services. This article discusses these approaches and describes the advantages and disadvantages of each. The following options are provided to handle exceptions in WCF: Using returnUnknownExceptionsAsFaults, Using FaultException and Using IErrorHandler. http://www.ExtremeExperts.com/Net/Articles/ExceptionHandlingInWCF.aspx Saravana Kumar Nov 5, 2006 This article explains about a sample Application that demonstrates the capabilities of ASP.NET Whidbey. Sourcecode of this applicatin is also available with this article. http://www.ExtremeExperts.com/Net/Articles/DynamicWebApplication.aspx Saravana Kumar Nov 7, 2005 Most of us would have come across a situation where we need to display a custom message other than the error message from validators in the validation summary. For example, based on business logic check you need to display a message to the user. Already you have a validation summary in the page where you are displaying error message to the user, you might prefer to add your message to that validation summary. This faq explains about one of the way to achieve this. http://www.ExtremeExperts.com/Net/FAQ/DisplayCustomMsgInValidationSummary.aspx Saravana Kumar Jul 10, 2005 During application development, you might come across a situation where you need to write the same code repeatedly with just a few changes. VS.NET 2005 is coming up with a new feature called code snippets, which will help developers to insert code snippets from a snippet store into the program with just a few key strokes. http://www.ExtremeExperts.com/Net/Articles/CodeSnippetsPart2.aspx Saravana Kumar Mar 20, 2005 I have had a chance to talk on the new DMV's from SQL Server at various forums. And from time to time I have been a strong advocate that the DMV's actually expose more information than what we used to get in SQL 2000 from DBCC or other commands. Moreover, DMV's are quite open in their values rather than the conventional bit manipulation we were used to. Here is a classic example of DMV's where we show the query used to mimic sp_who2 output for user connections. http://www.ExtremeExperts.com/sql/Tips/sp_who2_Updated.aspx Vinod Kumar May 25, 2008 I have seen many articles about security and have seen customers get really paranoid when security breaches occur. Obviously, they have a valid reason to do so especially when the concern is about data security. In this digital aided world, everything boils down to just how can we keep our personal or company related data (which can be LOB data) in a secure manner and what are the tips and techniques we have in hand. This article will provides some of the guidelines and considerations for designing instance-level, database-level, and object-level security policies, and for defining security monitoring standards for instances and databases. Though not exhaustive, this will surely be able to form some starting base to work with in SQL Server. http://www.ExtremeExperts.com/sql/yukon/SecurityIn2005_1.aspx Vinod Kumar May 24, 2008 Though HDD prices have fallen well beyond imagination, archiving of data and keeping the database to a manageable size is a concern for all organizations. Storing obsolete data online reduces the performance of a database server. A well-designed archival strategy minimizes the performance problems that are caused by maintaining excess data. When designing an archival strategy, you should first determine how much data can be archived, then choose an appropriate structure for the archival data, and finally create a plan for archiving the data. http://www.ExtremeExperts.com/sql/yukon/ArchivingData.aspx Vinod Kumar Jan 2, 2008 With Part I as foundation let us take a step closer to other aspects to the storage system like what needs to be taken care when working with physical files, filegroups, transaction log design, SAN / RAID and more. We will cover as much as possible and let me highlight some of the best practices on the same lines. http://www.ExtremeExperts.com/sql/articles/StoragePractice2.aspx Vinod Kumar Sep 15, 2007 Database storage is one of the primary failure point in the database environment. Hence, making the storage architecture consistent and at the same time giving it maximum redundancy must be embedded within the design itself. When I call redundancy, I dont specifically say implementing anything specific to RAID or SAN or other mechanisms. Redundancy must be achieved given your hardware and budget currently in hand if it even means making just multiple backup copies at the simplest level. http://www.ExtremeExperts.com/sql/articles/StoragePractice.aspx Vinod Kumar Aug 10, 2007