标签:SQL

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,

Exam Ref 70-762 Developing SQL Databases 封面

Exam Ref 70-762 Developing SQL Databases

作者:Louis Davidson, Stacia Varga

Prepare for Microsoft Exam 70-762, Developing SQL Databases –and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Design and implement

Building a Data Warehouse 封面

Building a Data Warehouse

作者:Vincent Rainardi

Here is the ideal field guide for data warehousing implementation. This book first teaches you how to build a data warehouse, including defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Coverage then explains how to populate the data warehouse and explores how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, custo

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

Learning SQLite for iOS 封面

Learning SQLite for iOS

作者:BSc (Hons), Gene Da Rocha, MSc

The ability to use SQLite with iOS provides a great opportunity to build amazing apps. Apple's iOS SDK provides native support for SQLite databases. This combination offers the potential to create powerful, data-persistent applications. This book starts with the architecture of SQLite database and introduces you to concepts in SQL . You will find yourself equipped to design your own database system, administer it, and maintain it. Further, you will learn how to operate your SQLite databases smoo

SQL on Big Data 封面

SQL on Big Data

作者:SUMIT PAL

Learn various commercial and open source products that perform SQL on Big Data platforms. You will understand the architectures of the various SQL engines being used and how the tools work internally in terms of execution, data movement, latency, scalability, performance, and system requirements. This book consolidates in one place solutions to the challenges associated with the requirements of speed, scalability, and the variety of operations needed for data integration and SQL operations. Afte

Beginning SQL Queries, Second Edition 封面

Beginning SQL Queries, Second Edition

作者:Clare Churcher

Anyone who does any work at all with databases needs to know something of SQL. This is a friendly and easy-to-read guide to writing queries with the all-important – in the database world – SQL language. The author writes with exceptional clarity.

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

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