Pester 4.2.0 has a Because…… because :-)
I was going through my demo for the South Coast User Group meeting tonight and decided to add some details...
2018-01-18
376 reads
SQL DBA With A Beard
Using the AST in Pester for dbachecks
TagLine – My goal – Chrissy will appreciate Unit Tests one day
Chrissy has written about dbachecks the new up and coming...
2018-01-15
338 reads
Converting a Datarow to a JSON object with PowerShell
This is just a quick post. As is frequent with these they are as much for me to refer to...
2018-01-05 (first published: 2017-12-18)
1,671 reads
Handling Missing Instances when Looping with Pester
In my previous posts about writing your first Pester Test and looping through instances I described how you can start...
2017-11-30
683 reads
2 Ways to Loop through collections in Pester
In my last post I showed you how to write your first Pester test to validate something. Here’s a recap
Decide...
2017-11-28
396 reads
Write Your first Pester Test Today
I was in Glasgow this Friday enjoying the fantastic hospitality of the Glasgow SQL User Group@SQLGlasgow and presenting sessions with Andre...
2017-11-16
443 reads
TSQL2sDay – Folks Who Have Made a Difference
This months TSQL2sDay is an absolute brilliant one hosted by Ewald Cress
the opportunity to give a shout-out to people (well-known...
2017-11-14
269 reads
Comparing Agent Jobs across Availability Group Replicas with PowerShell
On the plane home from PAS Summit I was sat next to someone who had also attended and when he...
2017-11-27 (first published: 2017-11-10)
1,532 reads
Using Plaster To Create a New PowerShell Module
Chrissy, CK and I presented a pre-con at PASS Summit in Seattle last week
Tracey Boggiano T | B came along to our...
2017-11-22 (first published: 2017-11-09)
1,475 reads
dbatools with SQL on Docker and running SQL queries
I had a question from my good friend Andrew Pruski dbafromthecold on twitter or SQL Container Man as I call...
2017-11-07
600 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
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...
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