Make a Backup First
The hack on a Gizmodo writer using Amazon and Apple customer service security holes was shocking. Steve Jones notes that while security is important, backups are even more important.
2012-08-22
173 reads
Editorial
Big Data Jobs
Big Data is in the news and there is a lot of job growth. Steve Jones lists a few industries and areas where you might find one.
2012-08-21
306 reads
Time Off
Finding a balance between work and life away from work is hard, but one good way is with periodic vacations. Today Steve Jones notes that some people don't take their vacation, which he sees as a problem.
2016-09-01 (first published: 2012-08-20)
257 reads
Brad McGehee Moves On
The SQLServerCentral and Database Weekly editors recognize the contribution of Brad McGehee to the websites and newsletters, and to DBA education in general, over the past 5 years.
2012-08-20
161 reads
The Influence of the Cloud
This Friday Steve Jones is talking clouds. In the next year, will the cloud influence your job or will it be a fad for you?
2012-08-17
141 reads
Marketing Data is Exploding
The explosion of social media data has resulted in a lot more marketing data for companies. Some are using it well and some aren't, but in both cases, Steve Jones notes there are more opportunities for data professionals.
2012-08-16
151 reads
Learning C
As we use computers more and more, and more people must develop algorithms or simple programs, Steve Jones says everyone should learn C. Perhaps they should learn SQL as well.
2012-08-15
337 reads
Milk
Genome research into producing the best cows for milk has Steve Jones thinking about the implications for other industries. There could be new opportunities for data professionals.
2012-08-14
127 reads
No Limits
Google recently promised no limits to their computing engine online. Is that going to change how we use cloud computing? Read Steve Jones' thoughts and give us your opinion.
2012-08-13
103 reads
Avoiding Stored Procedures
This week Steve Jones argues against stored procedures. Is it a good argument or do want to stick with your stored procedures.
2016-08-30 (first published: 2012-08-13)
1,078 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
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