Backup Architecture
Continuous backup in Cosmos DB doesn't quite work as Steve would expect. He has a few comments on why it is important you know how your backup and restore system works.
2022-02-21
442 reads
Editorials
Disaster Recovery in Another Region
Years ago I worked at a large company, and we purchased a SAN appliance to consolidate our storage. This was at a time when the majority of our servers used locally attached storage. This was a big purchase, and we knew that we had to plan for issues. So, we actually purchased two appliances and […]
2022-02-19
60 reads
An Active Job Search
Steve wants you to manage your career and actively find the job that is best for you.
2022-02-18
178 reads
The NoSQL Rise and Fall
The NoSQL class of databases were very popular for awhile, but it seems many companies are sticking with an RDBMS in many cases.
2022-02-16
609 reads
The Battlefield of Your Career
If you want to actively manage your career and drive it forward, Steve has some advice.
2022-02-14
187 reads
Joining a Community
In the last week I've been actively trying to join the PostgreSQL community. It's been an interesting experience. I suspect it's going to stay interesting for a while. As part of what I'm doing, I saw this excellent video from Ryan Booz, talking about joining a new community. It got me to thinking. You have […]
2022-02-12
73 reads
Do You Still Use CHAR?
When designing a database, choosing good datatypes is important, but not necessarily all the time. Today Steve wonders if you still use fixed sting data types.
2022-02-11
230 reads
The Cloud as a Foundation
The innovations and possibilities of cloud computing are exciting to Steve.
2022-02-09
163 reads
Speedy Break Fix
Is DevOps and Agile better than waterfall? Steve has a few thoughts after a recent experience.
2022-02-07
233 reads
Please include your DDL
I haven’t done it much the past few years, but I would answer some programming questions posted in forums back in the day. In the late 90s, I answered Visual Basic questions and eventually switched to SQL Server questions here on SQL Server Central as my career progressed. Answering questions not only assisted someone else, […]
2022-02-05
115 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