Microsoft SQL Server 2012 Bible Paperback – Aug 28 2012
|New from||Used from|
Customers Who Bought This Item Also Bought
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your e-mail address or mobile phone number.
From the Back Cover
Something for you on every page
If you're a database administrator or developer, this book is your complete, one-stop resource for SQL Server 2012. The authors provide in-depth coverage of core techniques, best practices, and smart workarounds, as well as plenty of examples and sample code. They also fully cover such new features as AlwwaysOn connectivity, new indexes, Power View, Master Data Services, Data Quality Services, PowerPivot for SQL Server 2012, and more.
- Thoroughly explore all new features in SQL Server 2012
- Understand advanced T-SQL data types and querying techniques
- Ensure high availability for mission-critical applications
- Start using SQL Azure for cloud computing
- Master new security and compliance settings
- Leverage your data with tools for BI, data warehousing, and Enterprise Information Management solutions
- Get up to speed on the latest enhancements to the BI toolset
About the Author
Adam Jorgensen is the President of Pragmatic Works Consulting, a Director for the Professional Association of SQL Server (PASS), a SQL Server MVP, and a well-known speaker, author, and executive mentor. His focus is on helping companies realize their full potential using their data in ways they have not previously imagined. Adam is very involved in the community, delivering more than 75 community sessions per year. Based in Jacksonville, FL, Adam has written and contributed to five previous books on SQL Server, analytics, and SharePoint. Coauthors Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, and Aaron Nelson are well-known experts on SQL Server and Business Intelligence.
Inside This Book(Learn More)
What Other Items Do Customers Buy After Viewing This Item?
Most Helpful Customer Reviews on Amazon.com (beta)
If you are already intimately familiar with previous versions of MS SQL (2005-2008), then the value of this book will be limited.
There simply isn't enough advanced information. But there is plenty of beginner to intermediate knowledge that would be very helpful, which I think is the target audience of this book.
1)Comprehensive coverage of all aspects of MS SQL 2012 (much of the knowledge is also applicable to SQL 2005 and 2008).
2)Well written and good explanations. I particularly like the sample code in the text.
1)There is a lot of breadth but not a ton of depth. Many topics are covered only superficially.
2)Not enough information on how MS SQL 2012 is different from MS SQL 2008.
If you can get past a few errors, this book will be highly valuable for you if you are looking at a job that relies heavily on SQL (query performance tuning, custom reporting, T-SQL, etc).
I know that is partly the nature of the book, because it does try to cover everything, but if someone is looking for in-depth examples on specific topics, perhaps a more specialized book is a better choice.
But for anyone looking for a general purpose reference for SQL Server, this is excellent, and should be the first SQL Server book you purchase.
In this case, the book focuses on Microsoft SQL Server 2012, a professional-level and distributed DBMS with various types of licenses. The SQL Server 2012 Express edition is even distributed free of charge, with the only limit of 10 GB per database, to allow its use for limited applications (study, personal productivity, small business realities, and so on).
The book is structured very well: start with the basics, then move on to programming with T-SQL and stored procedures, then it provides the necessary informations for its use in a company, including its Business Intelligence Platform.
In the part relating to the design of the database, there is an explanation of 'theory of databases' (keys, relationships, normal forms), absolutely essential for anyone who has not practice with databases, but also for those who need only a simple memory "refreshing".
Finally, if you go on the website (http://eu.wiley.com/WileyCDA/WileyTitle/productCd-1118106873.html ), you can find all the examples and code fragments TSQL.
In conclusion, a remarkable book and essential for anyone who wants to experiment with SQL Server 2012.
Here is the list of the 59 chapters of the book:
Part I: Laying the Foundations 1
Chapter 1: The World of SQL Server
Chapter 2: Data Architecture
Chapter 3: Installing SQL Server
Chapter 4: Client Connectivity
Chapter 5: SQL Server Management and Development Tools
Part II: Building Databases and Working with Data
Chapter 6: Introducing Basic Query Flow
Chapter 7: Relational Database Design and Creating the Physical Database Schema
Chapter 8: Data Types, Expressions, and Scalar Functions
Chapter 9: Merging Data with Joins, Subqueries, and CTEs
Chapter 10: Aggregating, Windowing, and Ranking Data
Chapter 11: Projecting Data Through Views
Chapter 12: Modifying Data In SQL Server
Part III: Advanced T-SQL Data Types and Querying Techniques
Chapter 13: Working with Hierarchies
Chapter 14: Using XML Data
Chapter 15: Executing Distributed Queries
Part IV: Programming with T-SQL
Chapter 16: Programming with T-SQL
Chapter 17: Developing Stored Procedures
Chapter 18: Building User-Defi ned Functions
Part V: Enterprise Data Management
Chapter 19: Confi guring SQL Server
Chapter 20: Policy Based Management
Chapter 21: Backup and Recovery Planning
Chapter 22: Maintaining the Database
Chapter 23: Transferring Databases
Chapter 24: Database Snapshots
Chapter 25: Asynchronous Messaging with Service Broker
Chapter 26: Log Shipping
Chapter 27: Database Mirroring
Chapter 28: Replicating Data
Chapter 29: Clustering
Chapter 30: Confi guring and Managing SQL Server with PowerShell
Chapter 31: Managing Data in Windows Azure SQL Database
Part VI: Securing Your SQL Server
Chapter 32: Authentication Types in SQL Server
Chapter 33: Authorizing Securables
Chapter 34: Data Encryption
Chapter 35: Row-Level Security
Part VII: Monitoring and Auditing
Chapter 36: Creating Triggers
Chapter 37: Performance Monitor and PAL
Chapter 38: Using Profi ler and SQL Trace
Chapter 39: Wait States
Chapter 40: Extended Events
Chapter 41: Data Change Tracking and Capture
Chapter 42: SQL Audit
Chapter 43: Management Data Warehouse
Part VIII: Performance Tuning and Optimization
Chapter 44: Interpreting Query Execution Plans
Chapter 45: Indexing Strategies
Chapter 46: Maximizing Query Plan Reuse
Chapter 47: Managing Transactions, Locking, and Blocking
Chapter 48: Data Compression
Chapter 49: Partitioning
Chapter 50: Resource Governor
Part IX: Business Intelligence
Chapter 51: Business Intelligence Database Design
Chapter 52: Building, Deploying, and Managing ETL Workflows in Integration Services
Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX
Chapter 54: Confi guring and Administering Analysis Services
Chapter 55: Authoring Reports in Reporting Services
Chapter 56: Configuring and Administering Reporting Services
Chapter 57: Data Mining with Analysis Services
Chapter 58: Creating and Deploying BI Semantic Models
Chapter 59: Creating and Deploying Power View Reports
Italian version of this book review: http://fsharpdazero.wordpress.com/2014/11/09/recensione-del-libro-sql-server-2012-bible-2/
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Microsoft > Development > SQL Server
- Books > Computers & Technology > Networking & Cloud Computing > Data in the Enterprise > Client-Server Systems
- Books > Computers & Technology > Web Development > Programming > SQL