Azure DWH part 16: BCP to import and export data
In Azure SQL Data Warehouse we can use BCP to export or import the data. In this article, we will show how to do it.
2017-09-26
2,291 reads
In Azure SQL Data Warehouse we can use BCP to export or import the data. In this article, we will show how to do it.
2017-09-26
2,291 reads
In this article, we will learn how to query a csv file stored in the Data Lake using PolyBase.
2017-09-05
2,667 reads
In this article we will load data from a SQL Server on-premises to Azure SQL Data Warehouse
2017-08-01
841 reads
In this article we will show some common roles and queries related to Azure SQL Data Warehouse.
2017-07-25
5,138 reads
There is a new utility to import data from SQL Server on premises or Azure SQL to Azure SQL Data Warehouse (ASDW)
2017-07-17
1,734 reads
In this article, we will show how to create a WPF application and show how to insert data to ASDW.
2017-07-10
889 reads
In this article, we will compare two folders using PowerShell, the command prompt and other tools.
2017-05-30
2,379 reads
In this new Azure Data Warehouse article, we will show how to insert data and retrieve it using PHP.
2017-05-22
658 reads
In this new article, we will learn how to access to our Azure DWH tables using C#.
2017-05-15
2,371 reads
In this chapter, we will show how to create a Machine Learning experiment from our Azure SQL Warehouse.
2017-05-05 (first published: 2016-06-14)
5,786 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers