Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on Certification Exams Inside Out: How to Think Like a Certification Exam! This was a lot of...
2020-04-03
35 reads
Thanks for joining us for the The Business Case for SQL Server 2019 webinar via Spark/Ed today, an overview of new features in and around SQL Server 2019's release but...
2020-03-26
155 reads
@william_a_dba what did it take to become a MVP?— kennyb7322 (@kennyb7322) March 3, 2020
This tweet made me pause. I'll explain.Backstory (skip if you're not interested):On Sunday March 1,...
2020-03-17 (first published: 2020-03-09)
455 reads
Thanks for joining us at the first annual SQLSaturday Baton Rouge Business Intelligence yesterday, put on by the Baton Rouge Analytics and Intelligence Network (#GOBRAIN!), an official chapter of...
2020-03-08
22 reads
The first of a double whammy of SQLSaturday Baton Rouge events over the next 5 months, SQLSatBatonRougeBI is this Saturday, March 7! The organizers of this event, from the...
2020-03-02
7 reads
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at the Southeastern La. University ACM group. Big thanks to the bright student organizers for inviting...
2020-02-27 (first published: 2020-02-21)
137 reads
Hi Santa Fe! My first remote presentation for the Santa Fe SQL Server UG was on "What's New in SQL Server 2019?" Thanks to my friend Adrian Mee for...
2020-02-13
34 reads
Excited to launch another new presentation, the first co-presented with my wife, on Ethics in Modern Data. We'll explore the ethical considerations around historical bias, ethics in analysis and...
2020-02-15 (first published: 2020-02-08)
211 reads
Working on a SQL 2017 database where an external, non-Microsoft application has direct access to read/write data via the ODBC Driver 17 for SQL Server.
They suddenly began to experience...
2020-02-04 (first published: 2020-01-24)
399 reads
SQL Server 2019 Administration Inside Out
Honored again to be leading the talented SQL Server 2019 Administration Inside Out author team, and share some fun insights from the team as...
2020-01-22
187 reads
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
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...
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