This Friday Steve Jones has a disaster recovery poll. When you have a true disaster, often there are multiple things that go wrong and cause a cascading failure. Is this common, let us know what your experience is this Friday.
2011-06-17
105 reads
Today we have a guest editorial from Andy Warren. Are there particular phrases that you use in technology that resonate with you and have particular meanings? Andy shares a few of his favorites.
2011-06-16
152 reads
It is important for data professionals to understand security, but it's also important for end users that must handle data. However we have a lot of work to do to make that easier since Steve Jones thinks many IT pros struggle with this concept.
2011-06-15
281 reads
As technology has rapidly advanced our communications, we have not necessarily learned to deal with the implications and challenges of this anywhere, anytime communication reach. Steve Jones reminds us that etiquette matters, even when we are designing systems.
2011-06-14
217 reads
It seems that we regularly hear about outages from various cloud services. Steve Jones comments that we are likely to have this happen more and more, but it's shouldn't happen at a rate greater than in house IT services.
2011-06-13
152 reads
If you’re not where you want to be in your career, then what do you think is holding you back?
2011-06-13
207 reads
This Friday Steve Jones asks you if you want more knobs for SQL Server or less? It's a debate that balances the need for the DBA to know more with the resources Microsoft spends to build better tuning into the product.
2011-06-10
96 reads
Today we have an editorial from Mar 22, 2006 as Steve is on vacation. Today Steve Jones notes that economics might determine how you are paid, but human nature describes how you behave.
2011-06-07
115 reads
Today we have an editorial reprinted from April 3, 2006 as Steve is on vacation. Ethics are often just as bad at the top of our companies as they are at the bottom. Steve Jones comments today on how this affects IT.
2011-06-06
111 reads
This week Steve Jones looks at a few notes that show employers are wising up overall about certifications and the value of real world skills.
2011-06-06
153 reads
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
I'm fairly certain I know the answer to this from digging into it yesterday,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
hi everyone I am not sure how to write the query that will produce...
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