This is a post on moving tables from one schema to another in SQL Server. A semi-rare task for myself, although it could be more frequent for those who use schemas for things like staging tables/versioning.
Hi!… I’m Peter Whyte.
Hello and welcome to my website, which is a place for me to store all my notes as I blog away as a software enthusiast.
It’s been an amazing journey working away at this blog which I started in January 2017. Like anything, practise makes perfect. My hope is to continue to improve my writing and all the other skills required to run a blog. It’s been a long and fun journey so far… and I feel like I’m just getting started!
I hope you enjoy, and feel free to comment on posts or write me a line any time. I’d apprecaite any critique or feedback you may have.
This is a post on installing SQL Server via command; I have a Windows Server 2016 Core running on a local Hyper-V test environment, and I’m installing SQL Server 2019, then uninstalling it.
Windows Server Core is the CLI only version of the Windows OS. This post is a run-through of configuring a new Windows Server 2016 Core host, detailed in the following steps;
A run-through of joining a Windows Server onto a test domain which created in my previous post. There’s 2 parts to this one;# Creating a New Domain User Account.# Joining a Windows Server to a Domain.
This is a run-through on installing Active Directory within a Hyper-V test environment. There’s 5 parts to this one: # Create a Hyper-V Private Network.# Configure Windows TCP/IP Settings.# Rename the Windows Server Host.# Install Active Directory.# Promote the Server to a Domain Controller.