Seattle SQL Pro Workshop 2017
Seattle SQL Pro Workshop 2017
October is a great time of year for the SQL Server and Data professional. There are...
2017-10-25 (first published: 2017-10-19)
1,130 reads
Jason Brimhall
Seattle SQL Pro Workshop 2017
Free workshop on SQL Server leading up to Summit 2017 that will provide attendees an alternate means to increase affordable learning opportunities during the week.
Related Posts:
Seattle SQL Pro Workshop...
2017-10-19
3 reads
Linked Servers and Stats
A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for...
2017-10-17
242 reads
Linked Servers and Stats
Linked Servers
A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and...
2017-10-17
1,361 reads
Your Name is Your Brand
This topic is one that has been stewing for a while and finally this week it decided to boil over.
My...
2017-10-13
479 reads
Your Name is Your Brand
Building your brand is not an overnight sensation. It does take a while and possibly a bit of luck here or there along the way. The one thing it...
2017-10-13
3 reads
SSRS Subscription Schedules
Reporting Services
Reporting Services (SSRS) is a tool that permits you to create and deliver feature rich reports. The reports can...
2017-06-06 (first published: 2017-05-23)
4,091 reads
Endpoint Owners – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2017-06-05
1,618 reads
Endpoint Owners – Back to Basics
"What the heck is an endpoint?" Well, that is a good question. An endpoint in the simplest form is a connection or point of entry into SQL server.
Related Posts:
Changing...
2017-06-05
37 reads
SSRS Custom Shared Schedule
Reporting Services
Reporting Services is a pretty feature rich tool for delivering reports to various consumers. There is plenty of power...
2017-06-02 (first published: 2017-05-22)
6,699 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
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Foreign Keys - Foes or Friend?
Comments posted to this topic are about the item Foreign Keys - Foes or...
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