Beginner’s Mind
In the past years I would set out my year-ahead goals both on the personal and career fronts by looking ahead at the things I want to attain or...
2020-03-11 (first published: 2020-03-03)
388 reads
Marlon Ribunal - SQL, Code, Coffee, etc.
Book Review: Eat People – And Other Unapologetic Rules For Game-Changing Entrepreneurs
This book simply answers the question "What's the next big thing?". The "Unapologetic Rules" will walk you through the many elements of exactly finding that out. Continue reading ?
The...
2019-11-04
25 reads
Certification on Orchestrating Big Data with Azure Data Factory
I took a break from blogging this week to finish the course for and get certified with Orchestrating Big Data...
2019-04-03 (first published: 2019-03-16)
1,121 reads
SQL Server 2017 Reporting Services: The Basics Part 5
We’re now on Part 5 of our SQL Server Reporting Services Basics Series. In this installment, we’ll learn how to...
2019-03-21 (first published: 2019-03-09)
3,421 reads
Transforming Data With Azure Data Factory Data Flow
Azure Data Factory (ADF) offers a convenient cloud-based platform for orchestrating data from and to on-premise, on-cloud, and hybrid sources...
2019-03-01
1,961 reads
Copy Data From On-Premise SQL Server To Azure Database Using Azure Data Factory
Let’s take a break from our SQL Server 2017 Reporting Services Basics Series and jump to Azure Data Factory (v2)....
2019-02-21
1,859 reads
SQL Server 2017 Reporting Services: The Basics Part 4
Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time...
2019-02-16
381 reads
SQL Server 2017 Reporting Services: The Basics Part 3
Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time...
2019-02-08
739 reads
SQL Server 2017 Reporting Services: The Basics Part 2
Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time...
2019-02-22 (first published: 2019-02-01)
3,063 reads
SQL Server 2017 Reporting Services: The Basics Part 1
I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time I...
2019-02-13 (first published: 2019-01-25)
3,796 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
BRI KANCA JAMBI WhatsApp 08980343752
<!--more-->BRI KANCA JAMBI WhatsApp 08980343752 Jl. Dokter Sutomo No.12, Ps. Jambi, Kec. Ps. Jambi,...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers