SQL Server Integrates Hadoop and Spark out-of-the box: The Why?
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)
9,966 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)
9,966 reads
Introduction In response to my approach in the pop...
2020-06-22
7,302 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
31,336 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.
2020-03-26
14,953 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,491 reads
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
2019-07-26 (first published: 2017-12-11)
4,776 reads
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
2019-07-19 (first published: 2017-07-26)
11,701 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,197 reads
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
2017-11-10 (first published: 2016-10-31)
3,141 reads
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
2017-07-27
1,401 reads
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
By Steve Jones
The grade for January is a D. Details below, but just not making a...
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...
I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...
Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...