SQL Server Magazine July 2006
[Focus]
Take advantage of callback functions and enhanced caching options to boost your Web application’s performance at the client, Web server, and database tiers.
By William Sheldon
[Features]
Learn how to use Reporting Services to give business users access to complex Analysis Services data--in a user-friendly format.
By Craig Utley
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 Karen Forster
[SQL Server Savvy]
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.
By Brian Moran
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.
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 Brian Moran
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.
By Brian Moran
[Editorial]
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 Michael Otey
[Inside SQL Server]
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.
By Kalen Delaney
[Solutions by Design]
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 Michelle A. Poolet
[T-SQL Black Belt]
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 Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server–related products.
By Blake Eno
[SELECT TOP(X)]
Keyboard shortcuts save you time and effort when you use Query Editor in SQL Server 2005. Check out these top 10 we've collected for easy reference—and create a few of your own, too.
By Michael Otey
[Ask Microsoft]
Microsoft’s Gert Drapers explains techniques for getting valuable information from SQL Server’s msdb backup tables.
By Microsoft's SQL Server Development Team
[Vendor Briefs]
Our editors share insights from their conversations with Insightix, MRC, Diskeeper, and Oracle.
By Editors
[Review]
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.
By Michael Otey
[Market Watch]
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 John Green
|
