Pro SQL Server 2012 Bi Solutions

Architect and deploy a Power BI solution. This book will help you understand the many available options and choose the best combination for hosting, developing, sharing, and deploying a Power BI solut

Learn the basics of Microsoft Azure and understand how SQL Server on Azure VMs (Infrastructure-as-a-Service) and Azure SQL Databases (Platform-as-a-Service) work. This book shows you how to deploy, op

SQL Azure represents Microsoft’s cloud-based delivery of its enterprise-caliber, SQL Server database management system (formerly under the code name "Oslo").Pro SQL Azure introduces

Every business has reams of business data locked away in databases, business systems, and spreadsheets. While you may be able to build some reports by pulling a few of these repositories together, act

In a series of books written by experts, each installment aims to help the IT professional hone his or her skill set in a particular programming language.

Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more

Provides information on the administration of SQL Server 2008, covering such topics as performing backups and recovery; monitoring server activity; managing security; and automating routine maintenanc

Pro SQL Server 2008 Replication is for Microsoft database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2008. This book w

Pro SQL Server 2008 Failover Clustering is dedicated to the planning, implementation, and administration of clustered SQL Server 2008 implementations. Whether deploying a single–instance, two–node clu

Provides information on successfully implementing an analytics solution using SQL Server 2008 and ways to create reports and dashboards.

This instructional guide to the SQL Server 2008 Integrated Full-Text Search (iFTS) is designed for developers and programmers who need to streamline database searches and improve access to each index.

Organizations are expected to spend $26 billion on business intelligence initiatives in 2008. Now that all the data is in relational databases, it’s time to start getting value at the organizational l

An updated guide to Microsoft's enterprise-level reporting tool discusses the new features of SQL Server 2008, with detailed coverage of such topics as building reports, using Report Designer, designi

Provides information on writing message-based applications using the Server Broker feature of SQL Server 2008.

From fundamentals to advanced topics, this book teaches readers not only how to use SQL Server Integration Services (SSIS), but also how to make integration projects stronger, faster, and smarter. The

* Deep, thorough coverage of all SRS 2005 technologies related to professional-level business reports* Supported and technically validated by the MS team* Especially (but not exclusively) applicable t

Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guid

Microsoft BizTalk Server 2006 R2 offers an efficient, integrated way to deploy EDI solutions. With this practical guide, you can set up and deliver a BizTalk 2006--driven EDI solution without getting

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

To understand the various BI offerings in SharePoint 2010, you need to understand the core SQL Server BI concepts, and we spend the first part of the book with a comprehensive tutorial on those funda

Intended for SQL Server developers and administrators, this desk reference provides Transact-SQL solutions for modifying data, creating tables and indexes, performing calculations, executing stored pr

Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up t

Written for both novice and professional web developers, this tutorial on the SQL Server 2008 covers installation, features, terminology and management of all database solutions. Dewson has written se

Learn the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI―Microsoft’s leading self-service business intelligence application―and covers other products such as PowerPivot and SQL Server Analysis Services Tabular. You will learn how to leverage the advanced applications of DAX to solve complex tasks.Often a task seems complex due to a lack of understanding, or a misunderstanding of core principles, and how certain components interact with each other. The authors of this book use solutions and examples to teach you how to solve complex problems. They explain the intricate workings of important concepts such as Filter Context and Context Transition. You will learn how Power BI, through combining DAX building blocks (such as measures, table filtering, and data lineage), can yield extraordinary analytical power. Throughout Pro Dax with Power BI t

Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work “under the hood,” and how they communicate with each other. The detailed knowle

* An essential book for new and migration projects for SQL Server 2005: will ensure that that such projects have a well-designed database and secure, optimized data access strategies right from the st

Loaded with code examples and practical solutions, this encyclopedic treatment includes all aspects of programming a database with SQL (Subsequent Server Language) 2005 and pulling the data into an ap