Transparent Data Encryption / TDE in SQL Server: enable, keys & certificates, backups, restore

Transparent Data Encryption / TDE in SQL Server: enable, keys & certificates, backups, restore

Transparent Data Encryption (TDE) encrypts SQL Server, Azure SQL Database, and Azure SQL Data Warehouse data files, known as encrypting data at rest. You can take several precautions to help secure the database such as designing a secure system, encrypting confidential assets, and building a firewall around the database servers. However, in a scenario where the physical media (such as drives or backup tapes) are stolen, a malicious party can just restore or attach the database and browse the data. One solution is to encrypt the sensitive data in the database and protect the keys that are used to encrypt the data with a certificate. This prevents anyone without the keys from using the data, but this kind of protection must be planned in advance.

ms sql server (en)

  • Hits: 8031

How to remotely restart Windows service with Powershell

How to remotely restart Windows service with Powershell

In case if you need to remotely restart Windows service, here is my Powershell script.

As soon as we have ICMP/ping disabled between our development environments, I've used WMI pings to determine, if remote machine is running.

script (en), Windows (EN), powershell (en)

  • Hits: 7962

Grant access to Azure SQL PaaS

Grant access to Azure SQL PaaS

When you need to grant access to Azure SQL PaaS database, you can use following T-SQL scripts.

ms sql server (en), azure (en)

  • Hits: 14653

Executable or batch-file as service in Windows with Powershell DSC

Executable or batch-file as service in Windows with Powershell DSC

In case if you ever need to create Windows service from an executable or even bat-file, please feel free to use the following configuration in Powershell DSC.

The solution based on the NSSM software which is very similar to srvany.exe (from Windows 2003 Kit). The main difference NSSM from srvany - is that srvany does not close the underlying process if the service is stopped. And NSSM does close it. Download NSSM.

Windows (EN), dsc (en)

  • Hits: 6704

How to unzip big archives in Powershell DSC configurations

How to unzip big files in Powershell DSC configurations

If you ever need to unzip BIG archive files in Powershell DSC configurations (during deployment some software), you will possibly get stuck, because using Archive resource is not suitable for this task as it is very slow. xArchive also will not help.

One possible solution is to unzip it with 7zip or some other command line utility using WindowsProcess resource, but be warned that WindowsProcess will just start the process and then will go to the next instruction in your configuration. See the example:

powershell (en), dsc (en)

  • Hits: 6049

Save Powershell-console output to text file

Save Powershell-console output to text file

Sometime it's very difficult to find error in Powershell script, especially if script is running in some dedicated session, for example, under SYSTEM account. There will be errors but you'll never know about them.

That's why I started to search a way to log output from Powershell-console to file. Here is the solution.

powershell (en)

  • Hits: 15121

Error "Get-PowerCLIVersion : The term 'Get-PowerCLIVersion' is not recognized as the name of a cmdlet, function, script file, or operable program." while starting VMware vSphere PowerCLI

Error "Get-PowerCLIVersion : The term 'Get-PowerCLIVersion' is not recognized as the name of a cmdlet,   function, script file, or operable program." while starting VMware vSphere PowerCLI

Sometimes the following error appear while starting VMware vSphere PowerCLI:

Get-PowerCLIVersion : The term 'Get-PowerCLIVersion' 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.
At C:\Program Files (x86)\VMware\Infrastructure\vSphere
PowerCLI\Scripts\Initialize-PowerCLIEnvironment.ps1:38 char:12
+ $version = Get-PowerCLIVersion
+ ~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (Get-PowerCLIVersion:String) [], CommandNotFoundExce
ption
+ FullyQualifiedErrorId : CommandNotFoundException

vmware (en), powershell (en)

  • Hits: 17224

Page 3 of 13