From SQL Power Tools – Industry breakthrough product that monitors what causes 80% of all database server performance problems – SQL statements. Other database monitors typically monitor only the high level resources of production database servers (i.e. the cause of only 20% of all database perform

By Michael Otey – ADO is by far the most commonly used data-access middleware for retrieving data and updating SQL Server databases. However, ADO's default settings aren't always the best options for optimal performance. Here are seven ways you can boost ADO performance with SQL Server.

by Joy Mundy – Few queries and reports perform any calculation fancier than summing or counting, with the occasional ratio thrown in for excitement. Query and reporting tool vendors have done an excellent job of making the simple things easy. They do a nice job of providing functionality that is mis

From SQL Power Tools – The demand for global access to corporate information from eCommerce and data warehousing applications will be ever increasing in the years 2000+. Data and application usage patterns exposed by the eData Usage Analyzer reveal how end-users interact with data. The eData Usag

From SQL-Server-Performance.com – This book is really interesting, and a bit different from most of the SQL language "how-to" books that I have read in the past. In fact, the book is somewhat hard to describe. Essentially, the book teaches you how to code SQL for the "real world". No

When you're designing and programming databases, images and audio or video clips probably aren't among the first things that you consider storing. However, today's databases often need to store employee photos, product pictures, and the like. Even the ability to play on-demand video clip

So why am I reviewing a book on Windows 2000 Advanced Server Clustering Services on a website dedicated to SQL Server performance? Because more and more DBAs are starting to cluster SQL Server, and as of this date, this is the only book on the market that comes close to providing the know-how you ne

By Michael Otey – The only constant is change, and nowhere is that maxim truer than in the software development arena. It seems that by the time you've mastered one technology, you have to put all that knowledge aside and move on to the next "big thing." And the Microsoft .NET Framework

The long-awaited SQL Server 2000 Resource Kit has finally arrived—complete with 1,108 pages of useful documentation, 29 tools and examples, and six eBooks to learn how to fine-tune a SQL Server 2000 system. SQL Server MVP Fernando Guerrero takes you on a quick tour.

SQL Server 2000 can handle 688,220 transactions per minute! SQL Server 2000 has further established its position as the fastest database in the world. With a performance rating of 688,220 transactions per minute (tpmC) and price/tpmC of $28.89, a 32-node IBM/eServer xSeries 370 system exceeded the p