Microsoft has been running 2 day seminars on Windows 2003 across the country as well as at selected Enterprise Partner sites. Steve Jones recently attended one and has a first look at the next generation of Windows Servers.
2003-05-15
5,088 reads
Do you use @@version? sp_server_info? What's the difference? Read on to see what each of these methods returns and which one you should be using.
2003-04-21
7,064 reads
Expanding on the issue of reviewing software for SQL Server, Steve Jones proposes some standards for reviews in this article. Please take a moment to read and comment on this proposal to better help SQL Server Central.com provide you with the information that you need.
2003-04-14
3,217 reads
This article expands Steve Jones' look at ways to audit changes by examing how you can deal with the large amounts of data generated.
2003-04-07
10,586 reads
Not even worth talking about, right? Probably, but they still exist. Read about this worst practice and pass it along.
2003-03-31
5,381 reads
What should SQL Server Central provide to the community in a review? Read on and give us some feedback so we can make this site better.
2003-03-24
3,514 reads
The first article in a series about moving your data from one server to another. Steve Jones has some techniques he's used for upgrading hardware, replacing existing servers, or just moving to a different server.
2003-03-10
9,943 reads
How many databases do you manage that have a NULL owner? Hopefully none, but if you have one, want to know how to fix it, or just need a few minutes break from work, dig in and read how I solved this annoying issue.
2003-03-04
8,819 reads
A new series that examines how you audit activity in SQL Server. The first part looks at simple data auditing in a table.
2003-02-24
13,161 reads
Steve Jones recently got bit by a bug the reminded him of the Y2K fiasco. Read about the problem and how Steve solved the problem.
2003-02-17
4,617 reads
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
hi everyone I am not sure how to write the query that will produce...
Comments posted to this topic are about the item Rollback vs. Roll Forward
Comments posted to this topic are about the item Foreign Keys - Foes or...
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