SQL Server Default Port
The default port for the SQL Server Engine is 1433, which is a useful thing to know if you’re working as a Database Administrator (DBA) or Database Reliability Engineering (DBRE) type role.
What’s New in the SQL Server 2022 Install
SQL Server 2022 was announced last week at the Microsoft Build event, which is an annual summit aimed at those of us who are enthusiastic about Microsoft software.
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.
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.
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.
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!
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.
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.
Renaming a computer that hosts SQL Server
When changing the hostname of a computer running SQL Server, system metadata must be updated so that remote connections and applications do not lose connectivity.
Installing SQL Server 2017
Installing SQL is a straight-forward task… but it’s important that things are in-place from the get-go to prevent having to make changes on a live system.
