Skip to content

DBASco

Database & System Engineering Blog

  • Home
  • SQL Server
    • MSSQL Scripts
  • PowerShell
    • PowerShell Scripts
  • DBA Cheat Sheet
  • Other Posts
  • About
How to Install Firewalld on WSL Ubuntu
OtherTagged Networking, WSL UbuntuLeave a Comment on How to Install Firewalld on WSL Ubuntu

How to Install Firewalld on WSL Ubuntu

March 2, 2024March 4, 2024

This post contains installation notes for installing firewalld on Ubuntu Linux running within Windows Subsystem for Linux (WSL). What is Firewalld? Firewalld is a tool that helps users to manage the firewall on their Linux machine. With firewalld, users can […]

SQL Server Default Ports
SQL ServerTagged MSSQL DBA Tips, NetworkingLeave a Comment on SQL Server Default Ports

SQL Server Default Ports

March 1, 2024March 3, 2024

The SQL Server default ports that the SQL Engine runs on is 1433. This is a useful thing to know if managing SQL Server databases, however SQL Server can be configured to run on a variety of port numbers. For […]

How to Identify Listening Ports on Windows
OtherTagged NetworkingLeave a Comment on How to Identify Listening Ports on Windows

How to Identify Listening Ports on Windows

February 4, 2024February 3, 2024

Discovering the processes associated with TCP or UDP ports on a Windows host is crucial for various reasons, from validating service ports to proactively addressing potential security concerns. This guide will show two efficient methods to quickly identify and analyze […]

Enabling TCP Connections in SQL Server
PowerShell, SQL ServerTagged MSSQL DBA Tips, Networking, PowerShell Scripts1 Comment on Enabling TCP Connections in SQL Server

Enabling TCP Connections in SQL Server

January 30, 2024January 30, 2024

Ensuring that TCP connections are enabled in SQL Server is a crucial step for optimal network communication. In this guide, we’ll walk you through the process using two popular methods: SQL Server Configuration Manager and PowerShell. The aim is to […]

Testing SQL Server Connectivity with PowerShell
PowerShell, SQL ServerTagged MSSQL DBA Tips, Networking, PowerShell Tips3 Comments on Testing SQL Server Connectivity with PowerShell

Testing SQL Server Connectivity with PowerShell

January 27, 2024March 13, 2025

For a straight-forward guide on how to test SQL Ports are open with PowerShell, check post: Testing Connection to SQL Server Ports with PowerShell Testing to ensure connectivity to remote servers is a crucial step for system administrators. In the […]

PowerShell: Creating a New Firewall Rule
PowerShellTagged Networking, PowerShell Tips, Windows Firewall2 Comments on PowerShell: Creating a New Firewall Rule

PowerShell: Creating a New Firewall Rule

January 17, 2024March 13, 2025

In this blog post, we’ll guide you through the process of creating a new firewall rule using PowerShell. Firewall rules help control network traffic, allowing or blocking specific connections. Setting up the right rules improves security and ensures necessary applications […]

Popular Posts

DBASco (SQL DBA Blog) - 2024