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.
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.
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.
This is a quick guide on how to check which features are installed on a SQL Server.Open your SQL Server installation files.
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.
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.
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!
This is a quick guide on how to add and remove features from SQL Server via command, following the theme of recent posts.
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.
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 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.