Minimizing Cloud cost
The cloud can be expensive. I had this hammered home the other day by a simple mistake. I’m currently working...
2016-06-27 (first published: 2016-06-20)
1,474 reads
SQLStudies
Help! My backup file has doubled in size.
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400!...
2016-06-16
585 reads
Comparing two query plans
This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server....
2016-06-20 (first published: 2016-06-14)
3,356 reads
Comparing the contents of two tables Redux
I did a post the other day on comparing two tables. It was meant as a general overview but I...
2016-06-08
473 reads
I need help with DBCC
Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I...
2016-06-06
1,414 reads
Using LEN wrong.
I was reading someone’s question the other day on StackExchange and while the existing comments/questions solved the OP’s (original poster)...
2016-06-10 (first published: 2016-06-02)
4,631 reads
I hate saying no
I really do. There is a joke that DBAs say no to everything and there is some truth to that....
2016-05-31
745 reads
Connecting to Azure SQL Database
Recently I created my first Azure SQL Database. But now I need to connect to it.
You can connect using...
2016-05-25
542 reads
Master_Views: master_objects, master_tables, etc
There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of...
2016-06-01 (first published: 2016-05-23)
1,578 reads
Re-Evaluating Best Practices
I was reading a blog post from my friend Randolph West (b/t) on Best Practices and a thought struck me.
Starting...
2016-05-18
465 reads
Blogs
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...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Foreign Keys - Foes or Friend?
Comments posted to this topic are about the item Foreign Keys - Foes or...
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