Pro T-SQL 2012 Programmer's Guide

This tutorial describes and demonstrates new T-SQL features with working examples, and can be used as a reference for quickly locating details about specific features. The book addresses the needs of

Provides information on the architecture and features of the T-SQL programming language.

Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling

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

Intended for C# programmers, this guide explains how to interact with the SQL Server 2005 database using C# 2008, write queries in T-SQL, call stored procedures from C#, work with XML, build Windows F

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