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:
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
WhatsApp:0817-866-887 Jl. Kalierang No.Ruko 3-5, Dukuhturi, Kec. Bumiayu, Kabupaten Brebes, Jawa Tengah 52273 (@bcakcpbumiayu)
WhatsApp: 0817839777 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota...
WhatsApp: 0817839777 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah...
When running bcp on Linux, what is the field terminator?
See possible answers