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,433 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
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,277 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,163 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,472 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,791 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
Backup Strategy in Azure SQL?
Everybody says that the backup process in Azure SQL is very easy. Is that true? In this new article, we will show how to do it.
2016-08-08
1,653 reads
How to Run Scheduled Jobs in Azure SQL Databases
This article will help you to schedule jobs in Azure SQL.
2016-08-01
14,179 reads
Blogs
Tooling for Success: The Best FinOps Tools and Technologies
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers