If you live in Florida, join our SQLServerCentral.com's Brian Knight for a Jacksonville SQL Server launch. This free event for developers and DBAs has loads of excellent content from Microsoft and area consultants.
2006-01-27
1,178 reads
The new central tool for SQL Server 2005 is the SQL Server Management Studio and you can do most anything with it. Learn about this new utility and get a head start on SQL Server 2005 with a new book from SQLServerCentral.com by Dale Elizabeth Corey.
2006-01-23
23,413 reads
sqlSentry, a leading developer of management solutions for Microsoft SQL Server, today announced that it has released the 64-bit version of its industry-leading scheduling and notification management system for SQL Server 2005, supporting both x64 and Itanium-based systems.
2006-01-11
2,711 reads
the January magazine is being printed right now and should be mailed out early next week. Read the editorial and see how you can get you e-copy now!
2006-01-03
4,845 reads
Apress is giving away some copies of this book on SQLServerCentral.com by sponsoring our Question of the Day. A sample chapter is also available online now!
2005-12-15
4,642 reads
A new product has just been released in Beta to help you with source control for your SQL Server development. Beta testers are wanted, so if you're interested, read on.
2005-12-01
3,721 reads
Cryptography and encryption are coming to many systems, including databases. Check out a sample chapter from this upcoming book.
2005-11-07
3,833 reads
The November issue of the SQL Server Standard is out and being mailed to everyone. Read the editorial and get the table of contents.
2005-11-03
3,301 reads
Take this survey for a chance at a $20 gift certificate from Amazon. Give your reasons to upgrade and your insight on performance issues.
2005-11-01
4,569 reads
How often do you check your SQL Server tables for fragmentation? How often do you defragment them? This is one of those technologies that has been available for disks for a long time, but now is here for SQL Server. Norb Technologies is offering a discount to the SQLServerCentral.com community on this product.
2005-11-01
4,111 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