Create and Read the Analysis Services Flight Recorder
This article explains how to customize an extended events session in SQL Server Analysis Services for auditing and monitoring
Data > Hype
Most of us believe in the importance of data. Steve has a few thoughts on using data to determine if AI is helpful.
Power BI TMDL View: Benefits, Security Risks & Best Practices
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.
Create an HTML Report on the Status of SQL Server Agent Jobs
Learn how to query your jobs to produce a report that is formatted to make consuming the data easy for DBAs.
Practice Until You Don't Get It Wrong
We will all make mistakes, but practice can help reduce the errors we cause.
Which Should You Use: VARCHAR or NVARCHAR?
You’re building a new table or adding a column, and you wanna know which datatype to use: VARCHAR or NVARCHAR?
Regular Expressions in SQL Server 2025
This article examines the new regular expression functions added to T-SQL in SQL Server 2025.
The Selfish Case for Learning AI
Steve has a good reason to spend time working with and learning about AI technology.
Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets
There are numerous use cases for multi-file imports of CSV files into a SQL Server table:
Reducing Cloud Cost
Cloud costs are high and growing. Some orgs think they're out of control and are trying to limit spend. Some orgs are looking to leave the cloud. A lot of IT spend over the years has been seen as a cost center, with many executives trying to limit the growth or spend, even while they […]
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers