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,615 reads
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
2017-07-27
1,615 reads
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)
12,462 reads
Learn about how to build value driven analytics with SQL Server and R.
2016-03-04 (first published: 2014-11-03)
16,033 reads
SQL Server Big Data.
Is the end Near for ETL as we know is?
Will RDBMs be obsolete?
What is NoSQL? What is Hadoop? Big Data-the whole story.
2015-05-29 (first published: 2013-11-21)
14,019 reads
Will RDBMs be obsolete? Should Data Professionals care about Big Data technologies? What is NoSQL? What is Hadoop? Big Data-the whole story.
2015-05-22 (first published: 2013-06-26)
27,293 reads
Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
2014-11-14 (first published: 2012-06-19)
9,068 reads
Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
2014-11-07 (first published: 2012-06-12)
10,181 reads
Learn all you need to know about MDX, by drawing only on your current SQL knowledge.
2014-06-13 (first published: 2012-11-01)
28,388 reads
Learn everything about MDX drawing only on your T-SQL knowledge in this series. Frank Banin continues talking about Calculated Members, Named Sets, and more in part III.
2013-02-14
9,006 reads
Learn everything about MDX by drawing only on your SQL knowledge.
2012-12-18
13,100 reads
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
I'm fairly certain I know the answer to this from digging into it yesterday,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
hi everyone I am not sure how to write the query that will produce...
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers