Frank A. Banin


DAX for SQL Folks: Part II - Translating SQL Queries to DAX Queries

Introduction In response to my approach in the popular MDX Guide for SQL Folks series, I am using SQL as a good frame of reference for starting or developing a new approach for improving your Data Analysis Expression(DAX) language learning experience. This is useful for developers starting to learn the DAX language to more advanced developers who […]

5 (9)

2020-04-30

17,829 reads

SQL Server Integrates Hadoop and Spark out-of-the box: The Why?

Introduction Microsoft announced in September 2018 that SQL Server 2019, which is now in preview, will have a Big Data Cluster deployment option. This is a Big-Data-capable SQL Server with elastic scale and extended Artificial Intelligence (AI) capabilities, mostly as a result of deep integration of Hadoop and Spark out-of-the-box.  The new SQL Server Big […]

4.67 (6)

2019-09-09

5,865 reads

Blogs

Using Write-Debug

By

I wrote a post about PoSh output recently, noting that in general we ought...

T-SQL Tuesday Retrospective #002: A Puzzling Situation

By

For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we...

Daily Coping 28 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Stored Proc with OPENJSON: How to determine insert or update?

By Goalie35

This is my 1st attempt at openjson & I'm trying to setup a stored...

product version result

By mtz676

SELECT SERVERPROPERTY ('ProductVersion') Output: 13.0.4001.0 What does each of those numbers mean.I need to...

Login to SQL Server cross domain AD Group user

By Papote

Our MS SQL Server is on another trusted domain (Trusted Domain T). We created...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers