DAX for SQL Folks: Part III - DAX Calculations
Introduction In response to my approach in the pop...
2020-06-22
5,168 reads
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 […]
2020-04-30
20,335 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
9,964 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 […]
2019-09-09
6,597 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)
4,719 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,508 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)
10,506 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)
2,911 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,286 reads
Hadoop For SQL Folks: Architecture, MapReduce and Powering IoT
As the de-facto big data processing and analytics engine, the Hadoop ecosystem is also leading the way in powering Internet of Things (IOT)
2016-12-02 (first published: 2015-08-06)
11,719 reads
Blogs
Everyone Run a SQL Saturday in 2021
By Steve Jones
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....
Modern Data Warehouse & Reverse ETL
By James-Serra
An extension to the Modern Data Warehouse (MDW) that I have heard a bit...
Daily Coping 12 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
performance tuning
Hi everyone, Any good suggestion to tune below query: --CREATE NONCLUSTERED INDEX nonclust_code...
Understanding the Internals of a Data Page
Comments posted to this topic are about the item Understanding the Internals of a...
Preventing Trigger Execution
Comments posted to this topic are about the item Preventing Trigger Execution
Ask SSC