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,429 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,276 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,704 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,161 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,470 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,131 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,790 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,418 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers