Visit the SQLounge at PASS 2005!
Tried at TechEd and manned by the SQLServerCentral.com crew, this was a great idea. It's going to be at PASS and hosted by James Luetkehoelter.
2005-09-21
2,928 reads
Press Release
The SQLServerCentral.com Casino Party at the PASS Summit
It is just next week that the PASS 2005 Summit kicks off and we've got some information about our casino party for those attending.
2005-09-20
3,555 reads
Come To The PASS 2005 Summit
Less than two weeks away, sessions tried and tested at the PDC, the Microsoft SQL Server development team and gambling with SQLServerCentral.com! Register today!
2005-09-15
2,941 reads
Extreme SQL Server
Clustering, partitioning, database snapshots, database mirroring, SQL Server SAN storage design and more are all in the September issue of the SQL Server Standard.
2005-09-12
5,088 reads
Who Is Using SQL Server 2005?
The release of SQL Server 2005 is a few months away and there are many people that are excited and looking forward to moving the new release into production. But what percentage of people are really looking to adopt the new platform soon? Edgewood Solutions has put together a survey to see. Enter and you could win a prize.
2005-08-24
4,897 reads
SQL Server Stumper Sale
The amazing 4S sale! Our space constraints are your gains as we've put a bunch of books on sale. Check them out and save.
2005-08-23
4,276 reads
Jacksonville - 2005 Code Camp
If you are near the Jacksonville, FL area on Saturday, August 27th, check out this code camp with our own Brian Knight. Get the chance to learn some great development from Brian and a few other experts.
2005-08-17
2,958 reads
SSC Source Code for the PASS 2005 Summit
With a month left before the 2005 PASS Summit, there is yet another great reason to attend this SQL Server conference in 2005. Read about it and be sure that you register today with our source code "SSC".
2005-08-10
2,822 reads
Quickshift and SQLServerCentral.com Database Performance Survey
If you live in the US, take a few minutes for this performance survey and you could win an Amazon gift certificate.
2005-08-02
3,268 reads
SQLServerCentral.com Blogs
They're here, ready and waiting for the community to dig in and enjoy. Read a little about them and how you can get your own SQLServerCentral.com blog.
2005-07-14
3,244 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
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
Ready to launch your next big game?
Looking for a creative and experienced mobile game development company that brings your game...
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