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,817 reads
Frank A. Banin
DAX for SQL Folks: Part III - DAX Calculations
Introduction In response to my approach in the pop...
2020-06-22
6,483 reads
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 […]
2020-04-30
28,887 reads
DAX For SQL Folks: Part I- Intro to DAX, Power BI and Data Viz
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,207 reads
Distributed Computing Principles and SQL-on-Hadoop Systems
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,449 reads
SQL-On-Hadoop: Hive - Part II
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
2019-07-26 (first published: 2017-12-11)
4,733 reads
SQL-On-Hadoop: Hive - Part I
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
2019-07-19 (first published: 2017-07-26)
11,475 reads
ETL Performance Auditing - Part 1: Introduction to ETL Auditing
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,082 reads
Advanced Analytics with R & SQL: Part I - R Distributions
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
2017-11-10 (first published: 2016-10-31)
3,087 reads
Advanced Analytics with R and SQL Part II - Data Science Scenarios
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
2017-07-27
1,365 reads
Blogs
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant...
Community Tools Month 2022 - dbatools
By alevyinroc
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...
Storytelling with Data – Enertia User Conference 2022
By DataOnWheels
Thank you to everyone who attended my session at the Enertia User Conference in...
Forums
How to calculate orders historically, during month
Good Morning There, CREATE TABLE Customers ( CID int NOT NULL PRIMARY KEY, GroupName...
How Important is Software?
Comments posted to this topic are about the item How Important is Software?
How and where did you learn SQL from?
Could you give me advice on where I should learn SQL and Python to...
Ask SSC