Join Two CSV Files with a Common Column
In this example we will join two CSV files with a common column using SQL Server.
2017-01-23
7,421 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Data Mining Introduction
Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.
2017-01-20 (first published: 2012-11-12)
55,025 reads
Data Mining Introduction
Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.
2017-01-20 (first published: 2012-11-12)
52,795 reads
Azure DWH part 1:Common questions about Azure SQL Data Warehouse
This article compiles some common questions and answers about Azure SQL Data Warehouse.
2016-12-28
9,273 reads
Downloading multiple files from internet with SSIS and C#
This is a tutorial to download multiple files from internet using the SSIS Script Task.
2016-12-08
7,703 reads
How to download a file from internet using SSIS
In this example, we will show how to download a file from internet using SSIS.
2016-12-01
12,156 reads
Exporting Data from JSON to CSV with SSIS
The following tutorial will show how to export JSON data to a CSV file using SSIS
2016-11-15
5,466 reads
PowerShell Solutions - Working with files
When we administer a SQL Database, we always have to work with files. This new article shows how to handle them using PowerShell.
2016-10-04
3,129 reads
PowerShell Solutions - Several tips for daily tasks
In this tip, we will talk about PowerShell and SQL Server Log and Data Files.
2016-09-27
3,789 reads
A Tutorial With the Azure CLI (Command-Line Interface) and Azure SQL Database
In this article, we will show how to install Azure CLI and then create an Azure SQL Server and a SQL Database.
2016-08-22
3,417 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers