Perfect Paperback: 672 pages
Publisher: Microsoft Press (September 19, 2008)
Language: English
ISBN-10: 0735625891
ISBN-13: 978-0735625891Product Description
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, creating indexes and views, performing backups and recovery, replicating transactions, tuning performance, managing server activity, importing and exporting data, or performing other key tasks. Featuring quick-reference tables, lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot whether you re at your desk or in the field!
Key Book Benefits
Provides fast facts and immediate reference for administering SQL Server 2008 Delivers must-know details for taking advantage of the improved scalability, security features, and management tools in SQL Server 2008 Features concise tables, easy-to-scan lists, and step-by-step instructions for fast answers, wherever you need them

About the Author
William R. Stanek is a Microsoft Most Valuable Professional with more than 20 years of experience in systems management and advanced programming. He is an award-winning author who s written more than 65 books, including WINDOWS SERVER® 2008 INSIDE OUT. He is series editor for the ADMINISTRATOR'S POCKET CONSULTANT line of books.

Pro SQL Server 2008 Relational Database Design and Implementation/by Louis Davidson (Author), Kevin Kline (Author), Scott Klein (Author), Kurt Windisch (Author)
Description
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.

World Wide Web Database Developer's Guide/by Mark Swank (Author), Drew Kittel (Author)
Description
The World Wide Web Database Developer's Guide leaves readers with a skillset that will allow them to quickly and professionally convert and present database information on the Internet and World Wide Web. The CD includes all the source code fromthe book, plus a collection of Web database development tools, including commercial Web database access tools.

New Trends in Data Warehousing and Data Analysis/by Stanislaw Kozielski (Editor), Robert Wrembel (Editor)
Description
Most of modern enterprises, institutions, and organizations rely on knowledge-based management systems. In these systems, knowledge is gained from data analysis. Nowadays, knowledge-based management systems include data warehouses as their core components. The purpose of building a data warehouse is twofold. Firstly, to integrate multiple heterogeneous, autonomous, and distributed data sources within an enterprise. Secondly, to provide a platform for advanced, complex, and efficient data analysis. Data integrated in a data warehouse are analyzed by the so-called On-Line Analytical Processing (OLAP) applications designed among others for discovering trends, patterns of behavior, and anomalies as well as for finding dependencies between data. Massive amounts of integrated data and the complexity of integrated data that more and more often come from WEB-based, XML-based, spatio-temporal, object, and multimedia systems, make data integration and processing challenging.
The objective of NEW TRENDS IN DATA WAREHOUSING AND DATA ANALYSIS is fourfold: First, to bring together the most recent research and practical achievements in the DW and OLAP technologies. Second, to open and discuss new, just emerging areas of further development. Third, to provide the up-to-date bibliography of published works and the resource of research achievements for anyone interested in up-to-date data warehouse issues. And, finally, to assist in the dissemination of knowledge in the field of advanced DW and OLAP.

Microsoft Access 2007 Data Analysis/by Michael Alexander (Author)
Description
Chart a course for more effective data analysis with Access 2007. With this resource, you’ll learn how Access 2007 offers powerful functionality that may be better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful ways, quickly and easily slice it into various views, automate redundant analysis, and save time—all using Access. If you know a bit about table structures and formulas as well as data analysis, start thinking outside the chart.Data analysis is more than crunching numbers and turning them into charts and graphs. Certainly Excel can do that, but you may be surprised to discover that Access 2007 offers powerful functionality that may be even better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful ways, quickly and easily slice it into various views, automate redundant analysis, and save time, all using Access. If you know a bit about table structures and formulas as well as data analysis, start thinking outside the chart.
Apply Access 2007 to the task of collecting, transforming, analyzing, and presenting data
Create custom functions, perform batch analysis, and develop automated procedures that essentially run themselves
Build effective query skills
Learn to clean and shape raw data, create and utilize custom calculations, work with dates, and perform advanced time analysis
Work with SQL statements, PivotTables, and PivotCharts
Perform advanced statistical analysis using subqueries and domain aggregate functions
See how to use macros and Visual Basic® for Applications to enhance data analysis