Close
  • Blog
  • About
×
×
  • Blog
  • About
Menu & Search
Peter Whyte DBA Blog
Category

Windows


July 15, 2020
MySQL
SQL Server
Windows
Creating a Linked Server with a MySQL Database

This is my 3rd Linked Server post, and this time it’s to a MySQL database. Noteworthy weblinks: # My Linked Server Blog Posts.# Microsoft Docs – Linked Servers.

Read More
Changing Primary Domain DNS Name of this Computer Failed
May 30, 2020
Windows
“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.

Read More
Test Connectivity to Remote Server Port PowerShell
May 7, 2020
PowerShell
Windows
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.

Read More
Forcing Encryption in SQL Server
May 6, 2020
PowerShell
SQL Server
Windows
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.

Read More
PowerShell Scheduled Task Daily Reboot
May 3, 2020
PowerShell
Windows
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.

Read More
Check SQL Server Feature Installed
April 29, 2020
PowerShell
SQL Server
Windows
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.

Read More
Enable TCP/IP SQL Server
April 25, 2020
PowerShell
SQL Server
Windows
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.

Read More
Domain Join Sanity Checks
October 31, 2019
Windows
Domain Join Sanity Checks

Before joining a Windows Server to a domain, you might’ve had to request firewall rules from the network team to be opened up.

Read More
Creating MySQL Databases and Tables
October 8, 2019
Linux
MySQL
Windows
Creating MySQL Databases & Tables (with added tips)

This is a post on creating databases/tables in MySQL on both Windows and Linux, with added tips to help with general usage.

Read More
Delete Windows.old Files
October 7, 2019
Windows
Delete Windows.old Files

When your machine is upgraded to a newer version of Windows, it leaves behind a C:\Windows.old directory which can be quite large.

Read More
1 2 3 4
DBA Blog

Author: Peter Whyte

GithubTwitterRss

Blog Menu

  • Homepage
  • Projects
  • Notes
  • Archives

Categories

  • AWS (3)
  • Linux (21)
  • MySQL (5)
  • PostgreSQL (7)
  • PowerShell (32)
  • RedShift (6)
  • Scripts (1)
  • SQL Server (55)
  • Windows (40)
  • WordPress (5)

Tags

Certificates & Encryption (3) CSV Files (3) Database Admin (35) Database Backups (5) Data Types (2) Deleting Data (2) Error Messages (4) Exporting Data (1) Featured (6) Git (7) Importing Data (1) Installing SQL Server (9) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (7) Restoring Databases (4) SQL Server Agent (3) SQL Server ETL (2) SQL Server Management Studio (9) SQL Server Processes (4) SQL Server Scripts (2) SQL Tips (2) Windows Admin (9) WordPress Tutorials (2) WSL (10)