Friday, March 30, 2007
Optimizing ASP.NET 2.0 Web Project Build Performance with VS 2005
Deployment problems and their solutions of web application Asp.Net 2.0
Deploying a Crystal Reports Application to a Remote Server
Wednesday, March 28, 2007
VS 2005 Web Deployment Projects
How To: Write a MSBuild Task
Using Web Deployment Projects with Visual Studio 2005
- More control over assembly naming and output.
- Custom pre-processing and post-processing for the build.
- The ability to exclude, add, and transform files and directories during builds.
- The ability to modify the Web.config file to change database connection strings, application settings, or the URLs for Web references, depending on the build configuration. (For example, it might be necessary to use different values for development, test, staging, and release settings). Learn more...
Tuesday, March 27, 2007
Design Patterns for ASP.NET Developers, Part 2: Custom Controller Patterns
Design Patterns for ASP.NET Developers, Part 1: Basic Patterns
"... a body of literature to help software developers resolve recurring problems encountered throughout all of software development."
"... a shared language for communicating insight and experience about these problems and their solutions."
"A pattern is a named nugget of insight that conveys the essence of a proven solution to a recurring problem within a certain context amidst competing concerns."
Learn more...
Monday, March 26, 2007
Working with ReportViewer control of ASP.NET 2.0
Friday, March 23, 2007
Common Web Project Conversion Issues and Solutions
ASP.NET 2.0 Tips, Tricks, Recipes and Gotchas
To learn more about ASP.NET, also make sure to watch all of the great “ASP.NET: How Do I?” videos (each week a new video is posted).
Building Re-Usable ASP.NET User Control and Page Libraries with VS 2005
Upgrade from ASP.NET 1.x
Using Visual Studio 2005 Web Application Projects is the recommended model for converting an existing ASP.NET 1.x Web application created using Visual Studio .NET 2002/2003 to ASP.NET 2.0 for editing with Visual Studio 2005. Migration using Web Site Projects is available to developers who are interested in converting their Visual Studio .NET 2002/2003 Web applications to the new Visual Studio 2005 project model. Upgrading using Web Site Projects can result in major modifications to an existing Web application whereas upgrading using Web Application Projects requires minimal code and project modifications. Learn more...
Top 10 SQL Server indexing tips to improve performance
#1 -SQL Server 2000 indexing dos and don'ts
In the second part of this three-part feature, Edgewood Solutions' Jeremy Kadlec outlines best and worst practices for indexing in SQL Server 2000.
#2 -Indexes made handy in SQL Server
Indexes should be reviewed to ensure prime performance. Weed out valueless indexes in SQL Server, while identifying the best indexes for your application.
#3 -Partition indexes for improved SQL Server 2005 performance
SQL Server 2005 index partitioning allows you to distribute the load for a given index across multiple files. Learn how to create an index with partitioned data.
#4 -Stored procedures: Create and delete constraints and indexes
This collection of six stored procedures will help you create and delete constraints and indexes.
#5 -Tricks for using the Index Tuning Wizard
Learn how to improve overall SQL Server 2000 performance with these Indexing Tuning Wizard tricks from Edgewood Solutions' Jeremy Kadlec.
#6 -Undocumented stored procedure: Repair table indexes with sp_fixindex
One undocumented stored procedure in SQL Server 2000 can be used to repair a corrupted table index. This tip explains how to use sp_fixindex to keep SQL Server running smooth.
#7 -Undocumented stored procedure: Find space occupied by all tables and indexes
Here's a quick way to find the space occupied by all tables and indexes in a SQL Server 2000 database.
#8 -Solving SQL Server 2000 index fragmentation
Edgewood Solutions' Jeremy Kadlec explains how indexes become fragmented and how to maintain beneficial indexes to ensure high performance.
#9 -Indexing Q&A: Answers to your common indexing questions
Know how to choose proper indexes for your business situation. In part one of this two-part indexing series, Edgewood Solutions' Jeremy Kadlec answers common indexing questions.
#10 -Clustered and non-clustered indexes in SQL Server
Rules for using a clustered vs. a non-clustered index are tough to decipher. In this tip, you'll see the fundamentals to consider when making your choice, along with some best practice techniques. Get an overview of tradeoffs and proper index implementation, as well as other areas involved in your decision, including partitioning and storage arrays.
Note: This article is brought to you by searchsqlserver.techtarget.com