Loading data in Azure Synapse using Copy
Learn how to create a Synapse resource and upload data using the COPY command.
2020-07-13
15,615 reads
Learn how to create a Synapse resource and upload data using the COPY command.
2020-07-13
15,615 reads
Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]
2021-11-26 (first published: 2019-11-04)
13,653 reads
Data classifications in Azure SQL DW entered public preview in March 2019. They allow you to label columns in your data warehouse with their information type and sensitivity level.
2019-05-31
Before writing about pausing (and resuming) Azure SQL Data Warehouse (DW) it makes sense to discuss the architecture of this product. At a high level it involves a control...
The...
2019-05-07
James Serra talks about where you should you clean your data when building a modern data warehouse in Azure.
2019-05-03
This time, we will talk about the competition or alternatives to Azure SQL Data Warehouse.
2018-06-26
515 reads
The DMV are very effective and important to administer ASDWH. In this article we will show some important DMVs.
2017-12-26
825 reads
This time we will show how to access to Azure SQL Data Warehouse using Excel.
2017-12-19
565 reads
2017-09-25
743 reads
2017-08-04
787 reads
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Dears, Hope this message finds you well I did not see in this foruns...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers