SQL DBA Blog

Tag: Database Admin

  • 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 Server 2019 Red Hat repository configuration file.…

    read more

  • 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. This post is a guide on how this is done:# On Windows via SQL Server Configuration Manager.# On Windows using PowerShell. Enable TCP/IP SQL via Server Configuration Manager 1.…

    read more

  • What’s New in the SQL Server 2019 Installation Wizard

    The release of SQL Server 2019 happened during the first day of Microsoft Ignite (4th November). Up until now, I’ve been using the release candidates for tests… so it’s good to have it all officialised! Here’s some notes during my first official SQL Server 2019 installation, using the wizard on a Windows Server host; #…

    read more

  • How to Create MySQL Databases & Tables

    This blog post is a guide on how to create databases and tables in MySQL, from a Windows and Linux computer. The information included here should help beginners who are new to MySQL. To create a new database in MySQL, and many other relational database systems we use the CREATE DATABASE SQL Statement. The meaning…

    read more

  • Installing MySQL 8.0 on Windows

    A simple run-through of installing MySQL Community Server 8.0, including MySQL Workbench on Windows. Don’t forget to checkout the MySQL Installation documentation, and here’s a link to prerequisites. Installing MySQL Open the MySQL installer exe as downloaded from the link above. Accept License Agreement and Next. I would say always choose a Custom install –…

    read more

  • Changing Schemas in SQL Server

    This is a post on how-to on changing the schema of a table in SQL Server, moving it from one schema to another using the ALTER SCHEMA [tableName] TRANSFER SQL statement. During my time as a SQL Database Administrator, assisting with a task like this is a rare event. If you are more of a…

    read more

  • Adding & Removing SQL Features via Command

    This is a quick guide on how to add and remove features from SQL Server via command, following the theme of recent posts. The following areas will be covered within this post;# Check Features Installed on a SQL Server.# Installing a SQL Server Feature (Replication) via Command.# Uninstalling a SQL Server Feature (Replication) via Command.…

    read more

  • Install/Uninstall SQL Server via Command

    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. There’s 4 parts to this one;# Download a SQL Server ISO. # Mount the ISO on a Hyper-V Virtual Machine.# Install SQL…

    read more

  • Creating a Linked Server with a Postgres Database

    In my previous post, I created a Link Server to another SQL Server instance This time, it’s a link to a Postgres database! This guide can be followed from start to finish using the links below. # Install SQL Server (separate post).# Install PostgreSQL (separate post).# Test Connectivity to Remote Server (previous Linked Server post).#…

    read more

  • Create a Linked Server to SQL Server

    Linked Servers in SQL Server allow you to query external databases, such as remote SQL Server instances, Oracle, ODBC or MS Access databases. This blog post contains a demo on how to create a Linked Server to another SQL Server, with links to Microsoft Documentation throughout. I also have more Linked Server demos if of…

    read more

Recent Posts

Categories

Tags

Active Directory (AD) AWS CLI CDC Certificates & Encryption Change Data Capture CSV Files Database Admin Database Backups Data Types Deleting Data Error Messages Featured Git Git Commands Git Log Installing SQL Server Linked Servers Linux Admin Measuring Databases MSSQL SPIDs NetFirewallProfile New-Item PowerShell PowerShell Create Folder PowerShell Delete Files PowerShell ForEach PowerShell Tips PowerShell Version Restoring Databases SQL Server Agent SQL Server ETL SQL Server Management Studio (SSMS) SQL Server Processes SQL Server Scripts SQL Tips SSH SSMS Tips Temp DB Windows Admin Windows Firewall WordPress Tutorials WSL WSL1 WSL2 WSL Ubuntu WSL Version