Microsoft SQL Server 2012 Bible

Adam Jorgensen 지음

Wiley 2012년 08월 06일 출간

작품소개

책소개

Harness the powerful new SQL Server 2012Microsoft 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 developersCovers 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 applicationsExplains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis ServicesDemonstrates tasks both graphically and in SQL code to enhance your learningProvides source code from the companion web site, which you can use as a basis for your own projectsExplores tips, smart workarounds, and best practices to help you on the jobGet thoroughly up to speed on SQL Server 2012 with Microsoft SQL Server 2012 Bible.

목차

Introduction&&& xxixPart I: Laying the Foundations 1Chapter 1: The World of SQL Server&&& 3Chapter 2: Data Architecture&&&& 15Chapter 3: Installing SQL Server&&&& 31Chapter 4: Client Connectivity&&&&&& 71Chapter 5: SQL Server Management and Development Tools&&&& 81Part II: Building Databases and Working with Data 109Chapter 6: Introducing Basic Query Flow&&& 111Chapter 7: Relational Database Design and Creating the Physical Database Schema&&&&& 143Chapter 8: Data Types, Expressions, and Scalar Functions&&&&& 173Chapter 9: Merging Data with Joins, Subqueries, and CTEs&&&& 213Chapter 10: Aggregating, Windowing, and Ranking Data&&& 249Chapter 11: Projecting Data Through Views&&&& 271Chapter 12: Modifying Data In SQL Server&&&&& 291Part III: Advanced T-SQL Data Types and Querying Techniques 323Chapter 13: Working with Hierarchies&&&&& 325Chapter 14: Using XML Data&&&&&& 339Chapter 15: Executing Distributed Queries&&&&& 367Part IV: Programming with T-SQL 387Chapter 16: Programming with T-SQL&&&&&& 389Chapter 17: Developing Stored Procedures&&&& 431Chapter 18: Building User-Defi ned Functions&&& 453Part V: Enterprise Data Management 467Chapter 19: Confi guring SQL Server&&&& 469Chapter 20: Policy Based Management&&&& 531Chapter 21: Backup and Recovery Planning&&&& 547Chapter 22: Maintaini

작가정보

저자(글) Adam Jorgensen

저자 :

저자 :

저자 :

저자 :

저자 :
저자 :
저자 :
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#45;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#45;known experts on SQL Server and Business Intelligence.