Architecture and Design

Learn how to get your SQL Server solution off to a good start with proper architecture and design.

---

SQL Server Internals

	Inside the SQL Server 2000 User Mode Scheduler Ken Henderson profiles the User Mode Scheduler (UMS) that handles thread scheduling in SQL Server 2000. Learn how UMS provides more control and allows the server to scale better than it could with the Windows scheduler.
	SQL Server Memory Management Check out the first installment of Ken Henderson's new column, SQL Server for Developers. He gives you the inside look at SQL Server memory management and why you should care about it.

Relational Architecture

Database Design Get an introduction to logical and physical database design using SQL Server 2000.

Data Warehouse Architecture

	Best Practices for Business Intelligence Using the Microsoft Data Warehousing Framework Discover best practices and suggestions for using SQL Server and Analysis Services to create data warehouse applications.
	Designing a Data Warehouse This high-level overview of design requirements for data warehouses (as opposed to transactional databases) discusses dimensional modeling, fact, aggregation, and dimension tables, and other general data warehouse design topics.
	SQL Server 2000 (64-bit) Analysis Services: Why Migrate and What to Expect Peruse the "Getting Started with SQL Server 2000 (64-bit) Analysis Services " section for functionality and infrastructure information you can use in planning your OLAP application.
	Creating Large-Scale, Highly Available OLAP Sites This step-by-step guide on designing an enterprise-class OLAP site introduces techniques needed to create large-scale, highly available online analytical processing sites using SQL Server 2000 Analysis Services and Network Load Balancing in Windows 2000 Advanced Server.
	The Reality of Real-Time OLAP Get technical information and guidelines for the use of real-time OLAP in SQL Server 2000 Analysis Services.

Working with SQL Server Databases and Objects

	Creating and Maintaining Databases Overview All aspects of creating and modifying a SQL Server database and its component objects are covered, including tables, views, indexes (regular and full-text), triggers, stored procedures, and user-defined functions.
	Creating and Using Data Warehouses Overview Understand all aspects of creating and maintaining a SQL Server data warehouse and its component objects, and get familiar with the SQL Server technologies that support data warehousing.
	Performing Catalog Operations Check out this brief example of how to use ADO.NET to modify a SQL Server database schema.
	Implementing Referential Integrity and Cascading Actions Learn about the use of declarative referential integrity and the use of triggers to maintain data integrity.
	Automate the Generation of Stored Procedures for Your Database Find out about the creation and execution of dynamic T-SQL scripts to automate the coding of common database stored procedures.
	Improving Performance with SQL Server 2000 Indexed Views Learn about the indexed views capability of SQL Server 2000 Enterprise Edition, and the design considerations when using them.

SQL Server Database Development Tools

	Visual Database Tools Get a list of database design and development tools in the Visual Studio integrated development environment (IDE). Create database objects such as tables, columns, keys, indexes, relationships, constraints, and views using the Database Designer, the Table Designer, and the Query and View Designer.
	Creating SQL Scripts See how to create scripts for creating and modifying SQL Server objects using the Visual Studio IDE.
	Documenting and Scripting Databases Get an overview of the benefits of scripting, plus links to the various methods of generating a script for a SQL Server object.