Master SQL Server’s Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and addr
Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or
Take a deep dive into one of the most significant SQL Server features–support for In-Memory Online Transaction Processing. The latest developments are covered, including support of off-row storage, co
Automate your database administration workload through a combination of PowerShell and T-SQL. Automate SQL Server build processes, monitor multiple instances from a single location, and automate routi
如果您是一位元資料庫管理員或開發者，那麼 SQLServer 2012寶典(第4版) 將是您全面瞭解SQL Server 2012的一站式資源。本書深入探討核心技術、最佳實踐和精妙方案，列舉豐富的實例和示例代碼，並完整介紹AlwaysOn連接、新索引、Power View、主資料服務、資料品質服務和PowerPivot for SQL Server 2012等新功能。● 深入探討SQL Serve
What you need to get the job done.The latest book from the best-selling SQL Server author Mike Hotek. SQL Server 2012 Data Design and Retrieval is your reference for building databases and querying d
Learn the latest SQL Server 2012 database design methods for career advancement; among them FileTable FILESTREAM storage and ColumnStore indexes. Relational database design teach-by-practical-diagrams
Relational database design and SQL (Structured Query Language) programming teach-by-practical-diagrams-&-examples book for developers, programmers, systems analysts and project managers who are ne
SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Needto export
Pro SQL Server 2012 Practicesis 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 Mi
Understand Microsoft's dramatically updated new release of its premier toolset for business intelligenceThe first major update to Microsoft's state-of-the-art, complex toolset for business intelligenc
SQL Server 2012 Integration Services Design Patterns?is a book of recipes for SQL Server Integration Services (SSIS). Design patterns?in the book show how to?solve common problems encountered when dev
Intended for database administrators and developers who are ready to boost the performance of their environments, this guide delves into indices, the single-most important facet of good performance, e
Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's bookSQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance proble
Beginning SQL Server 2012 Administration provides the essential skills and knowledge needed to begin a successful career as an SQL Server database administrator. It's an ideal book for those new to da
A must-have guide for the latest updates to the new release of Reporting ServicesSQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated
Pro SQL Server 2012 Administrationis a one-stop source for all the knowledge you'll need to professionally manage a database under Microsoft SQL Server 2012. SQL Server administration is a complex fie
Each book aims to teach an important technology or programming language and is designed to take a person from being a novice to a professional by including the most essential information and explainin
An essential how-to guide for experienced DBAs on the most significant product release since 2005!Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs a
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 comprehens
This is a practical tutorial for Analysis Services that shows readers how to solve problems commonly encountered while designing cubes, and explains which features of Analysis Services work well and w
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor per
Designed for senior web developers, this reference carefully considers the riches of the databound controls and database functionality features and cuts the best out of the herd. Master developer Steh
With tools for gaining as many as 30 times the execution speed, this handbook educates database administrators on how to rewrite SQL into PL/SQL and how to use advanced Oracle bulk array processing t
SQL Server 2014 follows just in 2 years after SQL Server 2012 with very exciting new features. One on the top: in-memory OLTP tables for superior performance. With abundant computer memory, why keep t
The Definitive Guide to Microsoft SQL Server 2012 Reporting ServicesCreate, deploy, and manage business intelligence reports using the expert tips and best practices in this hands-on resource. Written
An expert guide to working with SQL Server in a mixed-database environmentMicrosoft SQL Server Administration for Oracle DBAs is the ideal resource for experienced Oracle database professionals looki
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-ter
Field-tested techniques for optimizing SQL Server 2014 databases and applications for speed and performanceMicrosoft SQL Server 2014 Query Tuning & Optimization reveals how to get peak performance
Implement, maintain, and repair SQL Server 2012 databasesAs the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether y
MCSA GUIDE TO MICROSOFT SQL SERVER 2012 (Exam #70-462) provides a thorough introduction to essential database administration principles and practices to prepare readers for certification and career su
The bestselling MCSA study guide, with expert instruction and hands-on practiceMCSA Windows Server 2012 R2 Configuring Advanced Services Study Guide provides focused preparation for exam 70-412 and is
Improve the performance of relational databases with indexes designed for today's hardware Over the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprisi
