Be Responsible
When getting help online, you need to be professional and a part of that is being responsible. Steve Jones reminds us today that we have to be careful about what we post.
2010-03-02
544 reads
Editorial
Reaching for the Clouds
This past week's news had a lot of news about cloud computing and Steve Jones comments on a few database related items.
2010-03-01
91 reads
Overusing Identities
Do you put an identity column on every table? That might be a bad habit you want to kick, but not all at once. Steve Jones comments on this common data modeling practice.
2010-03-01
333 reads
Timing is Everything
For this Friday poll, Steve Jones asks about storing time values. Should they always be in UTC? Does that solve more problems than it creates?
2010-02-26
321 reads
Dude, Your Fly is Open
A guest editorial from Tim Mitchell today talks about the way you handle problems. Other people's problems. A professional way of pointing out mistakes is the best policy.
2010-02-25
305 reads
Data Dashboards
Google recently unveiled a dashboard to allow users to manage the data that Google stores about them. Including removing search data! Steve Jones comments on the possibility of implementing this for other companies.
2010-02-24
403 reads
Multiple Mirrors
Should we evolve the database mirroring technology to work with multiple mirrors? Steve Jones says this might be an interesting idea.
2010-02-23
334 reads
Oracle: Overhaul or Overkill?
Vendor-specific hardware might make Oracle less painful to use in the future, so Chris Massey considers whether Microsoft should consider providing a more tailored and complete product with SQL Server. The verdict? "Not necessary".
2010-02-22
151 reads
FizzBuzz
Can most programmers not program? A new test, the FizzBuzz test, is being used to weed out candidates. Steve Jones comments on the types of FizzBuzz questions he's used in T-SQL.
2010-02-22
1,460 reads
When Do You Deploy?
Finding downtime can be hard at times, but Steve Jones recently found a company that took it during the week. This Friday's poll asks when you can have downtime.
2010-02-19
105 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