Forcing Encryption in SQL Server
If you’re ever planning to allow external connections to a SQL Server, one of the first things to ensure is that the data is encrypted at rest and in-transit.
DBA Blog – Homepage
Index – Cheat Sheets – Notes
Categories
Database Software
SQL Server, MySQL, Postgres
Operating Systems & Native Code
Windows, PowerShell, Linux
Other
WordPress
Tags
Certificates & Encryption CSV Files Database Admin Database Backups Data Types Deleting Data Error Messages Exporting Data Featured Importing Data Installing SQL Server Linked Servers Linux Admin Logging & Monitoring Measuring Databases Restoring Databases SQL Server Agent SQL Server Management Studio SQL Server Processes Windows Admin WordPress Technical Issues WordPress Tutorials
Recent Posts
Include Execution Trace Messages in SQL Server Error Logs
Logs are always important if you’re supporting systems. The SQL Server Agent has always been a heavily used tool in my experience, so writing execution trace messages to the logs might help investigate an issue one day.
Backing up a SQL Server Database with Encryption
Backing up a SQL Server Database with Encryption is the secure way of performing your SQL Server backups. If you’re ever worried about the data within your databases, you may consider this option when performing database backups.
Backing up a SQL Server Certificate
It’s important to backup SQL Server Certificates, but only if you’re using them really. If for example, your SQL Server database backups are encrypted and you need to restore it on another server, then you will need both the certificate and private key that was used.
Running PowerShell Scripts as Scheduled Tasks in Windows
When you need something scheduled in Windows, the Task Scheduler is the tool at-hand. Running PowerShell (.ps1) scripts as Scheduled Tasks is done differently than differently than running regular .bat scripts.
How to Check What Features are Installed in SQL Server
This is a quick guide on how to check which features are installed on a SQL Server. Open your SQL Server installation files.
