Apply techniques for building high-performing applications
Use clustering, database mirroring, and log shipping
With Early Release ebooks, you get books in their earliest form – the author’s raw and unedited content as he or she writes – so you can take advantage of these technologies long before the official release of these titles. You’ll also receive updates when significant changes are made, new chapters as they’re written, and the final ebook bundle.
Your hands-on, step-by-step guide to building applications with Microsoft SQL Server 2012 Step by Step
Teach yourself the programming fundamentals of SQL Server 2012 one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems. Download eBook Free »
Professional SQL Server 2012 Internals and Troubleshooting
This book is packed with expert advice and real-world examples, showing you how to troubleshoot SQL Server 2012 based on a thorough understanding of SQL Server and Windows internals. It shows how to master the use of specific troubleshooting tools, and how to interpret their output to quickly identify and resolve any performance issue?on any server running SQL Server.
Covers the core technical topics required to understand how SQL Server and Windows should be working
Shares best practices so that you know how to proactively monitor and avoid problems
Shows how to use tools to quickly gather, analyze, and effectively respond to the source of a system-wide performance issue
The 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critical book provides in-depth coverage of best practices for troubleshooting performance problems based on a solid understanding of both SQL Server and Windows internals and shows experienced DBAs how to ensure reliable performance. The team of authors shows you how to master the use of specific troubleshooting tools and how to interpret their output so you can quickly identify and resolve any performance issue on any server running SQL Server. Download eBook Free »
Knight’s Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video package from authority Brian Knight is the perfect solution. Each lesson includes three major components: a description of how each SSIS feature or process works, a tutorial that walks you through the process or technique, and an accompanying video lesson. It’s a complete learning package that will give you the confidence you need to start your first SSIS project.
Book-and-video package gets novices up to speed on Microsoft SQL Server 2012
This book-and-video package teaches you the essential elements of Microsoft SQL Server Integration Services (SSIS) from the ground up no previous knowledge of SSIS is required. Each lesson is streamlined to teach a specific component of SSIS, helping you to learn just what you need to succeed. The lessons include three major components: a description of how each SSIS feature or process works, a tutorial that walks you through the process or technique, and an accompanying video lesson, all of which present you with a thorough introduction to Microsoft business intelligence tools and SSIS. Download eBook Free »
Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX
The first major update to Microsoft’s state-of-the-art, complex toolset for business intelligence (BI) in years is now available and what better way to master it than with this detailed book from key members of the product’s development team? If you’re a database or data warehouse developer, this is the expert resource you need to build full-scale, multi-dimensional, database applications using Microsoft’s new SQL Server 2012 Analysis Services and related tools.
Understand Microsoft’s dramatically updated new release of its premier toolset for business intelligence
SQL Server 2012 is packed with powerful new Analysis Services features that will dramatically enhance business intelligence. Written by key members of Microsoft’s product team, this book shows you how to apply these new capabilities to create sophisticated BI solutions. In order to accomplish this, you’ll learn how to design, build, and work with the multidimensional and tabular Business Intelligence Semantic Model (BISM) using SQL Server Analysis Services. You’ll then use MDX and DAX to query those databases so you can provide advanced analysis of business problems and build end-to-end solutions to meet your needs. Download eBook Free »
Publisher: Microsoft Press; 1st edition (December 21, 2012)
Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012
Ace your preparation for Microsoft Certification Exam 70-463 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with online practice tests featuring multiple, customizable testing options.
Maximize your performance on the exam by learning how to:
Design and implement a data warehouse
Develop and enhance SQL Server Integration Services packages
Manage and maintain SQL Server Integration Services packages
Build data quality solutions
Implement custom code in SQL Server Integration Services packages
Ace your preparation for Microsoft Certification Exam 70-463 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with online practice tests featuring multiple, customizable testing options. Download eBook Free »
Pro SQL Server 2012 Practices is an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012.
With an emphasis upon performance but also branching into release management, auditing, and other issues the book helps you deliver the most value for your company’s investment in Microsoft’s flagship database system
Goes beyond the manual to cover good techniques and best practices
Delivers knowledge usually gained only by hard experience
Focuses upon performance, scalability, reliability
Helps achieve the predictability needed to be in control at all times
Pro SQL Server 2012 Practicesis an anthology of high-end wisdom from a group of accomplished database administrators and developers who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012. Download eBook Free »