Skip to content

Instantly share code, notes, and snippets.

View rafaelvelosoAZ's full-sized avatar

rafaelvelosoAZ

13 followers · 7 following
View GitHub Profile
@rafaelvelosoAZ
rafaelvelosoAZ / gist:04242fca6a3abc9988f4ffa23cb67556
Created June 2, 2022 18:22
Validanting the Map
xp_cmdshell 'dir z:\'
@rafaelvelosoAZ
rafaelvelosoAZ / Mapping the file share
Created June 2, 2022 14:30
Mapping a local from file share to SQL Server
xp_cmdshell 'net use Z: "\\StorageAccountName.file.core.windows.net\FileShareName" /user:Azure\StorageAccountName StorageAccountAccessKey'
@rafaelvelosoAZ
rafaelvelosoAZ / Enabling xpcmdshell
Last active June 2, 2022 14:26
Query to enable 'xpcmdshell' on SQL Server
EXEC spconfigure 'show advanced options', '1'
RECONFIGURE
-- this enables xpcmdshell
EXEC spconfigure 'xpcmdshell', '1'
RECONFIGURE*