The Work of Work
Meeting are work, even though we sometimes don't think of them as a productive part of our job.
2022-10-19
190 reads
Uncategorized
Data Lineage Scripts for Microsoft SQL Server and Azure SQL
Learn how you can easily analyze the data lineage in your SQL Server database.
2022-10-19
9,914 reads
SQL Server Internals: Reading Pages
The I/O from an instance of the SQL Server Database Engine includes logical and physical reads. A logical read occurs every time the Database Engine requests a page from the buffer cache. If the page is not currently in the buffer cache, a physical read first copies the page from disk into the cache.
2022-10-17
2022-10-14
8,251 reads
Learning New Technology Is Challenging
On nights and weekends, I've been playing with Arduino controllers. I have a couple of projects I'm working through (building a robot that can roll around with "eyes" to avoid obstacles). I've also been trying to work with STM32 controllers, because in a lot of ways, they're more powerful than an Arduino. However, I've hit […]
2022-10-08
154 reads
Assembling Your Own Toolbox
Building a toolbox of useful scripts and code is important for any technology professional.
2022-10-07
269 reads
Who Are You?
I was sitting here thinking about the editorial when Kathi Kellenberger came to mind. She would frequently write about her favorite show, Star Trek. I too have been a fan of Star Trek since I was very young. However, my favorite show is a little more obscure and not as many people have seen it, […]
2022-09-17
224 reads
How to Use PowerShell to Set Secure SA Passwords in Bulk
Learn how you can bulk set passwords using PowerShell for all your instances.
2022-09-16 (first published: 2022-08-17)
2,818 reads
Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1
In Unix, a timestamp is a whole number that represents a date and time. Learn how we can convert those correctly in SQL Server.
2022-11-15 (first published: 2022-09-14)
53,605 reads
Things Move Fast
I have several things I’d like to say in the editorial today, but I feel I have to start off with my condolences to the family of Queen Elizabeth II. For that matter, my condolences to the people of Britain. This truly is the end of an era. Things do indeed move fast sometimes. Working […]
2022-09-10
163 reads
Blogs
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...
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,...
Forums
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
Ready to launch your next big game?
Looking for a creative and experienced mobile game development company that brings your game...
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