SQL Saturday 97 has ended
Well it isn’t quite over for me just yet, I still have a flight home tomorrow and can’t wait to...
2011-10-02
473 reads
Blog Posts
24 HOP recordings
For all of you, that you have missed any session from the last 24 HOPass - you can check here
24 Session...
2011-10-01
1,156 reads
Come For The Education Stay For The Networking
OMG! SQLSATURDAY #97 IS HERE!
I am really excited about SQLSaturday #97! In just a few short hours we will be...
2011-10-01
745 reads
How to find out which Table is not having rows in SQL Server?
Introduction
Many times while tuning our production databases we might try to find out the list of tables not having even...
2011-10-01
2,315 reads
Live Blogging SQL Saturday #97 Austin (hashtag #sqlsat97)
Hello and welcome to my live blog/recap of SQL Saturday #97 in Austin! Wes Brown and the crew from CACTUSS...
2011-10-01
494 reads
October Question: What one thing do you feel has the greatest impact on SQL Server’s performance?
When it comes to databases, many DBAs obsess over performance, and for good reason, as when user’s begain to complain...
2011-10-01
1,092 reads
SQL Saturday 97 starts in 7 hours
I flew into Austin Texas today and got to spend time with a lot of great people. The journey started...
2011-10-01
526 reads
A Good Time to Be a SQL Server Professional
Wow! Can't believe today is the last day of September! Fall, here we come! Although Summer is over, Autumn is...
2011-09-30
1,977 reads
Creating your first Data Mining Structure and Model
Data mining is a great way to help your company make decisions and predict future values. The Data Mining Algorithms...
2011-09-30
8,694 reads
Free SQL Server in the City Event to be Held in LA
Red Gate Software will be providing a free, full-day SQL Server event called SQL in the City in Los Angeles,...
2011-09-30
1,411 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