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)
10,161 reads
Frank A. Banin
DAX for SQL Folks: Part III - DAX Calculations
Introduction In response to my approach in the pop...
2020-06-22
8,228 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
36,211 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
17,260 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,729 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,904 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)
12,052 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,325 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,227 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,472 reads
Blogs
FDD 2023 – Session Materials
You can find the slides for my session at Future Data Driven summit at...
Quick Filtering in SSMS–#SQLNewBlogger
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Penetration Testing your SQL Server, Part 1 – The Recon Mission
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
Forums
www.orderdmtonline.com | WickrID : yanngote | DMT 5MEO For Sale, BUY DMT 5MEO
Website: www.orderdmtonline.com +1(510)736-2652 Wickr ID: yanngote WireID: orderdmtonline Buy dmt online, buy 5meo dmt...
Write https request to azure blobstorage
Hi All, I have been trying to download a csv file which is produced...
High tempdb usage alternatives
Hi We have an stored procedure which runs frequently and it contain logic in...
Ask SSC