Get up to speed on the extensive changes to the newest release of Microsoft SQL Server The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012. You'll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications. Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements Addresses essential topics including managing keys, writing scripts, and working with store procedures Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services Beginning Microsoft SQL Server 2012 Programming demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.

Get up to speed on the extensive changes to the newest release of Microsoft SQL ServerThe 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012.You'll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications.* Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements* Addresses essential topics including managing keys, writing scripts, and working with store procedures* Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration ServicesBeginning Microsoft SQL Server 2012 Programming demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.

INTRODUCTION xxvCHAPTER 1: RDBMS BASICS: WHAT MAKES UP A SQL SERVER DATABASE? 1CHAPTER 2: LEARNING THE TOOLS OF THE TRADE 23CHAPTER 3: THE FOUNDATION STATEMENTS OF T-SQL 49CHAPTER 4: JOINS 91CHAPTER 5: CREATING AND ALTERING TABLES 129CHAPTER 6: KEYS AND CONSTRAINTS 175CHAPTER 7: ADDING MORE TO YOUR QUERIES 213CHAPTER 8: BEING NORMAL: NORMALIZATION AND OTHER BASIC DESIGN ISSUES 257CHAPTER 9: SQL SERVER STORAGE AND INDEX STRUCTURES 305CHAPTER 10: VIEWS 353CHAPTER 11: WRITING SCRIPTS AND BATCHES 383CHAPTER 12: STORED PROCEDURES 435CHAPTER 13: USER-DEFINED FUNCTIONS 489CHAPTER 14: TRANSACTIONS AND LOCKS 509CHAPTER 15: TRIGGERS 537CHAPTER 16: A BRIEF XML PRIMER 561CHAPTER 17: BUSINESS INTELLIGENCE FUNDAMENTALS 615CHAPTER 18: BI STORAGE AND REPORTING RESOURCES 649CHAPTER 19: REPORTING FOR DUTY, SIR! A LOOK AT REPORTING SERVICES 681CHAPTER 20: GETTING INTEGRATED WITH INTEGRATION SERVICES 719CHAPTER 21: PLAYING ADMINISTRATOR 747APPENDIX: ANSWERS TO EXERCISES 783INDEX 807ONLINE APPENDICESBONUS APPENDIX 1: SYSTEM FUNCTIONS 1BONUS APPENDIX 2: VERY SIMPLE CONNECTIVITY EXAMPLES 6