Determine which processes use the most database server resources (CPU and physical IO) over a given period of time.
Take advantage of SQL Server 2005 and Visual Studio to mine your data for significant patterns that might otherwise escape your attention.
- By John Charles Olamendy Turruellas
- 01/01/2007
Create more flexible, data-driven solutions with the aid of a match by exception design pattern.
- By Joel Champagne
- 10/01/2006
Poor performance is frustrating to an end user, and can lead to users not using your applications in the intended manner. Take advantage of these five tips to accelerate the performance of your ADO.NET application.
- By Jonathan Bruce
- 03/01/2006
Create and learn to use a pair of search utilities that simplify the task of gathering information about a particular database or all the databases on a particular server.
T-SQL includes several new capabilities that will add punch to your database apps, including TRY...CATCH error handling, pivot aggregate values to create crosstab tables, and more.
- By Roger Jennings
- 09/01/2005
Take advantage of new SQL Server 2005 features, GUI administration, and XCopy or ClickOnce deployment with SQL Express and Express Manager.
- By Roger Jennings
- 07/01/2005
Use the built-in functionality of SQL Server to make your business processes more efficient with data mining.
Working with and understanding how client state is used in your app is critical to putting a good design into practice. Examine three techniques for managing client state: ses-sion state, view state, and cookies.
- By Matthew Gibbs and Ron Howard
- 01/01/2005
Author Doug Thews introduces you to writing stored procedures and UDFs in .NET 2.0 and SQL Server 2005.
Stored procedures don't provide the flexibility old-style concatenated SQL does. By abstracting the filter and creating joined tables dynamically, you build a system that is robust in the face of data structure changes.
- By Kathleen Dollard
- 10/01/2004
Use the SQL Server Report Designer's wizards for a streamlined solution to setting up, designing, polishing, and publishing reports.
- By Stacia Misner
- 09/01/2004
Learn 10 useful tips and tricks that help boost SQL Server application performance.
Here's a design for creating data-driven validation rules for distributed apps. It lets you distribute the rules from to clients without modifying client-side application code.
- By Tony Surma and Bill Wagner
- 06/01/2004
Find out how Active Directory Application Mode and Windows Authorization Manager can simplify security, personalization, and configuration for your directory-enabled applications.
- By Enrico Sabbadin
- 05/01/2004