Artificial intelligence is everywhere: It’s in our tools, our workflows, our marketing pitches…and increasingly, in our bottom lines. But a thought-provoking article published recently on the AI bubble asks a far more sobering question: What’s it really going to cost to profit from AI? Many people will roll their eyes and say, “Isn’t that obvious? […]
Steve has a few thoughts on the names we choose for tables, columns, files, and more.
This article takes a look at the changes in SQL Server 2025 to the SUBSTRING function.
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?
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Yes, you’re reading that right, we’re going to download a report that cannot be...
Reliable manufacturers can be identified by consistent product quality, strong stitching, and the ability...
Finding reliable care starts with choosing a clinic that focuses specifically on anorectal conditions...
Yes, the online Partnership Firm Registration Service in Delhi is reliable when handled by...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers