Database = $databasename

   ServerInstance = $ServerName

   Username = $UserName

   Password = $password

  'OutputSqlErrors' = $true

   Query = $QueryString

  }

  Invoke-Sqlcmd  @params

$ConnString = "DRIVER=ODBC Driver 13 for SQL Server;SERVER=xxxxx.database.windows.net;DATABASE=DBName;Trusted_Connection=Yes"
    $Conn = new-object System.Data.Odbc.OdbcConnection($ConnString)
    $conn.open()
    $cmd = new-object System.Data.Odbc.OdbcCommand("select getdate() as X", $Conn)
    $data = new-object System.Data.Odbc.OdbcDataAdapter($cmd)
    $dt = new-object System.Data.DataColumn
    $data.Fill($dt)
    $Conn.Close()

#`server=Server;database=Database;Authentication=ActiveDirectoryIntegrated;`