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
5,777 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)
23,935 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,537 reads
Introduction In response to my approach in the pop...
2020-06-22
9,129 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,314 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,993 reads
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
2019-07-26 (first published: 2017-12-11)
5,321 reads
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
2019-07-19 (first published: 2017-07-26)
12,569 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,515 reads
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
2017-11-10 (first published: 2016-10-31)
3,381 reads
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
We value your privacy. This policy explains what personal data we collect and why. What...
Why would using variables in place of hard coded numbers impact a query's performance? ...
Hello SSC! I have been tasked with optimizing a stored procedure the imports data...
Hey everyone, I'm trying to access an XML file download from a government website...
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers