SQLServerCentral.com Email Changes
As we begin a migration to a new hosting facility, we'll keep you informed. The first step is an email migration.
2007-03-07
1,499 reads
Press Release
Upcoming Meeting for Southern New England SQL Server User Group
If you are near Rhode Island, there's a new user group available with SQL Server Guru Grant Fritchey presenting.
2007-02-28
1,153 reads
The 2007 PASS Summit Is Coming to Denver
Register now and Save $300!!! And also come to the SQLServerCentral.com party!
2007-02-20
1,581 reads
SQL Maestro Offers SQLServerCentral.com Members a Discount
SQL Maestro, maker of tools for a variety of database platforms, is offering a 20% discount on their tools to the SQLServerCentral.com
community.
2007-02-07
1,500 reads
Product Discussions, Questions, and Comments
In response to a number of suggestions, we have setup new forums where you can ask and comment about the various third party products that you use with SQL Server.
2007-01-02
1,367 reads
Updated Terms
A few minor changes to our privacy policy and terms, but in the spirit of disclosure, we're making the announcement.
2006-12-22
1,554 reads
Free Phil Factor eBook: Confessions of an IT Manager
Download a 108-page eBook in which Phil Factor lifts the lid on the victories, defeats and absurdities of a career spent in the rough-and-tumble of the IT industry. The paperback will to available to buy from Lulu.com shortly ($25), but the eBook is free for registered Simple-Talk.com users
2006-12-18
2,529 reads
A Special Announcement from Andy, Brian, and Steve
It's been five and a half years since SQLServerCentral.com was founded by Andy, Brian, and Steve. We've greatly enjoyed the time and we're looking forward to many more, but a major announcement today changing the way we will operate in the future.
2006-11-14
11,851 reads
Book Sale
We've put together some great new sale items for that SQL person on your Christmas list. Even if that person is you!
2006-11-10
3,251 reads
Get Your SQL Server Standard Electronically
We've moved the subscriptions for the SQL Server Standard to it's own site and just completed the November issue. Read on for how to access your subscriptions or subscribe today.
2006-10-25
2,097 reads
Blogs
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
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