SQL DBA Blog

Category: Windows Server Admin

Windows Server Admin blog which includes guides to boost performance and efficiency, written by an experienced Microsoft SQL DBA, Peter Whyte.

  • Adding & Removing SQL Features via Command

    This post will guide you on how to add and remove features from SQL Server via the command line. The process includes checking installed features, installing a new feature (such as replication), and uninstalling a feature when no longer needed. The following areas will be covered within this…

    Read More

  • Install/Uninstall SQL Server via Command

    Installing and uninstalling SQL Server via command line can be useful, especially in environments without a GUI. In this guide, I’ll walk through installing SQL Server on Windows Server Core, in a local Hyper-V test environment. At the end I’ll also uninstall SQL Server from a PowerShell terminal…

    Read More

  • Guide for Setting Up Windows Server Core

    When you need to setup Windows Server Core, it’s useful to first familiarize ourselves with the key PowerShell commands that configure the server. Windows Server Core is a minimal installation option that provides a lightweight, command-line interface (CLI)-only environment, making it ideal for environments requiring lower resource usage…

    Read More

  • Joining a Windows Host to a Domain

    This post contains a demo of joining a Windows Server onto a test Domain, which I created in my previous post (Installing Active Directory on Windows Server 2016). Joining a Windows Computer to Active Directory Domain Services is required in 99% of Corporate environments, and is usually a…

    Read More

  • Installing Active Directory on Windows Server 2016

    This post contains a demo installation of Active Directory Domain Services on Windows Server 2016. It follows a previous post for a series of test lab configuration posts. Microsoft docs on installing AD on Windows Server can be found here: Install Active Directory Domain Services Configuring a Windows…

    Read More

  • How to Install Windows Server on Hyper V

    This guide provides a step-by-step walkthrough for installing Windows Server on Hyper-V. By the end of this tutorial, you’ll have a fully operational Windows Server VM, ready for further configuration and testing. If you need to install the Hyper-V role on Windows first, refer to this guide –…

    Read More

  • Resolving “Windows could not start the SQL Server”

    If you encounter the message “Windows could not start the SQL Server on 127.0.0.1”, it signifies a problem preventing the SQL Server service from starting properly. This error is broad and can stem from various causes. Diagnosing the Issue To uncover the root cause, we can check Windows…

    Read More

  • “Content from the website listed below is being blocked” on Windows Server

    When managing a Windows Server, you may encounter the message:“Content from the website listed below is being blocked by the Internet Explorer Enhanced Security Configuration.” This occurs because Internet Explorer Enhanced Security Configuration (IE ESC) is enabled by default on Windows Server to protect against malicious websites and…

    Read More

Categories
Tags

Always On Availability Groups (AAG) (4) AWS (4) AWS Redshift (6) Database Admin (72) Database Backups & Recovery (14) Database Mirroring (2) Error Messages (5) Failover Cluster Instances (FCI) (1) Git Commands (6) Importing & Exporting Data (2) Linked Servers (3) Linux Administration (2) Logging & Monitoring (1) Microsoft Patching (2) MySQL (4) Postgres (6) PowerShell Scripts (2) SQL Certificates & Encryption (3) SQL Server Agent (5) SQL Server CDC (2) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (17) SQL Server Networking (3) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance Tuning (6) SQL Server Processes (SPIDs) (7) SQL Server Replication (2) SQL Server Scripts (13) SQL Server Security (4) SQL Server Storage (10) Windows Admin (20) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (18)