When the next object-persistence boat comes in.
Phil enjoys an old Microsoft Training manual and wonders why it is no longer possible to encompass the whole of SQL in a 400 page book any more..
2009-06-29
1,933 reads
Blogs
The secret skill revealed in the dusty booklet
Going through one’s father’s belongings after his death is always a poignant, bitter-sweet experience. I was going through his most precious books a while back; there were books that were written by him, books by friends and relatives, books about friends...
2009-06-26
2,357 reads
Enabling Checkpoints in your SSIS Packages
Checkpoints are a great tool in SSIS that many developers go years without even experimenting with. I hope to enlighten you on what Checkpoints are and why it is beneficial to use them. Also, I will walk you through a basic example package where they...
2009-06-25
3,892 reads
Tips on Getting HIred – Part 3
Part 1 discussed ways to find opportunities, Part 2 was about how to get more interviews, and today we’ll cover some tips from the employer perspective. Don’t use an AOL.com email address. Seriously. Gmail, Live, Yahoo, all are good, but AOL.com makes...
2009-06-24
2,538 reads
Tips on Getting Hired – Part 2
Yesterday I posted Part 1 containing five ideas for those looking for work. Today I’m going to focus on what to do when you’re struggling to get interviews. Your chances of getting hired for any given job once you interview are perhaps 1 in 10 (an unscientific...
2009-06-23
2,333 reads
What I’ve Read and Recommend to Others – SQL Server 2008 Part 1
I read, a lot. I’ve been a prolific reader all my adult life. I use to split my reading between tech books and my regular relaxing reading but since I got into audio books several years ago I just pretty much read tech books now. Some times I’ll listen..
2009-06-22
2,905 reads
Three Years late, Was It Worth The Wait? Windows 7, Vista Promises Delivered.
Having been married to Microsoft for most of my professional career doesn’t mean I drink the Kool-Aid. I have had the distinct privilege to grow up in interesting times. I loved DOS. As a BBS operator DOS was the de facto OS for most BBSes that ran on..
2009-06-19
3,001 reads
Starting Conversations - Part 6
As I've related previously (Part 1, Part 2, Part 3, Part 4, Part 5) I've been working author and speaker Don Gabor on my networking skills. We recently did our final call of the six hours coaching planned, and thought I'd share some final thoughts.
2009-06-18
1,274 reads
SSC, more than a Forum, it is a Community
I recently posted a poll on SQLServerCentral.com asking what sites people tended to frequent. So far, there haven't been a whole lot of votes, but those who have, have been unanimous in using SQLServerCentral.com and have indicated that there are...
2009-06-17
1,211 reads
One Database, One Server
As background, I've never been a fan of multiple instances. It's a useful thing to have available and I use it on a server today, but it's never provided a solid way of isolating resources for each instance. Next, one of the things I evangelize...
2009-06-16
3,267 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
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...
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