Now exactly which proposal is this
Introduction
Oft times we are forced into situations where we clearly need to think outside of the box. A case at...
2016-03-10 (first published: 2016-03-01)
1,349 reads
SQL Server 2014 Launch Party Mississauga Ontario (Toronto) June 21, 2014
This event promises to be a highlight of the Canadian SQL Server calendar year.
The presenters are all 'first class'.
All...
2014-05-27
808 reads
SQL Server 2012 and 2014 and Windows 8.1 Professsional CPU goes up to 100% all freezes and Analysis Services Crashes
<p>Hi All This is a note that I just sent out. I hope that this helps those contemplating upgrading to...
2014-03-24
1,095 reads
Master Data Services for the Beginner Part 03
Introduction
In yesterday’s discussion we looked at creating entities and their related attributes. We learnt that a ‘model’ could be very...
2014-02-05 (first published: 2014-01-28)
6,196 reads
Master Data Services for the Beginner Part 06
Introduction
The consumers of our data wish to be able to make stock and financial decisions from our data. Turning raw...
2014-02-02
1,798 reads
Master Data Services for the Beginner Part 05
Introduction
In yesterday’s discussion we looked at creating a current flag, creating views and looking at some of our data. Today...
2014-02-01
1,900 reads
Master Data Services for the Beginner Part 02
Introduction
In the first part of this discussion, I discussed step by step instructions pertaining to getting up and running with...
2014-01-29 (first published: 2014-01-27)
5,222 reads
Master Data Services for the Beginner Part 04
Introduction
In yesterday’s discussion we looked at populating entities and their related attributes. In today’s discussion we shall be concentrating on...
2014-01-29
2,096 reads
Master Data Services for the Beginner Part 01
Introduction
About 12 months ago, I started to look at Master Data Services in a serious manner. I had toyed with...
2014-01-26
5,296 reads
Master Data Services Disaster Recovery Challenges
Introduction
While Master Data Services is the best tool to come along to permit user to update their qualitative and quantitative...
2014-01-25
3,588 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