Learn how you can create a logging module in Python that can be used to insert real-time records in a PostgreSQL database and display them on a dashboard.
2025-11-12
1,020 reads
I have data coming into my SQL Server database as JSON. Before I start parsing it which is quite intensive, I need to check if some values are present in the JSON. Is there a function I can use to do this? Let’s see what the new JSON_CONTAINS function in SQL Server 2025 can do.
2025-11-12
Learn about a MySQL feature that could be useful in some scenarios for SQL Server.
2025-11-10
3,674 reads
Discover how the FULL OUTER JOIN in SQL can simplify queries, improve performance, and solve real-world data problems
2025-11-10
This article takes a look at the changes in SQL Server 2025 to the SUBSTRING function.
2025-11-07
8,413 reads
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?
2025-11-07
This article explains how to customize an extended events session in SQL Server Analysis Services for auditing and monitoring
2025-11-05
1,426 reads
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.
2025-11-05
Learn how to query your jobs to produce a report that is formatted to make consuming the data easy for DBAs.
2025-11-03 (first published: 2023-05-03)
3,650 reads
You’re building a new table or adding a column, and you wanna know which datatype to use: VARCHAR or NVARCHAR?
2025-11-03
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
By Chris Yates
I get asked a lot about why or how I began working with databases...
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Hey, I've not done a cube for many years but I find myself supporting...
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers