161 articles from Azure CAT, patterns & practices, and SQL CAT

I’m happy to announce my work with Azure CAT (CAT stands for Customer Advisory Team), which is my team at Microsoft. We run customer engagements and feedback across product brands that include Azure, SQL Server, Power BI, BizTalk, Visual Studio, and more! In this article, I list out an initial 161 technical articles we’ve published,…

0

Technical Customer Profiles – Azure & SQL Server

This blog lists out the SQLCAT and AzureCAT technical customer profiles (TCPs). These are customer architectures from engagements led by our CAT and CSA teams. They are journeys into architectural design decisions that led these customers into highly successful solutions.   Service Fabric: BMW Digamore Entertainment (new; added on 3/3) Mesh Systems P2ware (new; added…

2

What is a DAX Expression?

Basic DAX Syntax A DAX formula is comprised of an equal sign followed by a function or expression. Functions perform operations such as concatenating or adding values, calculating sums or averages, or performing logical tests. Functions usually take some kind of argument, which might be a reference to a column or table. Functions can be…

4

Applied Microsoft SQL Server 2012 Analysis Services: Tabular Modeling

This book is a few years old, but it remains as a good resource people are using, so I wanted to call out some details about it. I helped out as the Technical Editor and Copy Editor. The author is Teo Lachev. This book is available on Amazon here. You can also view Teo’s book…

1

NEW WHITEPAPER: Using Power BI in a Hybrid Environment

Summary: Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores. This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365,…

3

NEW FREE eBook – Introducing Microsoft SQL Server 2014 (+ Power BI)

Introducing Microsoft SQL Server 2014 By Ross Mistry and Stacia Misner April 2014 125 pages   In this book, the authors explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transactional processing (OLTP) and data-warehouse solutions. They also describe how it eases the transition from on-premises solutions to the cloud with…

4

TechNet Guru Awards – From December to January

A few weeks back, XAML Guy posted the December TechNet Guru awards:   TechNet Guru Awards – December 2013   To give you a taste, here are the results of the technologies in my product areas (SQL Server, Power BI, and Small Basic)…      Small Basic Technical Guru – December 2013     Nonki Takahashi Small Basic…

1

Business Intelligence in SQL Server 2014 – Power View for Multidimensional Models

Power View for Multidimensional Models   The ability to create Power View reports against multidimensional models was first introduced in SQL Server 2012 Service Pack 1 Cumulative Update 4. Power View for Multidimensional Models functionality is now included as part of SQL Server 2014. Power View Report for a Multidimensional Model This functionality helps organizations…

5

Business Intelligence in SQL Server 2014 – SQL Server Data Tools (SSDT)

  Updates to Design Tool installation   SQL Server Data Tools for Business Intelligence (SSDT BI), previously known as Business Intelligence Development Studio (BIDS), is used to create Analysis Services models, Reporting Services reports, and Integration Services packages. In this pre-release version of SQL Server 2014, SQL Server Setup no longer installs SSDT BI. The…

25

Interview with a SQL Server Guru: Shanky 621

My interview is with Shanky_621.     Shanky has 19K Recognition points, over 1K forum answers, and he has 3 TechNet Guru medals (for SQL Server), including 1 gold medal!    SQL Server is also my product I work on, so I love to see community members championing SQL Server!   Let’s get the interview started!…

5