Azure DWH part 2: Get Started with Azure Data Warehouse
In this article, we will learn how to use Visual Studio to query Azure SQL Data Warehouse tables and how to create a new table.
2017-01-25
2,748 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
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,443 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)
55,030 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,796 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,278 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,167 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,476 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,132 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,793 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers