Close
  • Blog
  • About
×
×
  • Blog
  • About
Menu & Search
MSSQL DBA Blog
MSSQL
September 5, 2022
PowerShell
Windows
Create a New Firewall Rule with PowerShell

Create a New Firewall Rule with PowerShell This is a short post to share a PowerShell script that will create a new Windows Firewall Rule on a local computer.

Read More
Show Line Numbers SSMS
September 3, 2022
SQL Server
SSMS Show Line Numbers

This post contains a guide on how to show line numbers in the SSMS query window. Useful if you want to see line numbers while you code.

Read More
SQL Server Filegroups
September 1, 2022
SQL Server
Add a Filegroup to a Database in SQL Server

This post contains a demo on how to add a new Filegroup for a database in SQL Server. Most databases work well with single data/log files and do not need this.

Read More
Check PowerShell Version
August 31, 2022
PowerShell
How to Check PowerShell Version

This post is a guide on how to check your PowerShell version on a Windows computer. I’m using $PSVersionTable to get this info.

Read More
SQL Server Disable CDC
August 30, 2022
SQL Server
Disabling Change Data Capture in SQL Server

This post contains a demo on how to disable CDC (Change Data Capture) in SQL Server 2022. The sp_cdc_disable_table and sp_cdc_disable_db in-built MSSQL SPs are what we should use to disable CDC in SQL Server which is explained more below.

Read More
Enable CDC in SQL Server
August 29, 2022
SQL Server
How to Enable CDC in SQL Server

This is a post on how to enable Change Data Capture (CDC) in SQL Server. Enabling this on a database and table will allow the recording of activity when tables and rows have been modified.

Read More
Create Scheduled Task Windows PowerShell
August 28, 2022
PowerShell
Windows
How to Automate PowerShell Scripts with Task Scheduler

This post is useful if you need to run PowerShell Scripts automatically with a set schedule in Windows. In the demos below, we’re creating new Scheduled Tasks via GUI and with PowerShell.

Read More
SQL Server Default Port
August 26, 2022
PowerShell
SQL Server
Windows
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.

Read More
SSMS Run as a Different User
August 25, 2022
SQL Server
Windows
How to Connect to SQL Server with a Different Domain User Account

This post is a guide on how to connect to SQL Server with Windows Authentication, but using a different Domain User rather than your own.

Read More
PowerShell Restart Service Multiple Hosts
August 24, 2022
PowerShell
Windows
PowerShell Restart Services on Multiple Hosts

In this post, we’ll walk through a script that restarts services on multiple remote hosts using PowerShell. A single PowerShell command will be run on several computers at the same time.

Read More
Rename SQL Server
August 23, 2022
SQL Server
Windows
How to Rename a Computer that Hosts SQL Server

When changing the hostname of a computer that is running SQL Server, we have to update system metadata so that remote connections and applications do not lose connectivity.

Read More
PowerShell ForEach Get-ChildItem
August 22, 2022
PowerShell
PowerShell ForEach Loop Tutorial

Looping is a fundamental concept in PowerShell, and in programming in general. It’s needed for various situations where we need to work with one object at a time within an array/collection of objects.

Read More
1 2 3 4 … 14
Peter Whyte DBA

Peter Whyte

Blog Menu

  • Homepage
  • MSSQL DBA Blog
  • SSMS Tips
  • SQL Notes & Links
  • DBA Blog Archives
  • WSL Windows Tips
  • Projects

Categories

  • AWS (5)
  • Linux (34)
  • MySQL (5)
  • Postgres (7)
  • PowerShell (48)
  • RedShift (7)
  • SQL Server (78)
  • Windows (64)
  • WordPress (2)

Tags

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