SQL DBA Blog

Author: Peter Whyte

  • 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. This guide should hopefully help you when you need to check the status of SQL Services…

    Read More

  • “Changing the Primary Domain DNS Name of this Computer Failed” – Server 2008 R2

    Within an AWS account I have a Windows Server 2016 Domain Controller, and I’m trying to join a Windows Server 2008 R2 to my Whyte.net Domain. I get this error: Changing the Primary Domain DNS name of this computer to “” failed. The name will remain “whyte.net”.The error…

    Read More

  • 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. This post is a note on my favourite way of testing remote TCP connections in Windows, which is using PowerShell:# Check a Port is…

    Read More

  • 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. SQL Server has an option where we can force all connections on a SQL Server to be encrypted,…

    Read More

  • 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. This guide follows the Microsoft Docs page – Write Execution Trace…

    Read More

  • Backing up a SQL Server Database with Encryption

    Backing up a SQL Server database with encryption is an essential practice when dealing with sensitive data, particularly if backups are stored off-site or include private customer information. SQL Server provides a secure method to back up databases using encryption by specifying an encryption certificate with the BACKUP…

    Read More

  • How to Backup a SQL Server Certificate

    Backing up SQL Server certificates is essential if you use them, especially for encrypted database backups that may need restoration on another server. This guide explains how to securely back up a SQL Server certificate and its private key. Backing up a SQL Server Certificate 1. Check Existing…

    Read More

  • 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. Sometimes I forget how it’s done, so a worthy enough post. Below I’m creating a daily reboot…

    Read More

  • 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. You may find them within the Setup Bootstrap folder (“C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\SQL2019”) or you might already have the ISO handy. We can open…

    Read More

  • 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. Install SQL Server 1. Get connected & download the Microsoft SQL…

    Read More

Recent Posts

Categories

– AWS
– DBA Stories
– Linux
– MySQL
– Other
– Postgres
– PowerShell
– Redshift
– SQL Server
– Windows Server

Tags

Always On Availability Groups (AAG) Certificates & Encryption Change Data Capture (CDC) Database Admin Database Backups & Recovery Database Mirroring Deleting Data Error Messages Git Commands Importing & Exporting Data Linked Servers Linux Admin Logging & Monitoring Measuring Databases Microsoft Patching PowerShell Scripts SQL Server Agent SQL Server Database Files SQL Server Data Types SQL Server Management Studio (SSMS) SQL Server Network Connectivity SQL Server on Linux SQL Server Patching SQL Server Performance SQL Server Permissions SQL Server Processes SQL Server Replication SQL Server Scripts Windows Admin Windows Authentication Windows Automation Windows Events Windows Firewall Windows Subsystem for Linux (WSL)