Create a Superuser in RedShift
Superusers in RedShift hold the permissions to perform any action in the cluster, the same access as ‘master’ or whatever you named the superuser during creation.
Create a Test AWS RedShift Cluster
Here’s a simple guide on creating a new AWS RedShift Cluster within a personal AWS test environment. Warning, if you’re testing this AWS Service you have to be rigorous with managing the cluster for billing reasons.
Show Last Backup Times in SQL Server
If you’re running a SQL Server and you care about the data held in it, you should already be backing up the databases.
Creating a Linked Server with a MySQL Database
This is my 3rd Linked Server demo post, and this time it’s to a MySQL database. Noteworthy weblinks: # My Linked Server Blog Posts.# Microsoft Docs – Linked Servers.
Testing Connectivity to Remote Server Ports with PowerShell
All admins need a tool to test connectivity to remote servers on TCP ports. In Windows, this is commonly done using PuTTy or PowerShell.
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.
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
To backup a database in SQL Server with Encryption, run the BACKUP DATABASE command with the ENCRYPTION option added to the SQL statement, and specify the valid encryption certificate name.
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.
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.
