2011.....So (long pause), what's next for me?
I've actually sat down to write this blog several times. I am never indecisive when it comes to my thoughts...
2011-01-17
1,065 reads
SQLDownSouth
TechEd: Session Preference Survey
TechEd has listed some potential sessions for TechEd North America 2011 here: http://northamerica.msteched.com/sessionpreference?fbid=I1Ydc71JM4a. They want to know which sessions you...
2011-01-17
510 reads
January Baton Rouge SQL Server User Group
The Baton Rouge SQL Server User Group will be hosting its first meeting of the new year. Our meeting place...
2011-01-11
1,426 reads
First SQL Lunch of the Year - SSRS Tips and Tricks with Pam Shaw
Last Year was a great year for the SQL Lunch. We had so many great presentations. I am really excited...
2011-01-11
838 reads
Learn SSIS in Under an Hour on the SQL Lunch
Don't miss the SQL Lunch tomorrow.
#44-Learning SSIS under 1 hour
Speaker: Jose Raul Chinchilla
Add To Outlook: Add To Calendar
Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=FN36T2&role=attend
Date...
2010-12-13
912 reads
Passing SSRS T-SQL Values to SSRS MDX Parameters
At a recent client engagement we built a SQL Server Reporting Services (SSRS) report with a T-SQL based data source....
2010-12-01
2,367 reads
Handling Type II Dimension with the MERGE Statement
Microsoft attempted to make our lives easier with the Slowly Changing Dimension task in SSIS. However, as we all know...
2010-11-17
2,001 reads
My SQL PASS Summit Adventures part 1
I started my PASS Summit a little early this year. I arrived in Seattle on Friday night, November 5th, around...
2010-11-16
583 reads
Join the SQL Lunch on Tuesday
What a long week at PASS (stay tuned for more details about my trip). Now that it's over back to...
2010-11-14
670 reads
A Couple of SQL Lunches this Week
I want to apologize for posting this so late, but there is a SQL Lunch today and one tomorrow. Hope...
2010-11-03
635 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