Microsoft SQL Server 2008 Bible - Softcover

Nielsen, Paul; White, Mike; Parui, Uttam

Softcover

ISBN 10: 0470257040 ISBN 13: 9780470257043

Publisher: John Wiley & Sons, 2009

Synopsis

Harness the power of SQL Server, Microsoft's high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible . Learn the best practices, tips, and tricks from this comprehensive tutorial and reference, which includes specific examples and sample code, with nearly every task demonstrated in both a graphical and SQL code method. Understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate all the new features of the 2008 release.

About this title

About the Author

Paul Nielsen, SQL Server MVP, organizes the annual Colorado PASSCamp and serves on the PASS Board of Directors. He's the author of the SQL Server Bible series (Wiley), and presenter of the Total Training SQL Server Development video. Paul's speaking schedule for 2007 includes:?PASS (Summit and chapters), SQL Server Open World (Denmark), SQL Teach (Montreal and Vancouver), and his Smart Database Design Seminar. He offers free screencasts at www.SQLServerBible.com. Mike White is a data analysis and SQL BI expert. He was the principle BI architect for a major Wall Street analysis firm and was a founding member of a BI consulting firm. Mike is a popular speaker on the BI circuit and a member of the prestigious PASS Speaker's Bureau. He also serves as President of the Boulder Colorado PASS Chapter. Uttam Parui is currently a Senior Premier Field Engineer at Microsoft. In this role, he delivers Microsoft SQL Server consulting and support for designated strategic customers. He acts as a resource for ongoing SQL planning and deployment, analysis of current issues, migration to new SQL environments. He is also responsible for SQL workshops and training for customer's existing support staff. He has worked with SQL Server more than 10 years.

From the Back Cover

"Paul Nielsen brings his passion for SQL Server and his long years of experience with this product into every page of the SQL Server 2008 Bible."
&;Kalen Delaney, SQL Server MVP

Get ready for SQL Server 2008

Whether you're a database developer, DBA, or BI Developer, SQL Server 2008 promises to change the way you deliver enterprise data solutions. Open this detailed, experience-based guide for clear explanations of the concepts balanced with real-world examples and best practices gleaned from years of field and consulting experience. SQL Server is an immense product &; this book is your guide to the strategies and details that matter most.

• Master the data architecture concepts that drive database technologies

• Write elegant set-based queries that respond well to a comprehensive indexing strategy

• Code an efficient and robust data abstraction layer with stored procedures

• Learn the best way to connect to SQL Server with ADO or Microsoft Access

• Use PowerShell and Policy-based Management to better administer your servers

• Use Analysis Services, MDX, and Excel to analyze data trends

• Optimize performance with data compression, resource governor, and partitioning

Companion Web Site
Please visit www.sqlserverbible.com to download all the sample databases and code, watch screencasts that walk through key features, sign up for the SQL Server Bible eNewsletter, find additional SQL Server utilities and samples, and find out about the authors' seminars and speaking schedules.

• Manage enterprise data servers with ease
• Develop scalable and flexible databases
• Analyze data with SQL Server's BI Suite
• The book you need to succeed!

Edition details

• Publisher: John Wiley & Sons
• Publication date: 2009
• Language: English
• ISBN 10: 0470257040
• ISBN 13: 9780470257043
• Binding: Paperback
• Number of pages: 1680