-22%
38,99 €
Statt 49,99 €**
38,99 €
inkl. MwSt.
**Preis der gedruckten Ausgabe (Broschiertes Buch)
Sofort per Download lieferbar
0 °P sammeln
-22%
38,99 €
Statt 49,99 €**
38,99 €
inkl. MwSt.
**Preis der gedruckten Ausgabe (Broschiertes Buch)
Sofort per Download lieferbar

Alle Infos zum eBook verschenken
0 °P sammeln
Als Download kaufen
Statt 49,99 €**
-22%
38,99 €
inkl. MwSt.
**Preis der gedruckten Ausgabe (Broschiertes Buch)
Sofort per Download lieferbar
0 °P sammeln
Jetzt verschenken
Statt 49,99 €**
-22%
38,99 €
inkl. MwSt.
**Preis der gedruckten Ausgabe (Broschiertes Buch)
Sofort per Download lieferbar

Alle Infos zum eBook verschenken
0 °P sammeln
  • Format: PDF


Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update to thisproduct since 2005, and it may change how database administratorsand developers perform many aspects of their jobs. If you're adatabase administrator or developer, Microsoft SQL Server 2012Bible teaches you everything you need to take full advantage ofthis major release. This detailed guide not only covers all the newfeatures of SQL Server 2012, it also shows you step by step how todevelop top-notch SQL Server databases and new data connections andkeep your databases performing at peak. The…mehr

Produktbeschreibung
Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update to thisproduct since 2005, and it may change how database administratorsand developers perform many aspects of their jobs. If you're adatabase administrator or developer, Microsoft SQL Server 2012Bible teaches you everything you need to take full advantage ofthis major release. This detailed guide not only covers all the newfeatures of SQL Server 2012, it also shows you step by step how todevelop top-notch SQL Server databases and new data connections andkeep your databases performing at peak. The book is crammed with specific examples, sample code, and ahost 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. * Serves as an authoritative guide to Microsoft's SQL Server 2012for database administrators and developers * Covers all the software's new features and capabilities,including SQL Azure for cloud computing, enhancements to clientconnectivity, and new functionality that ensures high-availabilityof mission-critical applications * Explains major new changes to the SQL Server BusinessIntelligence tools, such as Integration, Reporting, and AnalysisServices * Demonstrates tasks both graphically and in SQL code to enhanceyour learning * Provides source code from the companion web site, which you canuse as a basis for your own projects * Explores tips, smart workarounds, and best practices to helpyou on the job Get thoroughly up to speed on SQL Server 2012 with MicrosoftSQL Server 2012 Bible.

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, D ausgeliefert werden.

  • Produktdetails
  • Verlag: John Wiley & Sons
  • Seitenzahl: 1416
  • Erscheinungstermin: 9. August 2012
  • Englisch
  • ISBN-13: 9781118286821
  • Artikelnr.: 37348995
Autorenporträt
Adam Jorgensen is the President of Pragmatic WorksConsulting, a Director for the Professional Association of SQLServer (PASS), a SQL Server MVP, and a well-known speaker, author,and executive mentor. His focus is on helping companies realizetheir full potential using their data in ways they have notpreviously imagined. Adam is very involved in the community,delivering more than 75 community sessions per year. Based inJacksonville, FL, Adam has written and contributed to five previousbooks on SQL Server, analytics, and SharePoint. Coauthors JorgeSegarra, Patrick LeBlanc, Jose Chinchilla, and Aaron Nelson arewell-known experts on SQL Server and Business Intelligence.
Inhaltsangabe
Introduction xxix Part I: Laying the Foundations 1 Chapter 1: The World of SQL Server 3 Chapter 2: Data Architecture 15 Chapter 3: Installing SQL Server 31 Chapter 4: Client Connectivity 71 Chapter 5: SQL Server Management and Development Tools 81 Part II: Building Databases and Working with Data 109 Chapter 6: Introducing Basic Query Flow 111 Chapter 7: Relational Database Design and Creating the Physical Database Schema 143 Chapter 8: Data Types
Expressions
and Scalar Functions 173 Chapter 9: Merging Data with Joins
Subqueries
and CTEs 213 Chapter 10: Aggregating
Windowing
and Ranking Data 249 Chapter 11: Projecting Data Through Views 271 Chapter 12: Modifying Data In SQL Server 291 Part III: Advanced T-SQL Data Types and Querying Techniques 323 Chapter 13: Working with Hierarchies 325 Chapter 14: Using XML Data 339 Chapter 15: Executing Distributed Queries 367 Part IV: Programming with T-SQL 387 Chapter 16: Programming with T-SQL 389 Chapter 17: Developing Stored Procedures 431 Chapter 18: Building User-Defi ned Functions 453 Part V: Enterprise Data Management 467 Chapter 19: Confi guring SQL Server 469 Chapter 20: Policy Based Management 531 Chapter 21: Backup and Recovery Planning 547 Chapter 22: Maintaining the Database 585 Chapter 23: Transferring Databases 615 Chapter 24: Database Snapshots 635 Chapter 25: Asynchronous Messaging with Service Broker 647 Chapter 26: Log Shipping 661 Chapter 27: Database Mirroring 685 Chapter 28: Replicating Data 727 Chapter 29: Clustering 745 Chapter 30: Confi guring and Managing SQL Server with PowerShell 769 Chapter 31: Managing Data in Windows Azure SQL Database 801 Part VI: Securing Your SQL Server 831 Chapter 32: Authentication Types in SQL Server 833 Chapter 33: Authorizing Securables 841 Chapter 34: Data Encryption 853 Chapter 35: Row-Level Security 861 Part VII: Monitoring and Auditing 877 Chapter 36: Creating Triggers 879 Chapter 37: Performance Monitor and PAL 909 Chapter 38: Using Profi ler and SQL Trace 919 Chapter 39: Wait States 931 Chapter 40: Extended Events 937 Chapter 41: Data Change Tracking and Capture 945 Chapter 42: SQL Audit 967 Chapter 43: Management Data Warehouse 977 Part VIII: Performance Tuning and Optimization 993 Chapter 44: Interpreting Query Execution Plans 995 Chapter 45: Indexing Strategies 1005 Chapter 46: Maximizing Query Plan Reuse 1041 Chapter 47: Managing Transactions
Locking
and Blocking 1047 Chapter 48: Data Compression 1097 Chapter 49: Partitioning 1109 Chapter 50: Resource Governor 1131 Part IX: Business Intelligence 1141 Chapter 51: Business Intelligence Database Design 1143 Chapter 52: Building
Deploying
and Managing ETL Workfl ows in Integration Services 1155 Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX 1195 Chapter 54: Confi guring and Administering Analysis Services 1223 Chapter 55: Authoring Reports in Reporting Services 1233 Chapter 56: Configuring and Administering Reporting Services 1261 Chapter 57: Data Mining with Analysis Services 1281 Chapter 58: Creating and Deploying BI Semantic Models 1299 Chapter 59: Creating and Deploying Power View Reports 1327 Index 1347