Check & Restart SQL Server Services on Linux
As of the 2017 Edition of SQL Server we have been able to install SQL Server on Linux. Linux will likely be more of an unfamiliar environment for traditional Microsoft SQL DBAs.
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.
Installing SQL Server on Linux
A post on installing SQL Server on Linux, following the Microsoft SQL Server 2019 Guide (Red Hat). # Install SQL Server.# Install the SQL Server Command-Line Tools.# Connect to SQL Server Locally.# Connect to SQL Server Remotely.
Enabling TCP Connections in SQL Server
Some network protocols are not enabled by default in SQL Server. We need to enable the option and restart the SQL Service to allow TCP connections.
What’s New in the SQL Server 2019 Installation Wizard
The release of SQL Server 2019 happened during the first day of Microsoft Ignite (4th November). Up until now, I’ve been using the release candidates for tests… so it’s good to have it all officialised!
Running Scheduled Tasks in SQL Server Express
Running scheduled tasks in SQL Server Express has to be done differently due to the limitations of the Edition. As well as having a maximum database size of 10GB and 1GB consumable RAM, Express does include the SQL Server Agent.
sqlcmd in SQL Server
The sqlcmd utility allows Transact SQL to be run at the command prompt using ODBC to execute SQL batches for MS SQL Server.
Changing Schemas in SQL Server
This is a post on how-to on changing the schema of a table in SQL Server, moving it from one schema to another using the ALTER SCHEMA [tableName] TRANSFER SQL statement.
