Toolbox - Just the Basics
There are many query sets out there to collect varying groups of configuration data - the ones I most frequently use...
2018-03-29
700 reads
Nebraska SQL from @DBA_ANDY
Which Blogs Do I Recommend?
One of the most important parts of continuing learning as a DBA (or probably an IT Professional) is reading blogs. ...
2018-03-07
374 reads
Error 33206 - SQL Server Audit Failed to Create the Audit File
One of the joys of working with SQL Server is the descriptive and meaningful error messages, right?
https://vignette.wikia.nocookie.net/batmantheanimatedseries/images/a/a7/DiD_39_-_Joker_Vision.jpg/revision/latest?cb=20160610021326
Exhibit A - the 33206:
Error:...
2018-03-13 (first published: 2018-03-05)
16,691 reads
Toolbox - Which Clerk Is Busy?
A few years ago I wrote what would turn out to be my most-hit blog post (so far) titled "Error...
2018-02-07
395 reads
Toolbox - Why is My Database So Big????
I have written previously (here)about how to tell which database files have free space in them when your drive starts...
2018-01-19
3,739 reads
T-SQL Tuesday #98 – Take Small Bites!
https://media.makeameme.org/created/mega-bytes-well.jpgIt's T-SQL Tuesday time again - the monthly blog party was started by Adam Machanic (blog/@AdamMachanic) and each month someone different...
2018-01-09
547 reads
Come to SQL Saturday Providence!
Tomorrow 12/09/2017 is SQL Saturday #694 in Providence, RI.
I will be presenting by SQL Server Health Check session first thing...
2017-12-08
360 reads
PASS Summit 2017 - Live and in Living Color!
UPDATE - the feed and schedule are live at http://www.pass.org/summit/2017/PASStv.aspx
http://rochistory.com/blog/wp-content/uploads/2014/09/NBC-logo.pngNot in Seattle for some reason this week? Like maybe you stayed home...
2017-11-01
439 reads
But I Don't *Want* To "Restore from a backup of the database or repair the database!"
Do you like Log Shipping?
Before my time at Ntirety I had done quite a bit of work with failover clustering...
2017-11-02 (first published: 2017-10-23)
3,232 reads
And YOU Get a Deadlock and YOU Get a Deadlock and EVERYBODY GETS A DEADLOCK!
https://memegenerator.net/img/instances/400x/59507872/you-get-a-deadlock-everybody-gets-a-deadlock.jpgWe all get them at one point or another - deadlocks.
I have Object 1 and need Object 2, you have Object...
2017-10-26 (first published: 2017-10-18)
3,573 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