#PowershellBasics: Multiple run spaces in ISE
As you know from the last few posts, I’m in a class on Powershell. One of the first things we ... Continue reading
2019-10-23 (first published: 2019-10-16)
420 reads
Kenneth Fisher
Want to be more comfortable with the Extended Events Viewer?
I’ll admit, I’m a lot more comfortable with tracing and the profiler than I am with EE (extended events) and ... Continue reading
2019-10-23
459 reads
#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.
I don’t know about you, but I like having the tools that I’m likely to use on my taskbar. That ... Continue reading
2019-10-14
86 reads
SQL Homework – October 2019 – Code review (self and peer)
Every database person I’ve ever met writes at least some code at some point in their career. That code might ... Continue reading
2019-10-14 (first published: 2019-10-02)
532 reads
Using 3rd party tools. T-SQL Tuesday #119
It’s that time again! Alex Yates (b/t) has asked us to discuss a time in tech when we’ve changed our ... Continue reading
2019-10-11 (first published: 2019-10-08)
457 reads
#PowershellBasics: Powershell vs Powershell Core
I’m taking a Powershell class this week and I have to say the teacher is one of the best I’ve ... Continue reading
2019-10-10
360 reads
Debugging techniques (focusing on T-SQL)
tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: ... Continue reading
2019-10-07 (first published: 2019-09-23)
839 reads
DBA Myths: CHECKDB runs on startup.
If you look at your error log you’ll (hopefully) see entries like this shortly after the instance startup: CHECKDB for ... Continue reading
2019-09-30 (first published: 2019-09-16)
581 reads
2019-09-30
31 reads
Blogging and coding best practices
I had a discussion a while back, I think it was with Grant Fritchey (b/t) but I just can’t remember. ... Continue reading
2019-09-25
24 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