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
SQL Server Central
Another Fall Book Sale
We've added a few more bundles to our sale, including a new book: The Best of SQLServerCentral.com - vol. 4. If you're not coming to the PASS 2006 Summit, this is your chance to snag this volume for your corporate bookshelf.
2006-10-17
2,119 reads
End to End Training
The training arm of SQLServerCentral.com is spinning off to its own company. This is the place to come for high quality custom training.
2006-10-16
2,334 reads
Fall Book Sale
We're blowing out inventory again to make room for new books. Stock up your SQL Server library with a few of our titles.
2006-10-02
3,715 reads
The Big Three
Come to the PASS Summit this year and see three of the big influences on SQL Server: Steve Ballmer, Paul Flessner, and Dave Campbell. They're all giving keynotes. And did I mention SQLServerCentral.com is giving away an XBOX 360? Read more about it.
2006-09-28
1,708 reads
Email Changes
We've changed the way we send email for the newsetters. Read about our new address and whitelisting.
2006-09-12
2,441 reads
SSIS At Christmas
Due to overwhelming demand, we've opened up another Integration Services class. Start Christmas vacation early in Orlando on Dec 18.
2006-08-28
2,161 reads
Become an ETL Expert
Learn ETL solutions from SQL Server MVP Brian Knight at the SQLServerCentral.com training center.
2006-08-08
6,255 reads
Contract Work
Make a little extra money and find a contract job through our partnership with HohGigs.
2006-06-14
5,826 reads
PASS 2006 Reception
Once again the SQLServerCentral.com staff is putting on a Tuesday night reception. Read how you can attend this November in Seattle.
2006-06-13
1,876 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