- Paperback: 1416 pages
- Publisher: Wiley; 1 edition (August 28, 2012)
- Language: English
- ISBN-10: 1118106873
- ISBN-13: 978-1118106877
- Product Dimensions: 7.3 x 2.3 x 9.1 inches
- Shipping Weight: 4.6 pounds (View shipping rates and policies)
- Average Customer Review: 13 customer reviews
- Amazon Best Sellers Rank: #193,991 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Microsoft SQL Server 2012 Bible 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Frequently bought together
Customers who bought this item also bought
Customers who viewed this item also viewed
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Suddenly I was wide awake as three black clad warriors leapt out of the dark, inky shadows. Now, I'm not saying these were IT Ninjas, but I don't know many warriors who run around clothed head to toe in black footie pajamas with pocket protectors.
Frantically I reached into my backpack for something to defend myself with. What do I pull out but my trusty SQL Server 2012 Bible.
IT Ninja number 1 swung at me with his shiny blade. Quickly I opened the book, and caught the blade between its pages. The binding on this tome is unusually strong, probably due to the fact it has over 1400 pages of SQL Server 2012 goodness. Twisting, I was able to dislodge the sword from his hands while gut kicking him. IT Ninja number 1 stumbled backward, tripping over a mop bucket. This was as big a surprise to me as it was to him, the IT area was so dark and dingy I didn't even know we had a janitor.
But I had little time to speculate on the cleaning staff at my company, as IT Ninja number two was already attacking, nun chucks swirling. Holding the SQL Server 2012 Bible up at just the right angle, the nun chucks bounced back, smacking IT Ninja two right in the face and rendering him unconscious. I guess when a book has 59 chapters on subjects from installation to maintenance, analytic cubes to reporting, it's bound to be a bit springy.
IT Ninja number 3 flexed his arm and hurled three throwing stars at me. I don't know what they make book covers out of these days, but the cover of my SQL Server 2012 Bible was able to deflect all three stars, which wound up embedding themselves into a nearby wall. It was my turn to toss a missile in his direction. Flinging my tome of infinite SQL Server 2012 knowledge at him, its 4.6 pounds made an especially deadly weapon. My aim was true, the book hit him square in the face knocking him unconscious. I scooped my SQL Server 2012 Bible off the floor, just in time to see IT Ninja number one getting up off the floor.
Fortunately for me, IT Ninja number one was a bit clumsy. Leaping over the mop bucket he tripped over the mop and landed with a thud, his head mere inches at my feet. I held up my ad-hoc weapon and let it go. My SQL Server 2012 Bible swished through the air, impacting my last foe cleanly on the noggin and taking him out for the count.
I picked it up, dusted it off, and marveled as it was no worse for the wear. I shouldn't have been surprised. When industry experts such as Adam Jorgensen, Jorge Segarra, Aaron Nelson, Jose Chinchilla and Patrick LeBlanc get together, they produce a quality product.
About that time another figure emerged from the dark, inky shadows. "We'll take it from here kid." Said the deep, gravelly voice. He was clad in dark grey overalls, with the name "Nick" sewn into them. But with one hand he ripped them off, revealing his true outfit. All in black, his long leather trench coat nearly came to the floor. His goatee and eye patch made him even more menacing than the IT Ninjas had been. I clutched my beloved SQL Server 2012 Bible to me, taking comfort from its familiar pages.
Out of the dark, inky shadows, armor clad soldiers appeared, quickly dragging the IT Ninjas away. I made a mental note to talk to my boss about the lighting down here, as there were entirely too many dark, inky shadows for my liking.
"That's some book kid." The `janitor' said. "Its well organized, comprehensive index alone would make a formidable weapon."
"That's not just any book!" I exclaimed proudly, waving the Excalibur of SQL Server 2012 books above my head. "It's my SQL Server 2012 Bible!"
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/
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).