The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Windows 2000--the fifth major release of the Windows NT OS--includes many sophisticated features that enable it to compete head-to-head with UNIX systems in the enterprise market. And Win2K's networking and usability improvements make the new OS a better database platform for SQL Server than NT 4.0.
By Russ Whitney
Here's the answer to May's MDX Puzzle.
Here's the June MDX Puzzle.
By Richard Waymire
Richard Waymire answers your questions about SQL Server.
By
Readers share their tips for accessing the appropriate table view, safely changing SQL Server 7.0's service account, and shrinking an active log file in SQL Server 7.0.
By Ken Spencer
When you’re troubleshooting Web applications, the answers you seek aren’t always in obvious places.
By Bob Pfeiff
In real-world data warehouse solutions that involve disparate operating systems, you almost never find relatively clean data.
By Christian Unterreitmeier
Defining the right indexes on sort columns can yield dramatic performance results for queries that need ordered data.
By Jonathan Chau
Ripple Technologies' flexible monitoring program keeps a watchful eye on SQL Server and other critical applications.
By Michelle A. Poolet
When you use entity relationship diagrams to map your business' data, the database begins to take shape.
By Michael D. Reilly
SQL Server 7.0 lets you set up not just a single task, but a series of tasks with dependencies.
This simple data mart solution demonstrates an effective way to pull operational data into a dimensional database so that decision makers can quickly and easily access business information.
By Rick Dobson
Here are the basics of SQL Server security for Access 2000 projects.
By Kalen Delaney
SQL Server 2000 recovery models replace two database options and give you more flexibility for backup and recovery.
By Brian Moran
Learn how to use CONVERT to format dates, how to use –L options to find SQL Servers on a LAN, how to find disabled triggers, what happens when your 120-day SQL Server 7.0 Evaluation Edition expires, and more.
By Michael Otey
How did Windows 2000 and SQL Server 2000 blow the lid off the TPC benchmark scores? By employing new distributed partitioned view technology, which consists of joined, updateable views that span multiple servers.
By Wayne Snyder
English Query (EQ) gives users maximum flexibility to get answers from SQL Server databases. We'll show you how to set it up and preview what's new in EQ 2000.
If you’re moving from Windows NT to Windows 2000 (Win2K), you’ll need these directions for finding your favorite administrative tools in Win2K.
Organizations that adopt Win2K will pay a price in increased processor and memory requirements, but they’ll reap commensurate rewards in system reliability, performance, and manageability.
Dig deeper with drillthrough, a new feature of SQL Server 2000 Analysis Services.
advertisement