In recent years, database management systems have grown increasingly unwieldy as software companies attempt to incorporate a wider and wider range of functionality. Now the trend is towards componentization—\"unbundling” these behemoths an...

Dig into the internals of tuning and optimization features in SQL Server 2005 with insights from leading SQL Server experts. This in-depth guide delivers best practices, pragmatic advice, and code samples to help you enable efficient, effective queries and optimize database performance.

Delve into the internal architecture of T-SQLand unveil the power of set-based queryingwith comprehensive reference and advice from a highly regarded T-SQL expert and members of Microsoft's SQL Server development team. Database developers and administrators will examine the best practices, advanced techniques, sample databases, and code needed to master the programming language built into SQL Serversolving complex problems with real-world solutions.

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 ...

Authoritative Guides for Microsoft Windows and Server Professionals Direct from Microsoft Insiders: the Complete Hands-On Guide to SQL Server 2005's Powerful Tools! Microsoft SQL Server 2005's high-powered management tools can dramatically improve DBA productivity and effectiveness. Now there's...

Announcing an all-new Self-Paced Training Kit designed to help maximize your performance on 70-448, the required exam for the new MCTS: Microsoft SQL Server 2008 Business Intelligence Implementation and Maintenance certification...

MICROSOFT SQL SERVER 2000 ANALYSIS SERVICES STEP BY STEP shows Microsoft Excel and Access experts, IS managers, and database developers how to build applications that take advantage of the powerful data-analysis services in Microsoft SQL Server 2000.

Teach yourself how to use SQL Server 2000 Data Transformation Services (DTS) and begin writing your own data movement applications one step at a time. This practical, hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse. Work at your own pace through the easy-to-follow lessons and hands-on exercises to master essential techniques.

Get your mission-critical databases up and running quickly with this essential, single-volume guide. This comprehensive administrator s reference details features and capabilities of SQL Server 2005 including how to implement business intelligence applications.

Teach yourself the fundamentals of SQL Server Integration Services one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data and build solutions that support your business intelligence needs.

From the author and series editor of the immensely popular "Administrator's Pocket Consultant" series from Microsoft Press[registered] - this pocket-size guide delivers fast, accurate answers on the spot for IT professionals. "Microsoft[registered] SQL Server[registered] 2008 Administrator's Pocket Consultant, 2nd Edition" is the ideal concise, immediate reference you'll want with you at all times as you deal with

Get the practical, pocket-sized guide for IT professionals who need to administer, maintain, and optimize SQL Server 2008. Written by award-winning author William Stanek, this portable reference delivers essential details for using SQL Server 2008 to help protect and manage your company s data whether automating tasks

Teach yourself to use SQL Server 2008 Analysis Services for business intelligence one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you ll create a simple multidimensional OLAP cube and progressively add features to help improve, secure, deploy, and maintain an Analysis Services database.

Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance—including exercises and code samples—that show you how to develop code to query and modify data. You’ll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries.

The official guide to installing, administering, and working with MySQL databases With more than 4 million active installations, MySQL is the world's most popular open-source database. Known for its speed, high reliability, and ease of use, MySQL is rapidly...

The MySQL certification program is a carefully developed, high-quality certification process that can help you prove your skills in using, maintaining, and administering MySQL database ...

The authoritative study guide to prepare tor the MySOL The MySQL certification program is a carefully developed, high-quality certification process that can help you prove your skills in using, maintaining, and administering MySQL database servers and other technologies from MySQL...

Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. MySQL provides several features that can protect you from outages, whether you're running directly on the hardware, on virtual machines, or in the cloud. This book shows you how to use these features effectively, and helps you determine which combination of features will give you the most reliable system for a price you can afford.

With more than 4 million active installations, MySQL is the world's most popular open-source database. Known for its speed, high reliability, and ease of use, MySQL is rapidly becoming a low-cost alternative...

Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008 whether you re new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you ll master the concepts, tools, and techniques for building solutions that deliver intelligence and business value exactly where users want it.