The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Explore the Microsoft data-mining architecture and data-mining algorithms -- including decision trees and cluster analysis -- and the Analysis Services Time Dimension.
By Itzik Ben-Gan
Here's the answer to the recursion challenge that SQL Server MVP Itzik Ben-Gan presented in the T-SQL Black Belt article "Manipulating Hierarchies with UDFs."
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 Russ Whitney
Here's the answer to December's MDX Puzzle.
Analysis Services' custom rollups feature lets you build custom aggregation formulas to solve complex business problems.
By
Readers revisit November 2000's stored procedure to generate a job schedule report.
To test your understanding of recursion and user-defined functions (UDFs), solve this puzzle.
By Yoram Levin
Add a special dimension to your cube to hold calculations.
By Kalen Delaney
Learn how to use event tracing with SQL Server 2000's improved blackbox feature to find the cause of a server crash.
By Michael Otey
Check out Michael Otey's picks for the seven most useful T-SQL enhancements in SQL Server 2000.
Use Analysis Services' and OLAP Services' Time dimension and MDX time-aware functions to slice and dice your data by time periods.
Here's how to customize the Time dimension names that the Dimension Wizard generates.
By Barry de Ville
Learn about the basics of data mining, Microsoft's data-mining architecture, and how it all fits into SQL Server 2000.
By Jeffrey Bane
Adding a little redundancy to your e-commerce database can yield big performance gains.
Scale-out technology meets high-end scalability needs, but scaling up is simple and adequate for most companies.
Check out January's MDX puzzle.
By Chris Behrens
Use SQL Server to recursively traverse hierarchies in your database.
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 Ken Spencer
Use SQL Server Profiler to find out how efficiently your Web application executes code in SQL Server.
By Brian Moran
Learn how to find tables that don't have indexes, how SQL Server joins on columns of different data types, and more.
By Rick Dobson
In this second article in a security series, Rick Dobson shows you how to set up SQL Server account security through Access projects.
The new SQL Server 2000 Windows CE Edition offers small-size portability, familiar tools, and replication features.
An example of a recursive algorithm that doesn't have a simple, intuitive, nonrecursive solution is a puzzle called Hanoi Towers.
Microsoft's XML for SQL Web Release includes support for two new XML integration features: updategrams and bulk load.
By Richard Waymire
Richard Waymire answers readers' SQL Server questions about query optimizer behavior, DBCC reports, and a COM error.
By Rich Rollman
Rich Rollman answers readers' questions about using XML to populate a nonbrowser-based application, using ADO with XML, and finding XML books for beginners.
For simple OS-level batch file processing, OSQL and ISQL can quickly and effectively meet your needs.
SQL Server 2000's new XML for SQL Web Release supports updategrams, which let you use XML documents to update your databases.
By Brian Knight
Lock down your SQL Server 7.0 and 6.x systems with Internet Security Systems' security-scanning tool.
advertisement