标签:SQL Server

Microsoft SQL Server 2012 Performance Tuning Cookbook 封面

Microsoft SQL Server 2012 Performance Tuning Cookbook

作者:Bihag Thaker, Ritesh Shah

As a DBA you must have encountered a slow running application on SQL Server, but there are various factors that could be affecting the performance. If you find yourself in this situation, don't wait, pick up this book and start working towards improving performance of your SQL Server 2012. SQL Server 2012 Performance Tuning Cookbook is divided into three major parts — Performance Monitoring, Performance Tuning, and Performance Management–that are mandatory to deal with performance in

SQL Server 2012 Integration Services Design Patterns 封面

SQL Server 2012 Integration Services Design Patterns

作者:Andy Leonard, Jessica M. Moss, Matt Masson, Michelle Ufford, Tim Mitchell

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 developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resoluti

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook 封面

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

作者:Derek Wilson

Key Features Build and deploy Tabular Model projects from relational data sources Leverage DAX and create high-performing calculated fields and measures Create ad-hoc reports based on a Tabular Model solution Useful tips to monitor and optimize your tabular solutions Book Description SQL Server Analysis Service (SSAS) has been widely used across multiple businesses to build smart online analytical reporting solutions. It includes two different types of modeling for analysis services: Tabular and

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports 封面

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

作者:Christopher Finlan, Paul Turley, Riccardo Muti

Optimize reporting and BI with Microsoft SQL Server 2016 Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You'll learn effective report solution design based upon many years of experience with successful report solutions. Improve your own reports with advanced, best-practice design, usability, query design,

Expert SQL Server In-Memory OLTP, 2nd Edition 封面

Expert SQL Server In-Memory OLTP, 2nd Edition

作者:Dmitri Korotkevitch

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, columnstore indexes and operational analytics, changes in programmability and native compilation, and more. This book describes the architecture and internals of the In-Memory OLTP Engine and explains how to develop, deploy, and maintain systems using it. With it you can dramatically increase transac

SQL Server AlwaysOn Revealed, 2nd Edition 封面

SQL Server AlwaysOn Revealed, 2nd Edition

作者:Peter A. Carter

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This second edition is newly-updated to cover the 2016 editions of both SQL Server and Windows Server. Also in this edition is all-new content on troubleshooting and metadata. The book provides a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime, as well as how to troubleshoot those systems in order to keep them running an reliable. Begin w

Beginning SQL Server R Services 封面

Beginning SQL Server R Services

作者:Bradley Beard

Learn how to develop powerful data analytics applications quickly for SQL Server database administrators and developers. Organizations will be able to sift data and derive the business intelligence needed to drive business decisions and profit. The addition of R to SQL Server 2016 places a powerful analytical processor into an environment most developers are already comfortable with – Visual Studio. This book walks even the newest of users through the creation process of a powerful R-language

Pro SQL Server Always on Availability Groups 封面

Pro SQL Server Always on Availability Groups

作者:Uttam Parui, Vivek Sanil

This book is your field guide to planning, deploying, managing, and troubleshooting Always On Availability Groups. The Always On Availability Groups feature is an enterprise-level solution for high availability and disaster recovery. Always On provides a rich set of options that reduce overhead and resource usage and enable database administrators to implement and manage high availability and disaster recovery solutions far more easily than by implementing the log-shipping and database-mirroring

SQL Server 2014 with PowerShell v5 Cookbook 封面

SQL Server 2014 with PowerShell v5 Cookbook

作者:Donabel Santos

PowerShell can be leveraged when automating and streamlining SQL Server tasks. PowerShell comes with a rich set of cmdlets, and integrates tightly with the .NET framework. Its scripting capabilities are robust and flexible, allowing you to simplify automation and integration across different Microsoft applications and components. The book starts with an introduction to the new features in SQL Server 2014 and PowerShell v5 and the installation of SQL Server. You will learn about basic SQL Server

Securing SQL Server 封面

Securing SQL Server

作者:Peter A. Carter

Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business. Database professionals in today's world deal increasingly often with repeated data attacks against high-profile or

Beginning SQL Server Reporting Services 封面

Beginning SQL Server Reporting Services

作者:Kathi Kellenberger

Learn SQL Server Reporting Services and become current with the 2016 edition. Develop interactive, dynamic reports that combine graphs, charts, and tabular data into attractive dashboards and reports to delight business analysts and other users of corporate data. Deliver mobile reports to anywhere and any device. Build vital knowledge of Reporting Services at a time when Microsoft's dominance in business intelligence is on the rise. Beginning SQL Server Reporting Services turns novices into ski

Pro SQL Server on Microsoft Azure 封面

Pro SQL Server on Microsoft Azure

作者:Amit Banerjee, Pranab Mazumdar, Sourabh Agarwal

Learn the basics of Microsoft Azure and see how SQL Server on Azure VMs (Infrastructure-as-a-Service) and Azure SQL Databases (Platform-as-a-Service) work. This concise book shows you how to deploy, operate, and maintain your data using any one or a combination of these offerings along with your on-premise environment. Pro SQL Server on Microsoft Azure is a quintessential book for any IT professional who is planning to host their data on Microsoft Azure. This book will not only equip you with th

· · · · · · · · · · · · · · 第 1 页 · · · · · · · · · · · · · ·