title: Powershell - The term 'New-SqlColumnEncryptionKey' is not recognized - trying to create Column Encryption Key
body: <p>I'm using Powershell 7.0.3.
  Having connected to azure (via connect-AzAccount) I can list my Column Master Keys:</p>
  <pre><code>Get-SqlColumnMasterKey -InputObject $database
  
  Name
  ----
  MYDB_CMK
  MYDB_CMK2
  </code></pre>
  <p>On attempting to create a Column Encryption Key..</p>
  <pre><code>New-SqlColumnEncryptionKey -Name &quot;MYDB_CEK&quot; -InputObject $database -ColumnMasterKey &quot;MYDB_CMK&quot;
  </code></pre>
  <p>I get the following error:</p>
  <pre><code>New-SqlColumnEncryptionKey: The term 'New-SqlColumnEncryptionKey' is not recognized as the name of a cmdlet, function, script file, or operable program.
  Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
  </code></pre>
  <p>As far as I'm aware the commands <strong>Get-SqlColumnMasterKey</strong> and <strong>New-SqlColumnEncryptionKey</strong> should be in the same module, loaded via</p>
  <pre><code>Import-Module &quot;SqlServer&quot; 
  </code></pre>
  <p>What have I missed?</p>