Microsoft introduced the APPLY operator in SQL Server 2005. Similar to a JOIN, it allows correlation between two table expressions. The key difference between the JOIN and APPLY operators is when you have a table-valued expression on the right side and want to evaluate it for each row from the left table expression. Since they produce similar results, when do you choose an APPLY versus a JOIN?
This article explains how to customize an extended events session in SQL Server Analysis Services for auditing and monitoring
Most of us believe in the importance of data. Steve has a few thoughts on using data to determine if AI is helpful.
The Tabular Model Definition Language (TMDL) provides a simpler way of defining Power BI Semantic Models. Unlike the JSON-based Tabular Model Scripting Language (TMSL), TMDL uses a more accessible tab-based format for specifying DAX measures, relationships, and Power Query code.
Learn how to query your jobs to produce a report that is formatted to make consuming the data easy for DBAs.
We will all make mistakes, but practice can help reduce the errors we cause.
You’re building a new table or adding a column, and you wanna know which datatype to use: VARCHAR or NVARCHAR?
This article examines the new regular expression functions added to T-SQL in SQL Server 2025.
Steve has a good reason to spend time working with and learning about AI technology.
There are numerous use cases for multi-file imports of CSV files into a SQL Server table:
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Jl. Kemanggisan Utama Raya No.37, Kemanggisan, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus Ibukota...
Komp. Bojong Indah Cengkareng, Jl. Pakis Raya 88 H, Daerah Khusus Ibukota Jakarta 11740
Jl. Mandala Raya No.14, RT.13/RW.5, Tomang, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
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