SQL Server Magazine January 2001
[Focus]
Learn about the basics of data mining, Microsoft's data-mining architecture, and how it all fits into SQL Server 2000.
By Barry de Ville
Use Analysis Services' and OLAP Services' Time dimension and MDX time-aware functions to slice and dice your data by time periods.
By Yoram Levin
[Features]
Use SQL Server to recursively traverse hierarchies in your database.
By Chris Behrens
Adding a little redundancy to your e-commerce database can yield big performance gains.
By Jeffrey Bane
SQL Server 2000's new XML for SQL Web Release supports updategrams, which let you use XML documents to update your databases.
By Michael Otey
[Lab Reports]
Lock down your SQL Server 7.0 and 6.x systems with Internet Security Systems' security-scanning tool.
By Brian Knight
[SQL Server Savvy]
Learn how to find tables that don't have indexes, how SQL Server joins on columns of different data types, and more.
By Brian Moran
[Editorial]
Scale-out technology meets high-end scalability needs, but scaling up is simple and adequate for most companies.
By Michael Otey
[Reader to Reader]
Readers revisit November 2000's stored procedure to generate a job schedule report.
By Various Authors
[SQL Server Q&A]
Richard Waymire answers readers' SQL Server questions about query optimizer behavior, DBCC reports, and a COM error.
By Richard Waymire
[SQL Seven]
Check out Michael Otey's picks for the seven most useful T-SQL enhancements in SQL Server 2000.
By Michael Otey
[SQL Server/Office Integration]
In this second article in a security series, Rick Dobson shows you how to set up SQL Server account security through Access projects.
By Rick Dobson
[Inside SQL Server]
Learn how to use event tracing with SQL Server 2000's improved blackbox feature to find the cause of a server crash.
By Kalen Delaney
[Web Dev]
Use SQL Server Profiler to find out how efficiently your Web application executes code in SQL Server.
By Ken Spencer
[Mastering Analysis]
Analysis Services' custom rollups feature lets you build custom aggregation formulas to solve complex business problems.
By Russ Whitney
[T-SQL Black Belt]
Itzik Ben-Gan demonstrates how to use user-defined functions (UDFs) in hierarchical environments and how powerful UDFs can be for enhancing hierarchical data-manipulation capabilities.
By Itzik Ben-Gan
[News Analysis]
The new SQL Server 2000 Windows CE Edition offers small-size portability, familiar tools, and replication features.
By Paul Thurrott
Despite a Microsoft cease-and-desist order enjoining Oracle from misrepresenting SQL Server's capabilities, Oracle CEO Larry Ellison continues to publicly debunk SQL Server's benchmarking results.
By Paul Thurrott
[XML Q&A]
Rich Rollman answers readers' questions about using XML to populate a nonbrowser-based application, using ADO with XML, and finding XML books for beginners.
By Rich Rollman
|
