Real-World SQL-DMO for SQL Server, Allan Mitchell; Mark Allison
Автор: Jorgensen Название: Microsoft SQL Server 2012 Bible ISBN: 1118106873 ISBN-13(EAN): 9781118106877 Издательство: Wiley Рейтинг: Цена: 7524.00 р. Наличие на складе: Поставка под заказ.
Описание: Harness the powerful new SQL Server 2011 Microsoft SQL Server 2011 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, Microsoft SQL Server 2011 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2011, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak. The book is crammed with specific examples, sample code, and a host of tips, workarounds, and best practices. In addition, downloadable code is available from the book's Companion website, which you can use to jumpstart your own projects. Serves as an authoritative guide to Microsoft's SQL Server 2011 for database administrators and developers Covers all the software's new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services Demonstrates tasks both graphically and in SQL code to enhance your learning Provides source code from the Companion website, which you can use as a basis for your own projects Explores tips, smart workarounds, and best practices to help you on the job Get thoroughly up to speed on SQL Server 2011 with Microsoft SQL Server 2011 Bible.
Описание: Professional SQL Server 2011 Analysis Services with MDX and DAX shows readers how to build sophisticated business intelligence solutions using SQL Server Analysis Services, along with SQL Server Integration and Reporting Services. The authors begin with an overview showing how Analysis Services can be used to build data warehouses and multi-dimensional databases. They then quickly move to a tutorial that describes the development process for building dimensions and cubes from various data sources. The authors show how MDX and the more simplified version of MDX, DAX, can be used to query databases to provide sophisticated analysis of business problems. They will demonstrate a variety of techniques against real-world case scenarios. They will also show how Analysis Services can be used with other components of SQL Server, including Integration Services, Reporting Services, and Data Mining to provide comprehensive, end-to-end solutions. The 2011 book will be more than 50% new and revised to cover new features and enhancements, including: Improved integration with Excel and SharePoint 2010 The new DAX language, which is a more simplified, user-friendly version of MDX. PowerPivot, a new tool for performing simplified analysis of data. Integration of Analysis Services with PowerPivot, plus enhancements to PowerPivot, including Key Performance Indicators. The new Business Intelligence Semantic Model (BISM). Significant enhancements to Business Intelligence Development Studio (BIDS) and SQL Server Management Studio (SSMS) A new BI tool, code-named Crescent, that will revolutionize how data is reported. Integration with the Vertipaq engine for improved performance.
Автор: Dave Shea Название: Real World SQL Server Administration with Perl ISBN: 159059097X ISBN-13(EAN): 9781590590973 Издательство: Springer Рейтинг: Цена: 7126.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: For for both Windows programmers and open source aficionados, practical, real-world tested scripts are taken from actual production environments. The book provides over 150 ready-to-use and easy-to-customize Perl scripts for administrating SQL Servers.
Описание: This 2-in-1 Training Kit delivers preparation plus practice for Microsoft Exam 70-462. Ace your exam prep - and enhance your job skills - with hands-on lessons, practice tests, and other resources.
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? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.
What DBA or developer isn't faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft's flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you're looking for a resource to cover data integration and ETL across the gamut of Microsoft's SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs.
Provides practical and proven solutions towards creating resilient ETL environments
Clearly answers the tough questions which professionals ask
Goes beyond the tools to a thorough discussion of the underlying techniques
Covers the gamut of data integration, beyond just SSIS
Includes example databases and files to allow readers to test the recipes
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
