The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
William Sheldon explains how ASP.NET 2.0 capabilities such as new callback functions and enhanced caching options will help boost your Web site's performance at the client, Web server, and database tiers.
By Itzik Ben-Gan
Using SQL Server 2000, you want to query the Orders table in the Northwind database and return certain attributes per each order. But you don't get what you want. What went wrong?
By Karen Forster
Get the inside story on Microsoft's new database development tool, Visual Studio Team Edition for Database Professionals (VSDB Pro), which its creators hope will bridge the gap between database and application developers.
By
Microsoft’s Gert Drapers explains techniques for getting valuable information from SQL Server’s msdb backup tables.
In this final part of a four-part series about custom aggregations, we look at a class of solutions that relies on specialized solutions.
By William Sheldon
Take advantage of callback functions and enhanced caching options to boost your Web application’s performance at the client, Web server, and database tiers.
Our editors share insights from their conversations with Insightix, MRC, Diskeeper, and Oracle.
By Michael Otey
Both the AMD Opteron and the Intel EM64T processors are x64 compatible and capable of running 32-bit x86 and 64-bit x64 applications at full speed. However, you'll find significant differences between the processors and the system architectures they use.
By John Green
Needs to maintain application availability, to stash copies of data in safe, remote locations, and to be able to readily recover data have given rise to new SQL Server 2005 features, as well as new backup and recovery strategies.
By Blake Eno
Check out new and improved SQL Server–related products.
By Craig Utley
Learn how to use Reporting Services to give business users access to complex Analysis Services data--in a user-friendly format.
By Michelle A. Poolet
Learn how a database consultant was able to help a DBA understand some of the inherent weaknesses of using a flat-file database, and move toward normalizing the data in a relational database.
By Brian Moran
There's been a change; SQL Server Profiler running under SQL Server 2005 now captures duration values at a higher level of granularity.
By Kalen Delaney
Learn about new views in SQL Server 2005 that replace SQL Server 2000's sysindexes system table and give you access to storage-related metadata for database objects.
When you upgrade to SQL Server 2005, remember to check to make sure the compatibility level has changed to a value of 90 during the upgrade process.
Microsoft recently released SQL Server 2005 Report Packs, which provides 65 reports that are designed to help you author and generate reports for your environment in a timely manner.
Check out the HP ProLiant DL585—the enterprise-class 4-way, 64-bit server that's setting new benchmarks in performance, thanks to its dual-core AMD Opteron configuration.
Can you prove that a hiker, ascending and descending a mountain on two separate days, visits a certain point along a mountain path at the same time of day on both days?
An anomaly in SQL Server 2005 Profiler's GUI can be confusing. Here's the scoop on how SQL Server 2005 displays duration and CPU values.
advertisement