RAID 5 and SQL Server
Given that disk storage has come down substantially in price over recent years, will RAID 5 continue to be relevant as a storage configuration for databases?
2011-01-10
815 reads
Editorial
Data Loss or Downtime
This Friday Steve Jones has a DR poll. He asks what might be more important to you in a disaster and why.
2015-07-10 (first published: 2011-01-07)
243 reads
Trust People
Steve Jones thinks that we are not doing a great job of harnessing the brain power of our entire teams.
2015-07-13 (first published: 2011-01-06)
312 reads
In Case of Breach
Do you know what to do in case of a data breach? Steve Jones talks about the importance of having a "runbook" for security that covers the same types of things you might need to know for disaster recovery.
2011-01-05
151 reads
Welcome to 2011
After the holidays, Steve Jones welcomes everyone in the SQLServerCentral community to the new year and talks about goals and your career.
2011-01-04
176 reads
Being Careful with Power
It's good to be careful with your power consumption, especially as the power cost of computing continues to grow. However with your SQL Server, you don't want to be too careful, as Steve Jones notes.
2011-01-03
297 reads
Clouds Are In our Future
Today we have a guest editorial from Andy Warren looking at the future of cloud computing and SQL Server.
2011-01-03
186 reads
Enjoying the New Year
For the last Friday poll of the year, Steve Jones has a fun one. Add your input and give everyone an idea of how to spend the last part of this holiday season.
2010-12-31
65 reads
The Year of the Community
Steve Jones looks back at 2010 and dubs it the year of the community. Join him for a look back at some events in the SQL Server world from 2010.
2010-12-30
93 reads
The Office
Would you be more productive outside of an office? Would you take a pay cut to work outside of an office? Steve Jones notes that a number of IT professionals said they would.
2015-12-07 (first published: 2010-12-29)
292 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
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...
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