SQL Server 2005 Technical Articles and Code Samples

63 SQL Server 2005 Technical Articles

	» Add Custom Data Mining Algorithms to SQL Server 2005
	» Analysis Services 2005 Processing Architecture
	» Automate Testing of Your Stored Procs
	» Building a Localized Report on a SQL Server 2005 Analysis Service Cube Data Source
	» Building Reliable, Asynchronous Database Applications Using Service Broker
	» Data Access Tracing in SQL Server 2005
	» Data Deployment: Streamline Your Database Setup Process with a Custom Installer
	» Data Integration Solutions for Master Data Management
	» Data Quality Solutions
	» Data Security: Stop SQL Injection Attacks Before They Stop You
	» Data Transformation Services for SQL Server 2005 Frequently Asked Design Questions
	» Developing Report Navigation and Drilldown
	» Editing Transact-SQL Code in SQL Server 2005 Beta 2
	» Enabling Drillthrough in Analysis Services 2005
	» Express Editions: Get a Lean, Mean Dev Machine with the Express Editions of Visual Basic and SQL Server 2005
	» An Introduction to SQL Server Service Broker
	» Fuzzy Lookup and Fuzzy Grouping in Data Transformation Services for SQL Server 2005
	» Hackers Beware: Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005
	» Handling Data Integrity Issues in Analysis Services 2005
	» How to Implement an Automatic Sliding Window in a Partitioned Table on SQL 2005
	» Integrating Reporting Services into Your Application
	» Introduction to the Unified Dimensional Model (UDM)
	» Introduction to MDX Scripting in Microsoft SQL Server 2005
	» Introduction to SQL Server 2005 Data Mining
	» Introduction to XQuery in SQL Server 2005
	» Managed Data Access Inside SQL Server with ADO .NET and SQLCLR
	» Many-to-Many Dimensions in Analysis Services 2005
	» Migrating from Business Objects Crystal Reports to SQL Server 2005 Reporting Services
	» Mine Your Business: AMO Lets You Dig Deeper into Your Data from Your Own Applications
	» Monitoring Report Execution Performance with Execution Logs
	» Multi-User Considerations in Data Synchronization for SQL Server 2005 Mobile Edition 3.0
	» Multiple Active Result Sets (MARS) in SQL Server 2005
	» Overview of the Analysis Services Development and Management Environments
	» Overview of Native XML Web Services for Microsoft SQL Server 2005
	» An Overview of SQL Server 2005 for the Database Developer
	» Partitioned Tables and Indexes in SQL Server 2005
	» Performance Optimizations for the XML Data Type in SQL Server 2005
	» Processing XML Showplans Using SQLCLR in SQL Server 2005
	» Reporting Services: Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration
	» Say What? Make Sense of Your Web Feedback using SQL Server 2005
	» SQL Server 2005 Row Versioning-Based Transaction Isolation
	» SQL Server 2005 Beta 2 Transact-SQL Enhancements
	» SQL Server 2005 Full-Text Search: Internals and Enhancements
	» SQL Server 2005: Fuzzy Lookups and Groupings Provide Powerful Data Cleansing Capabilities
	» SQL Server 2005 Integration Services, Part 1: Lessons from Project REAL
	» SQL Server 2005 Integration Services, Part 2: Developing Custom Components for Project REAL
	» SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005
	» SQL Server Data Mining: Plug-In Algorithms
	» SQL Server Data Mining Programmability
	» SQL Server Optimization
	» A Technical Comparison of Replication and Remote Data Access Features in SQL Server 2005 Mobile Edition 3.0
	» Trace and Replay Objects: A New API for SQL Server Tracing and Replay
	» A Tutorial for Constructing a Plug-in Algorithm
	» A Tutorial for Constructing a Plug-In Viewer
	» Usage Scenarios for SQL Server 2005 Native Web Services
	» Using CLR Integration in SQL Server 2005
	» Using Table Valued Functions in SQL Server 2005 to Implement a Spatial Data Library
	» Using XQuery, New Large DataTypes, and More
	» What's New in FOR XML in Microsoft SQL Server 2005
	» XML Best Practices for Microsoft SQL Server 2005
	» XML Indexes in SQL Server 2005
	» XML Options in Microsoft SQL Server 2005
	» XML Support in Microsoft SQL Server 2005

SQL Server 2005 Code Samples

SQL Server 2005 Samples and Sample Databases (July 2006)

The SQL Server 2005 Samples includes over 100 samples, organized by component:

• Database Engine, including administration, data access, Full-Text Search, common language runtime (CLR) integration, Server Management Objects (SMO), Service Broker, and XML
• Analysis Services
• Integration Services
• Notification Services
• Reporting Services
• Replication

AdventureWorks OLTP Database Diagram
Download a diagram of the AdventureWorks OLTP sample database. The sample data is based on a fictitious company, Adventure Works Cycles, a large, multinational manufacturing company that produces and distributes metal and composite bicycles to North American, European, and Asian commercial markets.