Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions. Discover how to: Work with T-SQL and CLR user-defined functions, stored procedures, and triggers. Handle transactions, concurrency, and error handling. Efficiently use temporary objects, including temporary tables, table variables, and table expressions. Evaluate when to use set-based programming techniques and when to use cursors. Work with dynamic SQL in an efficient and secure manner. Treat date- and time-related data in a robust manner. Develop CLR user-defined types and learn about temporal support in the relational model. Use XML and XQuery and implement a dynamic schema solution. Work with spatial data using the new geometry and geography types and spatial indexes. Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture. Use Service Broker for controlled asynchronous processing in database applications. All the book’s code samples will be available for download from the companion Web site.

Provides information on the features and functions of Reporting Services to turn enterprise data into a variety of reports.

Provides information on the architecture of the T-SQL programming language.

Dig into the architecture and internals of Microsoft Dynamics AX—with firsthand insights from the team who designed and developed it. Deepen your knowledge of the underlying frameworks, components, and tools—and get best-practice guidance to customize and extend your own high-performance solutions. Discover how to: Work with MorphX application-modeling tools and X++ code Exploit built-in workflow infrastructure to simplify process automation Use Enterprise Portal and ASP.NET to build rich, role-based Web portals See how reporting components work together for better business intelligence Execute complex batch jobs with greater control and reliability Learn how the runtime implements configuration and security Walk through integration scenarios and technologies Create and expose services to external applications Optimize application performance and extensibility

Delve inside the core SQL Server engine--and put that knowledge to work--with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you'll gain the deep knowledge you need to exploit key architectural changes--and capture the product's full potential. Discover how SQL Server works behind the scenes, including: What happens internally when SQL Server builds, expands, shrinks, and moves databases How to use event tracking--from triggers to the Extended Events Engine Why the right indexes can drastically reduce your query execution time How to transcend normal row-size limits with new storage capabilities How the Query Optimizer operates Multiple techniques for troubleshooting problematic query plans When to force SQL Server to reuse a cached query plan--or create a new one What SQL Server checks internally when running DBCC How to choose among five isolation levels and two concurrency models when working with multiple concurrent users

Previous McGraw-Hill SQL Server 2005 titles have sold more than 40,000 copies High availability is an important new focus for SQL Server 2005--IT professionals must be skilled in maximizing system uptime

CD-ROM includes: e-book in 1 pdf file (pdf version of this book); bonus material (10 pdf files); sample files.

Best Practices for Deploying and Managing Master Data Services (MDS) Effectively manage master data and drive better decision making across your enterprise with detailed instruction from two MDS experts. Microsoft SQL Server 2008 R2 Master Data Services Implementation & Administration shows you how to use MDS to centralize the management of key data within your organization. Find out how to build an MDS model, establish hierarchies, govern data access, and enforce business rules. Legacy system integration and security are also covered. Real-world programming examples illustrate the material presented in this comprehensive guide. Create a process-agnostic solution for managing your business domains Learn how to take advantage of the data modeling capabilities of MDS Manage hierarchies and consolidations across your organization Import data by using SQL Server Integration Services and T-SQL statements Ensure data accuracy and completeness by using business rules and versioning Employ role-based security at functional, object, and attribute levels Design export views and publish data to subscribing systems Use Web services to progrmmatically interact with your implementation

Leverage your Oracle DBA skills on Microsoft SQL Server 2008 Microsoft SQL Server 2008 Administration for Oracle DBAs shows you how to use your experience as an Oracle DBA to get up to speed quickly on the Microsoft SQL Server platform. Authors with real-world expertise in both Oracle and SQL Server introduce you to fundamental concepts, such as SQL Server architecture and core administration, before guiding you through advanced techniques, including performance optimization, high availability and disaster recovery. Platform comparisons, on-the-job examples, and answers to questions raised by Oracle DBAs learning the SQL Server environment help build your skills. This practical guide shows you how to: Identify the components of the SQL Server platform Understand SQL Server architecture Install and configure SQL Server software and client components Define and manage database objects Implement and administer database security Monitor, identify, and resolve performance issues Design and implement high availability, system backup, and disaster recovery strategies Automate SQL Server using built-in scheduling and alerting capabilities Import and export data to and from SQL Server and other RDBMS platforms Upgrade existing SQL Server installations and migrate Oracle databases to SQL Server

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data. Solid foundation in best practices and relational theory Maximize SQL Server features to enhance security, performance, scalability Thorough treatment from conceptual design to an effective, physical implementation