Details

Microsoft SQL Server 2012 Bible


Microsoft SQL Server 2012 Bible


Bible, Band 773 1. Aufl.

von: Adam Jorgensen, Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, Aaron Nelson

38,99 €

Verlag: Wiley
Format: PDF
Veröffentl.: 09.08.2012
ISBN/EAN: 9781118286821
Sprache: englisch
Anzahl Seiten: 1416

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.

Beschreibungen

<b>Harness the powerful new SQL Server 2012</b> <p>Microsoft 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, <i>Microsoft SQL Server 2012 Bible</i> 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.</p> <p>The 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.</p> <ul> <li>Serves as an authoritative guide to Microsoft's SQL Server 2012 for database administrators and developers</li> <li>Covers 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</li> <li>Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services</li> <li>Demonstrates tasks both graphically and in SQL code to enhance your learning</li> <li>Provides source code from the companion web site, which you can use as a basis for your own projects</li> <li>Explores tips, smart workarounds, and best practices to help you on the job</li> </ul> <p>Get thoroughly up to speed on SQL Server 2012 with <i>Microsoft SQL Server 2012 Bible</i>.</p>
<p>Introduction    xxix</p> <p><b>Part I: Laying the Foundations 1</b></p> <p>Chapter 1: The World of SQL Server    3</p> <p>Chapter 2: Data Architecture     15</p> <p>Chapter 3: Installing SQL Server     31</p> <p>Chapter 4: Client Connectivity       71</p> <p>Chapter 5: SQL Server Management and Development Tools     81</p> <p><b>Part II: Building Databases and Working with Data 109</b></p> <p>Chapter 6: Introducing Basic Query Flow    111</p> <p>Chapter 7: Relational Database Design and Creating the Physical Database Schema      143</p> <p>Chapter 8: Data Types, Expressions, and Scalar Functions      173</p> <p>Chapter 9: Merging Data with Joins, Subqueries, and CTEs     213</p> <p>Chapter 10: Aggregating, Windowing, and Ranking Data    249</p> <p>Chapter 11: Projecting Data Through Views     271</p> <p>Chapter 12: Modifying Data In SQL Server      291</p> <p><b>Part III: Advanced T-SQL Data Types and Querying Techniques 323</b></p> <p>Chapter 13: Working with Hierarchies      325</p> <p>Chapter 14: Using XML Data       339</p> <p>Chapter 15: Executing Distributed Queries      367</p> <p><b>Part IV: Programming with T-SQL 387</b></p> <p>Chapter 16: Programming with T-SQL       389</p> <p>Chapter 17: Developing Stored Procedures     431</p> <p>Chapter 18: Building User-Defi ned Functions    453</p> <p><b>Part V: Enterprise Data Management 467</b></p> <p>Chapter 19: Confi guring SQL Server     469</p> <p>Chapter 20: Policy Based Management     531</p> <p>Chapter 21: Backup and Recovery Planning     547</p> <p>Chapter 22: Maintaining the Database     585</p> <p>Chapter 23: Transferring Databases     615</p> <p>Chapter 24: Database Snapshots      635</p> <p>Chapter 25: Asynchronous Messaging with Service Broker      647</p> <p>Chapter 26: Log Shipping      661</p> <p>Chapter 27: Database Mirroring     685</p> <p>Chapter 28: Replicating Data       727</p> <p>Chapter 29: Clustering      745</p> <p>Chapter 30: Confi guring and Managing SQL Server with PowerShell  769</p> <p>Chapter 31: Managing Data in Windows Azure SQL Database   801</p> <p><b>Part VI: Securing Your SQL Server 831</b></p> <p>Chapter 32: Authentication Types in SQL Server     833</p> <p>Chapter 33: Authorizing Securables     841</p> <p>Chapter 34: Data Encryption       853</p> <p>Chapter 35: Row-Level Security     861</p> <p><b>Part VII: Monitoring and Auditing 877</b></p> <p>Chapter 36: Creating Triggers      879</p> <p>Chapter 37: Performance Monitor and PAL     909</p> <p>Chapter 38: Using Profi ler and SQL Trace    919</p> <p>Chapter 39: Wait States    931</p> <p>Chapter 40: Extended Events       937</p> <p>Chapter 41: Data Change Tracking and Capture     945</p> <p>Chapter 42: SQL Audit      967</p> <p>Chapter 43: Management Data Warehouse     977</p> <p><b>Part VIII: Performance Tuning and Optimization 993</b></p> <p>Chapter 44: Interpreting Query Execution Plans     995</p> <p>Chapter 45: Indexing Strategies   1005</p> <p>Chapter 46: Maximizing Query Plan Reuse     1041</p> <p>Chapter 47: Managing Transactions, Locking, and Blocking    1047</p> <p>Chapter 48: Data Compression    1097</p> <p>Chapter 49: Partitioning      1109</p> <p>Chapter 50: Resource Governor    1131</p> <p><b>Part IX: Business Intelligence 1141</b></p> <p>Chapter 51: Business Intelligence Database Design    1143</p> <p>Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services      1155</p> <p>Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX   1195</p> <p>Chapter 54: Confi guring and Administering Analysis Services     1223</p> <p>Chapter 55: Authoring Reports in Reporting Services   1233</p> <p>Chapter 56: Configuring and Administering Reporting Services    1261</p> <p>Chapter 57: Data Mining with Analysis Services    1281</p> <p>Chapter 58: Creating and Deploying BI Semantic Models      1299</p> <p>Chapter 59: Creating and Deploying Power View Reports      1327</p> <p>Index      1347</p>
<p><b>Adam Jorgensen</b> 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 <b>Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, and Aaron Nelson</b> are well-known experts on SQL Server and Business Intelligence.</p>
<p><b>Something for you on every page</b></p> <p>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.</p> <ul> <li>Thoroughly explore all new features in SQL Server 2012</li> <li>Understand advanced T-SQL data types and querying techniques</li> <li>Ensure high availability for mission-critical applications</li> <li>Start using SQL Azure for cloud computing</li> <li>Master new security and compliance settings</li> <li>Leverage your data with tools for BI, data warehousing, and Enterprise Information Management solutions</li> <li>Get up to speed on the latest enhancements to the BI toolset</li> </ul>

Diese Produkte könnten Sie auch interessieren:

Cyber Security and Digital Forensics
Cyber Security and Digital Forensics
von: Mangesh M. Ghonge, Sabyasachi Pramanik, Ramchandra Mangrulkar, Dac-Nhuong Le
PDF ebook
190,99 €
Smart Systems for Industrial Applications
Smart Systems for Industrial Applications
von: C. Venkatesh, N. Rengarajan, P. Ponmurugan, S. Balamurugan
EPUB ebook
190,99 €
Green Internet of Things and Machine Learning
Green Internet of Things and Machine Learning
von: Roshani Raut, Sandeep Kautish, Zdzislaw Polkowski, Anil Kumar, Chuan-Ming Liu
EPUB ebook
190,99 €