{"product_id":"microsoft-sql-server-2012-bible-isbn-9781118106877","title":"Microsoft SQL Server 2012 Bible","description":"\u003cb\u003eHarness the powerful new SQL Server 2012\u003c\/b\u003e  \u003cp\u003eMicrosoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, \u003ci\u003eMicrosoft SQL Server 2012 Bible\u003c\/i\u003e teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak.\u003c\/p\u003e \u003cp\u003eThe book is crammed with specific examples, sample code, and a host of tips, workarounds, and best practices. In addition, downloadable code is available from the book's companion web site, which you can use to jumpstart your own projects.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eServes as an authoritative guide to Microsoft's SQL Server 2012 for database administrators and developers\u003c\/li\u003e \u003cli\u003eCovers all the software's new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications\u003c\/li\u003e \u003cli\u003eExplains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services\u003c\/li\u003e \u003cli\u003eDemonstrates tasks both graphically and in SQL code to enhance your learning\u003c\/li\u003e \u003cli\u003eProvides source code from the companion web site, which you can use as a basis for your own projects\u003c\/li\u003e \u003cli\u003eExplores tips, smart workarounds, and best practices to help you on the job\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eGet thoroughly up to speed on SQL Server 2012 with \u003ci\u003eMicrosoft SQL Server 2012 Bible\u003c\/i\u003e.\u003c\/p\u003e  \u003cp\u003eIntroduction    xxix\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I: Laying the Foundations 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: The World of SQL Server    3\u003c\/p\u003e \u003cp\u003eChapter 2: Data Architecture     15\u003c\/p\u003e \u003cp\u003eChapter 3: Installing SQL Server     31\u003c\/p\u003e \u003cp\u003eChapter 4: Client Connectivity       71\u003c\/p\u003e \u003cp\u003eChapter 5: SQL Server Management and Development Tools     81\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Building Databases and Working with Data 109\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 6: Introducing Basic Query Flow    111\u003c\/p\u003e \u003cp\u003eChapter 7: Relational Database Design and Creating the Physical Database Schema      143\u003c\/p\u003e \u003cp\u003eChapter 8: Data Types, Expressions, and Scalar Functions      173\u003c\/p\u003e \u003cp\u003eChapter 9: Merging Data with Joins, Subqueries, and CTEs     213\u003c\/p\u003e \u003cp\u003eChapter 10: Aggregating, Windowing, and Ranking Data    249\u003c\/p\u003e \u003cp\u003eChapter 11: Projecting Data Through Views     271\u003c\/p\u003e \u003cp\u003eChapter 12: Modifying Data In SQL Server      291\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Advanced T-SQL Data Types and Querying Techniques 323\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 13: Working with Hierarchies      325\u003c\/p\u003e \u003cp\u003eChapter 14: Using XML Data       339\u003c\/p\u003e \u003cp\u003eChapter 15: Executing Distributed Queries      367\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Programming with T-SQL 387\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 16: Programming with T-SQL       389\u003c\/p\u003e \u003cp\u003eChapter 17: Developing Stored Procedures     431\u003c\/p\u003e \u003cp\u003eChapter 18: Building User-Defi ned Functions    453\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Enterprise Data Management 467\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 19: Confi guring SQL Server     469\u003c\/p\u003e \u003cp\u003eChapter 20: Policy Based Management     531\u003c\/p\u003e \u003cp\u003eChapter 21: Backup and Recovery Planning     547\u003c\/p\u003e \u003cp\u003eChapter 22: Maintaining the Database     585\u003c\/p\u003e \u003cp\u003eChapter 23: Transferring Databases     615\u003c\/p\u003e \u003cp\u003eChapter 24: Database Snapshots      635\u003c\/p\u003e \u003cp\u003eChapter 25: Asynchronous Messaging with Service Broker      647\u003c\/p\u003e \u003cp\u003eChapter 26: Log Shipping      661\u003c\/p\u003e \u003cp\u003eChapter 27: Database Mirroring     685\u003c\/p\u003e \u003cp\u003eChapter 28: Replicating Data       727\u003c\/p\u003e \u003cp\u003eChapter 29: Clustering      745\u003c\/p\u003e \u003cp\u003eChapter 30: Confi guring and Managing SQL Server with PowerShell  769\u003c\/p\u003e \u003cp\u003eChapter 31: Managing Data in Windows Azure SQL Database   801\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: Securing Your SQL Server 831\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 32: Authentication Types in SQL Server     833\u003c\/p\u003e \u003cp\u003eChapter 33: Authorizing Securables     841\u003c\/p\u003e \u003cp\u003eChapter 34: Data Encryption       853\u003c\/p\u003e \u003cp\u003eChapter 35: Row-Level Security     861\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VII: Monitoring and Auditing 877\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 36: Creating Triggers      879\u003c\/p\u003e \u003cp\u003eChapter 37: Performance Monitor and PAL     909\u003c\/p\u003e \u003cp\u003eChapter 38: Using Profi ler and SQL Trace    919\u003c\/p\u003e \u003cp\u003eChapter 39: Wait States    931\u003c\/p\u003e \u003cp\u003eChapter 40: Extended Events       937\u003c\/p\u003e \u003cp\u003eChapter 41: Data Change Tracking and Capture     945\u003c\/p\u003e \u003cp\u003eChapter 42: SQL Audit      967\u003c\/p\u003e \u003cp\u003eChapter 43: Management Data Warehouse     977\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VIII: Performance Tuning and Optimization 993\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 44: Interpreting Query Execution Plans     995\u003c\/p\u003e \u003cp\u003eChapter 45: Indexing Strategies   1005\u003c\/p\u003e \u003cp\u003eChapter 46: Maximizing Query Plan Reuse     1041\u003c\/p\u003e \u003cp\u003eChapter 47: Managing Transactions, Locking, and Blocking    1047\u003c\/p\u003e \u003cp\u003eChapter 48: Data Compression    1097\u003c\/p\u003e \u003cp\u003eChapter 49: Partitioning      1109\u003c\/p\u003e \u003cp\u003eChapter 50: Resource Governor    1131\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IX: Business Intelligence 1141\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 51: Business Intelligence Database Design    1143\u003c\/p\u003e \u003cp\u003eChapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services      1155\u003c\/p\u003e \u003cp\u003eChapter 53: Building Multidimensional Cubes in Analysis Services with MDX   1195\u003c\/p\u003e \u003cp\u003eChapter 54: Confi guring and Administering Analysis Services     1223\u003c\/p\u003e \u003cp\u003eChapter 55: Authoring Reports in Reporting Services   1233\u003c\/p\u003e \u003cp\u003eChapter 56: Configuring and Administering Reporting Services    1261\u003c\/p\u003e \u003cp\u003eChapter 57: Data Mining with Analysis Services    1281\u003c\/p\u003e \u003cp\u003eChapter 58: Creating and Deploying BI Semantic Models      1299\u003c\/p\u003e \u003cp\u003eChapter 59: Creating and Deploying Power View Reports      1327\u003c\/p\u003e \u003cp\u003eIndex      1347\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eAdam Jorgensen\u003c\/b\u003e 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 \u003cb\u003eJorge Segarra, Patrick LeBlanc, Jose Chinchilla, and Aaron Nelson\u003c\/b\u003e are well-known experts on SQL Server and Business Intelligence.\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eSomething for you on every page\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIf 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.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eThoroughly explore all new features in SQL Server 2012\u003c\/li\u003e \u003cli\u003eUnderstand advanced T-SQL data types and querying techniques\u003c\/li\u003e \u003cli\u003eEnsure high availability for mission-critical applications\u003c\/li\u003e \u003cli\u003eStart using SQL Azure for cloud computing\u003c\/li\u003e \u003cli\u003eMaster new security and compliance settings\u003c\/li\u003e \u003cli\u003eLeverage your data with tools for BI, data warehousing, and Enterprise Information Management solutions\u003c\/li\u003e \u003cli\u003eGet up to speed on the latest enhancements to the BI toolset\u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989623783653,"sku":"NP9781118106877","price":59.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781118106877.jpg?v=1761784854","url":"https:\/\/k12savings.com\/products\/microsoft-sql-server-2012-bible-isbn-9781118106877","provider":"K12savings","version":"1.0","type":"link"}