The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
SQL Server MVPs Kalen Delaney and Itzik Ben-Gan introduce you to the new distributed partitioned views technology available in SQL Server 2000. Also, we'll show you how to set up linked servers in SQL Server 7.0. PLUS: An exclusive interview with Microsoft VP of SQL Server Paul Flessner.
By Russ Whitney
The answer to the July puzzle uses the new LookupCube function in SQL Server 2000.
Solve the August MDX Puzzle.
By John D. Lambert
Here's a summary of steps you can take to optimize SQL Server security and connectivity.
By
SQL Server Magazine presents Best of Show awards, and PASS 2000 North American is scheduled for October 2000 in San Francisco.
By Itzik Ben-Gan
Learn how to deploy the technology behind Microsoft's scale-out strategy.
By Michael Otey
Follow these steps to ensure that your SQL Server 7.0 Service Pack 2 (SP2) upgrade goes smoothly.
The Microsoft split won’t do the company—or consumers—any good.
Here’s how SQL Server 2000 Analysis Services handles unbalanced hierarchies.
By Rick Dobson
Learn how Access handles dates and times to extract results in the format you need.
By Richard Waymire
Here are answers to readers’ questions about dropping a database, starting SQL Server Services, and more.
By Kalen Delaney
Learn more about SQL Server 2000's ability to run multiple SQL Server installations on one machine.
Learning how to use T-SQL to populate magic square can sharpen your programming skills for more practical tasks.
By Ken Spencer
Follow these steps to unleash the full power of the Visual InterDev debugging tool.
A reader revisits a June Reader to Reader tip about shrinking active log files, which could have disastrous consequences, and shares a safe way to shrink log files.
By Michelle A. Poolet
Create a physical design to document and verify all of your database's physical implementation requirements before you start implementing the live database.
By Morris Lewis
This pint-sized application gives mobile users powerful database functionality.
Follow these steps to upgrade your SQL Server security and improve data connection performance.
By Brian Moran
Read about finding installed OLE DB providers, escalating page locks to table locks, setting default values, and Microsoft's support policy for existing SQL Server versions.
Contributing editor and SQL Server MVP Brian Moran talked recently with Paul Flessner, Microsoft’s VP of SQL Server and middleware, about the evolution of SQL Server and its role in corporate IT environments.
By Brian Knight
Linked servers, the core technology in SQL Server 2000 distributed partitioned views, let you use distributed queries to query a SQL Server or non-SQL Server database as if it were on the local server.
advertisement