One Database, One Server
As background, I've never been a fan of multiple instances. It's a useful thing to have available and I use...
2009-06-09
393 reads
Blog Posts
PASS Connector Editorial for June 3, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-09
334 reads
Speaking At Space Coast SQL Users Group On June 11
Just a quick note to mention that I'm speaking at the next Space Coast SQL Users Group on Thursday, June...
2009-06-09
418 reads
SQL Saturday Eval Results
I received my evaluation summary from Karla Remail for this weekend's SQL Saturday event. The results are as follows:
Expectations: 0...
2009-06-09
582 reads
Starting Conversations - Part 6
As I've related previously (Part 1, Part 2, Part 3, Part 4, Part 5) I've been working author and speaker...
2009-06-09
334 reads
Transparent Data Encryption - Encrypting the Log
One of the interesting things about Transparent Data Encryption is that it tries to ensure that your data, whenever it...
2009-06-09
467 reads
Call for Speakers for SQLSaturday #16 in Miramar, FL on August 8, 2009
Scott Klein still needs a few more speakers for the first ever SQLSaturday in Miramar (basically Miami). So far Jeff...
2009-06-08
349 reads
Gathering in the Corner - SQLSaturday #14
I'm done with SQLSaturday #14, actually stuck in Pensacola for an extra night, but that's another story.
It was a great...
2009-06-08
593 reads
Handling Errors in PowerShell
Scripting tasks in PowerShell is a fairly easy way to automate tasks, but you have to know when you get...
2009-06-08
953 reads
It’s Beginning to Look A Lot Like Christmas……
We got something good in the mail last week!
Some quick observations:
The build quality is outstanding. Nothing cheap at all...
2009-06-08
579 reads
Blogs
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)...
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
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