Unlock new opportunities for data-driven decision-making by grasping the significance of SQL and structured data in current data and analytics ecosystems like Microsoft Fabric.
2025-03-21
6,093 reads
In this first article, get an introduction to DAX, it's uses, and the basics of a DAX query as compared to a T-SQL query.
2025-01-01 (first published: 2020-03-26)
24,294 reads
Why has Microsoft added new capabilities in SQL Server to connect to other types of data sources? Read on to learn more.
2021-05-14 (first published: 2019-09-09)
10,546 reads
Introduction In response to my approach in the pop...
2020-06-22
9,170 reads
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 […]
2020-04-30
42,596 reads
A look at SQL-On-Hadoop systems like PolyBase, Hive, Spark SQL in the context Distributed Computing Principles and new Big Data system design approach like the Lambda Architecture.
2019-09-06 (first published: 2017-10-26)
5,997 reads
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
2019-07-26 (first published: 2017-12-11)
5,331 reads
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
2019-07-19 (first published: 2017-07-26)
12,587 reads
This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
2018-07-17 (first published: 2012-06-05)
18,525 reads
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
2017-11-10 (first published: 2016-10-31)
3,388 reads
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Comments posted to this topic are about the item How Many Can Be the...
Comments posted to this topic are about the item How to process images and...
Comments posted to this topic are about the item Patching the Patch
I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:
select GREATEST( col1, col2, col3, ...)See possible answers