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.
Microsoft SQL Server 2008 Bible
and over one million other books are available for Amazon Kindle. Learn more
 |
| ||||||||||||||||||
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now |
Book Description
Frequently Bought Together
Editorial Reviews
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
—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!
Product Details
Would you like to update product info or give feedback on images? |
Customer Reviews
Most Helpful Customer Reviews
5 of 5 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
SQL Server 2008 Bible is an absolute must for anyone wishing to enhance their SQL Server skills. There is information in there for everyone from a Developer being able to write more optimal queries to the Database Administrator who has much more complicated tasks to accomplish. This book took my knowledge from a very basic level as a developer to a level where I became a database answer point for many on my development team. I strongly recommend this book to anyone that wishes to enhance their SQL Server knowledge. This book is also one of the few that I always have within easy reach when working on development tasks.
7 of 8 people found the following review helpful
By Phillip Senn
Format:Paperback|Amazon Verified Purchase
I have the two previous editions (2000 and 2005).
This one is heavier than the other two - 1642 pages compared to 1293 and 890.
And the paper stock is better as well.
The tone is almost conversational in that Paul Nielsen comes up with likely scenarios to show the syntax of a command.
You can tell that a lot of his tips come from hindsight. Here's an example of a Best Practice tip found on page 263: "Use a join to pull data from two data sources that can be filtered or manipulated as a whole after the join. If the data must be manipulated prior to the join, then use a derived table subquery."
That piece of advice comes from someone who has had to tackle problems using both techniques.
And he's not afraid to tell you worst practices either. Page 547: "Any table design that requires sparse columns is a horrible design."
This is especially helpful if you're learning a new feature and want to know if it's worth the effort.
Don't think that this is an A-Z reference manual.
Chapter 53 is Mr. Nielsen's "AutoAudit", which is quite a nifty code generator to add auditing to your tables.
This one is heavier than the other two - 1642 pages compared to 1293 and 890.
And the paper stock is better as well.
The tone is almost conversational in that Paul Nielsen comes up with likely scenarios to show the syntax of a command.
You can tell that a lot of his tips come from hindsight. Here's an example of a Best Practice tip found on page 263: "Use a join to pull data from two data sources that can be filtered or manipulated as a whole after the join. If the data must be manipulated prior to the join, then use a derived table subquery."
That piece of advice comes from someone who has had to tackle problems using both techniques.
And he's not afraid to tell you worst practices either. Page 547: "Any table design that requires sparse columns is a horrible design."
This is especially helpful if you're learning a new feature and want to know if it's worth the effort.
Don't think that this is an A-Z reference manual.
Chapter 53 is Mr. Nielsen's "AutoAudit", which is quite a nifty code generator to add auditing to your tables.
8 of 10 people found the following review helpful
Format:Paperback
I was introduced to this huge informative book by one of my friends at work place. This is a great reference book for almost everyone starting from beginners to advanced database programmers/admins. It is very difficult to cover all aspects of SQL Server in a single book. Howver, the authr(s) have done a good job in covering almost all the features of SQL Servers. This book helps developers who want to know one and everything in SQL Server. However, certain chapers such as "Service Broker" could have been detailed out more considering that these are more advanced. I especially liked the Partitioning, LINQ, Change Data Capture. It has touched upon the Business intelligence and it could have been done better. However, as I said it is already a huge book and adding more materials would have been even more. Rather this solves the purpose to a great deal as a reference book for almost all domains DBAs and developers to jump start in SQL Server.
Most Recent Customer Reviews
5.0 out of 5 stars
Great book, one of the best for SQL Server
I'll keep this short - if you're looking for a strong SQL Server 2008 written by a passionate author, buy this book. Read more
Published 12 months ago by mark eckeard
5.0 out of 5 stars
SQL Server Bible Review
This book is fantastic for beginners like myself, and has been extremely helpful with manuveuering through the Management Studio. Read more
Published 17 months ago by NancyJayneB
4.0 out of 5 stars
Lots of information for the price
Shipping was fast and the book in mint condition. The book is good assuming you have some decent knowledge of using SQL as a user. Read more
Published 21 months ago by AmitP
3.0 out of 5 stars
Found a bug in book
Hi,
I was going through the section windowing and Partioning.
Accoring to the book, Ordering happens first and partioning happens next. Read more
I was going through the section windowing and Partioning.
Accoring to the book, Ordering happens first and partioning happens next. Read more
Published on February 21, 2011 by shashi
4.0 out of 5 stars
Almost perfect!
This book is an incredible book, really everything that you want to know about Sql Server 2008 except the HAVING phrase. There is one mention of it but no examples. Read more
Published on December 4, 2010 by Boca Cat
4.0 out of 5 stars
Another solid manual
The SQL Server 2008 Bible continues Wiley's tradition of outstandingly helpful software manuals. The only problem is that it does not include an electronic version on disk.
Published on November 17, 2010 by William F. Helmich
5.0 out of 5 stars
Essential Book for SqlServer/DBA developers
This book it's very complete, Covers almost all features of Sql Server 2008, not in depth, but it gives a nice direction for many features. Read more
Published on April 5, 2010 by David G. Portella
5.0 out of 5 stars
Understands SQL Server
Paul Nielson is one of the few people out there who really understands SQL Server in depth. This book works very well with the author's video course, published by Total Training.
Published on January 11, 2010 by PK
