Skip to content

Instantly share code, notes, and snippets.

@garrytrinder

garrytrinder/SetupExternalStorage.sql

Created March 3, 2019 16:00
Show Gist options
  • Save garrytrinder/4f40d34947e075f7a60c54500fe3a5bb to your computer and use it in GitHub Desktop.
Save garrytrinder/4f40d34947e075f7a60c54500fe3a5bb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SetupExternalStorage.sql
CREATE MASTER KEY ENCRYPTION BY PASSWORD='<insert strong password>';
CREATE DATABASE SCOPED CREDENTIAL harvestdata001credential
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = '<insert shared access signature>';
CREATE EXTERNAL DATA SOURCE harvestdata001
WITH ( TYPE = BLOB_STORAGE,
LOCATION = 'https://harvestdata001.blob.core.windows.net',
CREDENTIAL= harvestdata001credential);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment