Last Week Reading (2019-09-08)
Hello all and welcome after my one month of my absence. What was I doing? Thank you for asking! I have been on holiday. ONE month of very relaxing,...
2019-09-08
21 reads
Kamil
- Website: https://sqlplayer.net
ASF 024: Leila Etaati interview
Introduction Leila Etaati is an AI MVP, mentor, trainer, speaker and consultant. She spoke in some important conference such as Microsoft USA Ignite, Microsoft Data Insight Summit, SQL PASS,...
2019-07-26
20 reads
Last Week Reading (2019-07-21)
Another week passed. Look what did I find during that time. Press British Airways faces record £183m fine for data breach The penalty imposed on BA is the first...
2019-07-22
19 reads
ASF 024 video invitation
I’m happy to announce that the next episode of “Ask SQL Family” podcast is coming. This time our guest is an amazing woman, not only in AI and Power...
2019-07-19
8 reads
Last Week Reading (2019-07-07)
Hello, data eaters! Today, coming back from my friend by car, I was browsing a few posts on my cell (calmly – my wife was driving). At some point,...
2019-07-07
16 reads
Azure Databricks – create new workspace and cluster
In this post, I will quickly show you how to create a new Databricks in Azure portal, create our first cluster and how to start work with it. This...
2019-07-04
93 reads
Last Week Reading (2019-06-23)
Hello folks! Let’s take a look at a set of information from the field again. Press The best practices for performance comparison between Azure SQL Managed Instance and SQL...
2019-06-23
24 reads
ASF 023 video invitation
I’m happy to announce that the next episode of “Ask SQL Family” podcast is coming. This time our guest is Amit Bansal. We were talking to him during this...
2019-06-21
18 reads
Last Week Reading (2019-06-16)
Hello Data girls and guys! A lot of Microsoft’s announcements in many areas of the data platform. Here you have a big portion of news today. Press Unlock the...
2019-06-16
13 reads
SSDT (SqlPackage) thread crashes with error when publishing
In this post, I will show you one of the scenarios when SSDT (SQL Server Data Tools) can fail unexpectedly while publishing database project to target server or preparation...
2019-06-12
77 reads
Blogs
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Question of the Day
Fun with JSON I
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