Microsoft SQL Server 2012 Bible (häftad)
Fler böcker inom
Häftad (Paperback)
Antal sidor
Nelson, Aaron (förf)
234 x 203 x 57 mm
2131 g
Antal komponenter
Microsoft SQL Server 2012 Bible (häftad)

Microsoft SQL Server 2012 Bible

(1 röst)
Häftad Engelska, 2012-08-29
Skickas inom 7-10 vardagar.
Fri frakt inom Sverige för privatpersoner.
Finns även som
Visa alla 2 format & utgåvor
Harness the powerful new SQL Server 2012 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, Microsoft SQL Server 2012 Bible 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. 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.
  • Serves as an authoritative guide to Microsoft's SQL Server 2012 for database administrators and developers
  • 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
  • Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services
  • Demonstrates tasks both graphically and in SQL code to enhance your learning
  • Provides source code from the companion web site, which you can use as a basis for your own projects
  • Explores tips, smart workarounds, and best practices to help you on the job
Get thoroughly up to speed on SQL Server 2012 with Microsoft SQL Server 2012 Bible.
Visa hela texten

Passar bra ihop

  1. Microsoft SQL Server 2012 Bible
  2. +
  3. Professional Microsoft SQL Server 2014 Administration

De som köpt den här boken har ofta också köpt Professional Microsoft SQL Server 2014 Administ... av Adam Jorgensen, Bradley Ball, Steven Wort, Ross Loforte, Brian Knight (häftad).

Köp båda 2 för 788 kr


Har du läst boken? Sätt ditt betyg »

Bloggat om Microsoft SQL Server 2012 Bible

Övrig information

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.


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: R...