Author: Peter Whyte
-
sqlcmd Examples (SQL Server)
The sqlcmd utility allows you to execute Transact-SQL commands directly from the command line using ODBC, enabling SQL Server batch execution without the need for a GUI. This post contains sqlcmd examples to help you understand it more. sqlcmd is essential for running SQL queries, automating tasks, and…
-
How to Rename Schema’s in SQL Server
Changing the schema of a table in SQL Server can be a rare task for database administrators but a more common requirement for database developers. This guide walks through how to move a table from one schema to another using the ALTER SCHEMA statement. During my time as…
-
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…
-
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…
-
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…
-
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…
-
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…
-
Installing Windows Server 2016 with Hyper-V
This post contains a demo of installing the Windows Server 2016 Operating System on Hyper-V. To install the Hyper-V Role on Windows 10, see this guide from Microsoft Docs: Install Hyper-V on Windows 10. There are two parts to this one:> Create a new Hyper-V Virtual Machine> Install…
Recent Posts
- Granting the VIEW SERVER STATE Permission in SQL Server
- Why Is the Database in “In Recovery” Mode?
- How to View the Definition of a Stored Procedure
- SQL Script to Show Exclusive Locks on Tables
- How to Get SQL Server’s IP Address
Categories
– AWS
– DBA Stories
– Linux
– MySQL
– Other
– Postgres
– PowerShell
– Redshift
– SQL Server
– Windows Server
Tags
Always On Availability Groups (AAG) (3) Certificates & Encryption (3) Change Data Capture (CDC) (2) Database Admin (74) Database Backups & Recovery (13) Database Mirroring (2) Deleting Data (1) Error Messages (4) Git Commands (5) Importing & Exporting Data (2) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (10) Microsoft Patching (2) PowerShell Scripts (1) SQL Server Agent (4) SQL Server Database Files (1) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (14) SQL Server Network Connectivity (3) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance (5) SQL Server Permissions (2) SQL Server Processes (5) SQL Server Replication (2) SQL Server Scripts (13) Windows Admin (21) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (19)