SQL Server Magazine July 2005
[Focus]
Many of your system's performance problems result from simple ignorance of good hardware design. Here are some tips you can use to maximize SQL Server performance before you ever install the software.
By Kevin Kline
[Features]
Wouldn't it be great to cut the time it takes to unit test T-SQL stored procedures? Well, now you can! You can automate your testing by using nothing more than Query Analyzer and a little T-SQL code. Here's the solution in four easy-to-implement parts.
By Dan Sawyer
You can improve performance by retrofitting a database with indexes and more powerful hardware, but you can never completely compensate for a bad data model. Performance-tuning SQL Server starts with a sound database configuration and data model.
By Michelle A. Poolet
Here's a handy workaround to help you avoid errors that cause Microsoft IIS to lock up when when you're working with SQL Server 2000 Reporting Services on Windows XP.
By William Vaughn , et al.
[SQL Server Savvy]
ADO MD.NET and XMLA clients communicate differently with a SQL Server 2000 Analysis Services instance then with a SQL Server 2005 Analysis Services instance.
By Carl Rabeler
Learn how to deploy a SQL Server 2000 Analysis Services database from your development environment to your test, staging, QA, or production environment while keeping your production and development environments synchronized.
By Carl Rabeler
Find out if you can delegate permission to a Window user or group to process an Analysis Services cube or dimension without also granting permissions to view the data in the cobe or dimensions.
By Carl Rabeler
Learn how to determine what hardware and software resources your SQL Server 2000 Analysis Services instance requires.
By Carl Rabeler
A typical approach to high availability in Analysis Services 2000 is to use Windows NLB to distribute user queries across multiple Analysis Services instances on disparate machines while also increasing availability.
By Carl Rabeler
How can you monitor the queries your business users submit?
By Carl Rabeler
[Editorial]
With SQL Server 2005 Workgroup edition, Microsoft takes on the low-end database market.
By Michael Otey
[Inside SQL Server]
In many cases, reusing a precompiled plan benefits your stored procedure's performance--but not always. To know when reusing a plan might not be appropriate, find out how the query optimizer determines the best plan for each query.
By Kalen Delaney
[T-SQL Black Belt]
In computer systems, you sometimes need to save space by using non-decimal values. But how do you convert those numbers back to decimals when you need them? Find out in this article.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server–related products.
By Dawn Cyr
[SELECT TOP(X)]
Michael Otey discusses SQL Server's high availability options and shows you which types of failures each solution handles best.
By Michael Otey
[Preparing for SQL Server 2005]
For Microsoft's SQL Server development team, enabling Web services for SQL Server 2005 was important enough to warrant native support for the feature. Learn how you can use Web services support to improve interoperability and application connectivity.
By Matt Nunn
[Ask Microsoft]
Microsoft's Patrick Conlan gives tips for making sure you correctly back up your transaction log.
By Microsoft's SQL Server Development Team
Microsoft's Thierry D'hers describes the steps for getting a string to show up in analysis cubes.
By Microsoft's SQL Server Development Team
Microsoft's Patrick Conlan explains 3 methods for rebuilding a heap table index.
By Microsoft's SQL Server Development Team
[Hands On]
A reader highlights his favorite product: SQLCentric.
By Dawn Cyr
|
