Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems. Discover how to: Install and work with core components and tools Create tables and index structures Manipulate and retrieve data Secure, manage, back up, and recover databases Apply tuning plus optimization techniques to generate high-performing database applications Optimize availability through clustering, database mirroring, and log shipping Tap business intelligence tools—Reporting, Analysis, and Integration Services CD features: Practice exercises and code samples Fully searchable eBook For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
To Do This Test or learn the features of Reporting Services Use SQL Server 2008 Evaluation Edition in a singleserver deployment. ... click Service Account, specify a builtin or Windows user account and its password, and click Apply.
Teach yourself to use SQL Server 2008 Analysis Services for business intelligence—one step at a time.
Cuddy ...
This convenient guide offers you quick referencing for the product and database topics you need most.
Includes all-new examples and a new practice database Previous editions sold 43,000 copies
Teach yourself the Multidimensional Expressions (MDX) query language—one step at a time.
If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for.
A unique book-and-video package for learning Microsoft SQL Server Integration Services If you need a practical, hands-on introduction to Microsoft SQL Server 2008 Integration Services (SSIS), this book and video package from foremost SSIS ...
This book is intended for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features, such as Integration Services.
And because you want to get rolling with it right away, this book is the place to come. Here you find what's new in this version and how to build and maintain tables; retrieve, analyze, and report data; and keep your database healthy.