New answers tagged

2 votes

Finding encrypted SQL database instances in our SQL Server Estate

You can use the DbaTools' Powershell module, which has a command Get-DbaDatabase Get-DbaDatabase -SqlInstance SomeServer -Encrypted You can even find all servers using Find-DbaInstance Find-...
Charlieface's user avatar
  • 12.5k
3 votes
Accepted

Finding encrypted SQL database instances in our SQL Server Estate

Quick -- that would depend. But if it were me, I'd set up a central management server and register all your SQL Servers there. There's a really good introduction to the feature here: https://www.red-...
Stephen Morris - Mo64's user avatar
0 votes

SQL Server 2022 - Polybase External Tables - Create a master key

The database master key password is not requested when using Polybase, so you need to drop the existing and create a new one, since you don't have the password you specify a new one. Once done, the ...
pabechevb's user avatar

Top 50 recent answers are included