F# Type Inference
I’m just starting to look at functional languages from an Object Oriented background. One of the first things I thought...
2015-01-23
38 reads
Gavin Draper
Tools For Successful Remote Working
I’ve been asked a few times recently how I find remote working and how well it works so I thought...
2014-10-13
41 reads
Entity Framework Fluent API and Indexing
With the release of Entity Framework 6.1 the Fluent API can now be used to create indexes. It’s still pretty...
2014-06-26
144 reads
Rails Continuous Testing
Coming from the .Net world where continuous testing is expensive on both the wallet and processing power seeing what Ruby...
2014-03-11
49 reads
Browser Based Web Notifications
3 of the 4 major browsers now support web notifications (Safari, Firefox, Chrome) and no where near enough sites are...
2014-03-01
46 reads
Cloning a SQL Server Database
The following script will backup and restore a database to the same server with a different name. Tested on SQL...
2014-03-01
45 reads
Using Google Charts With AngularJs
I recently rewrote a small webpage in AngularJs and it was amazing how much lighter and cleaner it made the...
2013-07-30
95 reads
Debugging Issues With Log4Net Not Logging
When you find log4net is not writing anything to your logs it can be a pain to debug as obviously...
2013-07-29
153 reads
ASP.Net MVC Debugging "Internal Server Error 500"
I was recently seeing “Internal Server Error 500” when trying to make an ajax call from an ASP.Net MVC view...
2013-06-22
500 reads
Das Keyboard - First Thoughts
There seems to be a lot of buzz around mechanical keyboard lately as more and more manufacturers have started producing...
2013-06-19
43 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