SQL Server Magazine presented Best of Show awards to products in three categories—database design, database management, and database applications—at the spring SQL Connections conference in New Orleans. ER/Studio from Embarcadero Technologies won the Best of Show award in the database design categor
Tag: sql server
Without coding custom reports or complex forms, you can now enable users to search and run reports on information in your database-driven Web site or application. Microsoft discovered a way to use a flexible search-specification mechanism that comes with a remarkably easy interface: the English lang
If you're a diehard Microsoft BackOffice Server (BOS) aficionado, you might have noticed that we announced the launch of the new BackOffice Server UPDATE newsletter at the same time Microsoft announced the BOS 2000 beta release. That wasn't a coincidence: the primary focus of this newsletter
This article describes the Index Tuning Wizard in Microsoft SQL Server 2000. The Index Tuning Wizard simplifies the task of identifying which indexes to create in a table and also optionally generates scripts to create them by analyzing a user-supplied workload. Various modes are offered for tuning
In revamping the way SQL Server implements security in the 7.0 release, Microsoft created a flexible and powerful method for managing users’ access both to the SQL Server system and to the databases. The changes also created confusion as administrators tried to upgrade from SQL Server 6.5 security.
Another solution we have found is to use the offerings from Microsoft's SQL Server 7. SQL 7 has a few key pieces of functionality that lend themselves to the sometimes disconnected user. The first key piece is the MSDE (Microsoft Data Engine), which is actually the guts of SQL 7 without the fron
Enterprises need the ability to quickly analyze and access diverse information sources in order to make better decisions. To meet this challenge, it is necessary to integrate, consolidate, and summarize information from heterogeneous data sources. By doing this, you create a data warehouse—a large,
On October 6, 2000, Compaq published a new record-setting TPC-C result, recording the highest performance ever, running Windows 2000 and SQL Server 2000. With a performance rating of 505,302 transactions per minute (tpmC) and price/performance of $20.68 per tpmC, the 24-node ProLiant system is the f
Get an overview of the newest SQL Server 2000 features.
Suppose you have a shopping cart with several categories of products, and your ASP pages use SQL statements that access database queries for the different categories. Instead of creating an ASP page for each category (for example, shirts.asp, caps.asp, and so on), you can have one page (products.asp