Adrien Siffermann

icon indicating a website link http://geeklearning.io icon indicating an email [email protected]

icon company Geek Learning icon location Paris icon location I'm a freelance full stack developer. I love Cloud and Web development, automation and ALM. Cultural all-rounder, science addict and bon vivant above all!

Results 4 issues of Adrien Siffermann

Add a predefined script for the ExecuteSql task to create a login if it doesn't exist

```sql IF NOT EXISTS (SELECT name FROM sys.sql_logins WHERE name='$(Login)') BEGIN CREATE LOGIN [$(Login)] WITH PASSWORD = $(Password) END ```

enhancement

Delimit identifier for SQLCMD Login variable in predefined script

In the [predefined script CreateUser.sql](https://github.com/geeklearningio/gl-vsts-tasks-azure/blob/master/Tasks/ExecuteSql/SqlPredefinedScripts/CreateUser.sql#L3-L4), the user and login names are not delimited with brackets. The script will the fail if the $(Login) SQLCMD variable contains reserved keywords or special...

bug

AzCopy location changed on new agents

3 comment

We search if AzCopy is installed with the agent using this relative path : ["../../azcopy.exe" ](https://github.com/geeklearningio/gl-vsts-tasks-azure/blob/master/Tasks/AzCopy/azCopy.ts#L39) On new agents, it can now be found with this path: "$(Agent.HomeDirectory)/externals/azcopy", which should...

Add CopyAsync to IStore

enhancement