Reducing the Use of TempDB to Keep Costs Down

Reducing the Use of TempDB to Keep Costs Down

There comes a time in everyone’s life that they need to be concerned about tempdb. I know… we all have configured it correctly and it’s running great. The application and all of the developers are using it like crazy …Wait… that may not be a good thing....
How to Enable TDE on Availability Group

How to Enable TDE on Availability Group

Transparent Data Encryption(TDE) encrypts SQL and azure database files by encrypting data at rest. In a situation where your physical media such as data, log and backup files get stolen the malicious party can restore/attach the database and retrieve data. TDE...